No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
77 Posted Topics
[quote=suneel kar;406904]anyone who can help me regarding how to read data from .dbf files recordwise.[/quote] See it in the thread [B]Access to any type of DB's possible[/B] for your dbase and [B]opening 2 files[/B] for your writng records to text files regards AV Manoharan
Your project requires first a com control component to sniff the USB port, where you have connected your video device. Try to use the Microsoft Comm Control component. If you know that it is very easy. Another way is to use thw Window API which has the following code to …
Please check up whether after placing the period(dot) after DataCombo1 the methods RowSourse and ListFields are poping up. If they are, please get back to me. Yor connection strings are having some problem that I will tell you.
If you are using SQL Server in you computer please switch on the Query Analyzar. It will ask you the user name nd password. If both are sa fine. Pull down the Help menu Choose its index. On the Blank space just type in Bacup and choose Backup(Described). Click Display. …
[quote=evstevemd;413737]Hi to all, is there any place i can download MSDN Library for VB 6.0? I really need it! with regards![/quote] You are already on the true path, where it allowed you to post this question. Search.. Search.. THE NET is a resirvior for many things. Any thing any time …
[quote=yasirfarid;395749]hello, i am using picture box, and coding on form load P1.Picture = "D:\My Document\My Pictures\Display Picture\ICE.BMP" why it gives "TYPE MISSMACH" Error. plz reply soon. Yasir[/quote] The correct syntax is P1.Picture = LoadPicture("C:\MyPict.bmp") thanks to veena
Anud, Please look in the thread [B]Read Me. Access to any type of DB is possible[/B] started by me. Happy Programming AV Manoharan
// Your whole program code is reassembled and bugged as below. kido!! public class Test { //variables char a = 'a'; public static void main(String args[]) { if (args.length < 1) { System.out.println("Not enough arguments"); } else { System.out.print("The number of character 'a' found is: "); Syste.out.print(Count(args[1])); } } public …
[quote=tgifgemini;414534]I am importing data from access file to a spreadsheet. One of the input field is a "comment" field with a full paragraph of comments. Some of the target cells in the spreadsheet displays "##########". But when I click on the cell, the Menu bar on top of the spreadsheet …
[quote=dmotah;413678]hi, im using msaccess as database. can u plz tel me how to delete records using vb (it should serch nad delete) tkx[/quote] If you can acceess a database and retrieve a particular table from it, definetely, you can search,insert rows,delete rows/the entire table,alter,update the whole things. Why ask? Just …
[quote=shardulDoon;414255]can anybody tell me how to create a new dll in vb6 and use it , thanxs.......[/quote] On the new Project window, instead of selecting standard exe, select Activex DLL. write the code. run and debug it. once satsfied make the dll by giving a suitable name to it. And …
There are so many postings on this forum regarding text file accessing. Please give a search for "Text File" you will definetly find couple of true codes. The search pannel is on the right hand corner of the front page. Regards AV Manoharan
Elanch, Please contact me through the thread. I am finding difficulty to read your private mail. It eats up my time. Are you all positive to my enquiry? Please answer me. Regards AV Manoharan
The [B]SQLiteDB.dll[/B] has to be little [B]polished[/B] to make a [B]COM wrapper[/B]. If you could understand any thing on the three boldfaced, you can do it. Because it can be implimented in VB (For that matter ASP, VBScript, Dot NET etc. which support COM). Search in the net. Some brilliant …
Your problem is not clear. Please explain it without giving the out put of the text file.
[quote=tgifgemini;406999]Hello everyone, is there a posibility that I can look up email addresses from outlook email address book instead of accepting email address from an inputbox or hard-coding it? See my codes below: Thanks. [code] SENDEMAIL: Set OutlookApp = CreateObject("Outlook.Application") Set OutlookMail = OutlookApp.CreateItem(0) OutlookMail.To = EmailID OutlookMail.Subject = "Project …
See, here I am going to explain for all concerned in this forum, about the two types of Data access objects which you can use in your VB (?). There are so many postings on this subject. The duo is [B]DAO[/B] & [B]ADO[/B]. It is not misspelled acronym like PHP …
[quote=guru511;405592]thanq very much vbCNEW but how can i find the length of the arr i mean i dunno how many splits nah.... if i want to use arr(0),arr(1)..... where should i stop.... arr.length is not working....[/quote] stop it on [U]ubound[/U] AV Manoharan
It is a question of a combobox that is to be activated (Fiiled with data, perhaps, according to the selection done in the other combo and vice versa.) Let jatinder explain it some more. happy programming regards AV Manoharan.
[quote=debasisdas;406218]from vb6.0 u can connect to all versions of ACCESS.[/quote] Dear Das, Please ask Laoli what type of Connection (DAO or ADO) he/she has used to gain access to Access database. [COLOR=#000000]conspicuously[/COLOR] [COLOR=#000000]he/she is silent after starting the thread.[/COLOR] [COLOR=#000000][/COLOR] [COLOR=#000000]regards[/COLOR] [COLOR=#000000]AV Manoharan[/COLOR]
Ro, Please gauge your task yourself. The complex algorithm which you have to translate into workable codes in VB. Of course, there are off-the-shelf objects and methodes in VB. But to use those things my openion is that you have to have above medium level programming ability in VB. From …
How can you edit an excel file without having excell installed. No way. But there is a way arround. First your program should check whether excel is installed or not. If installed take the normal course for creation editing etc. If not installed, take another course in you program for …
The file Access component consists of two objects that give script access to textfiles. The textstream object lets your script open,read from and write to text files. Caution: These objects cannot be used with binary files! First create a filesystemobject and bind it to a Binder by the set command. …
[quote=coco86;406159]thnx ..... im happy to join this forum....[/quote] If you have any problem with string handling, remember it is not because of VB. I will tell you the clue if you are interested. regards AV Manoharan
[quote=QVeen72;406243]Hi, Place the Timer in any of the Form, and set its "Interval" 10000 (for 10 Seconds) Write the Checking code in Timer1_Timer Event, Make the Event as Public and u can access it from every where. If u have a MDI Form, then forst place a Frame Control and …
[quote=mayank_ati;406271]how can i change the path of the database from which i retrive data on run time.... i mean if the database is shifted from server to any othe location the how can the path of the database can be shifted.....[/quote] Mayank, please see the thread [B]Read Me: Access to …
[quote=Naveed_Cn;399312]Hi Everyone Please anyone tell me how can I use the following code in vb6 Module. Dim db As Database Dim rs As Recordset Private Sub Form_Load() Set db = OpenDatabase("C:\MyDatabase.mdb") End Sub Thanks in advance[/quote] The above program code is correct provided, there exists MyDatabase.mbd in C:\ If it …
[quote=tgifgemini;399676]Good morning everyone - I am using VB6. I need your assistance. I used the "CopyFromRecordset" function to populate my spreadsheet. Some of the fields in the access file has date values and some has number values (integers), but after importing into the spreadsheet, the numbers convert to date values(1/1/1900) …
[quote=mybellame;399783]Hi, How can I change the current recordset in a form to a new recordset using a query in vba? i.e. To populate the recordset in my form I have a combo box that is used in a query to populate the recordset. The recordset is a subset of my …
Dear Rob, The syntax of the case stmnt is not that what you have used. Though a if -else stmnt can be substituted for a case stmnt and vise versa, an assignment with in the case stmnt. has to be as follows. This is because a case stmnt will return …
See, you have a ADO cursor.(recordset) right. The following loop iterate the cursor from the first record to the last. A flag is to be set true if an existing FCUIPAddress is found in the iteration and the other two fields are updated with your Text fields Dim AlreadyDone as …
[quote=QVeen72;397122]Hi, Sorry, Remove Distinct In last 2 statements.[/quote] It may also give error. For totalling a field always use a place holder using the key word AS eg. "SELECT SUM(myField) AS TtldField from mytable;" regards AV Manoharan
[quote=yasirfarid;395856]is there any body who know coding for Save and Load Picture on Database (SQL 2000) thnx Yasir[/quote] I think Yasir has used the word save and load for a database meaning creating a table and retreaving data held in it. Sure, basically computer view everything digital. You can store …
Jatinder, Whenever I open your thread to answer I feel jittery. Do you know why?. It is because of the way you have presented your problem. I can understand your urgency. But you should restrain from adding one after another your problems in one thread itself. It is very difficult …
[quote=kshrini;395391]Hi All, I've developed an application in VB6. All forms are designed at 1024X768 scren resolution. But when I open this application at lower or higher resolution all controls get disturbed. Any clue....[/quote] Clue? Well, you have developed all your forms to run in high resolution screen. Then why you …
Wobbles, Why do you unload all those program bugs in your thread. The answer to your problem is in the thumbnail, that you had added additionally. Go through it. Best Wishes. AV Manoharan
See, your particular problem is to be solved in two stages. 1. Create a database having presently two tables. Boxtable and Filetable Boxtable will have all the fields which identify each of them. Your filetable also should contain all those detail fields which your company looks for. Both these tables …
Naturally, it will remove only from the first line, because after your label BYE the program encounters the End Sub and exits. There hast to be an outer loop that reads every line of text from your text document, and within that, your program has to find the line number. …
[quote=VBWayne;392707]I'm going to be passed a dos based command to my vb6 program. I would like to take the multiline output of that command and create a command line command for each line it generates. The only way I know to do this at the moment is to pipe it …
[quote=QVeen72;392915]Hi, Use [B][COLOR=green]"Split"[/COLOR][/B] Function. [code] Dim MyArr Dim i As Long MyArr = Split(TextBox1.Text, VbCrLf) For i = 0 To UBound(MyArr) Debug.Print MyArr(i) Next [/code] Regards Veena[/quote] A better way is as follows If InStr(ptext,chr(10))> 0 Then MsgBox " ptext contains chr10" endif regards AV Manoharan
[quote=Darshanaa;392529]hi can i be some examples of store mgt projects example live online.for reference.i need some guidance for my project. what is documentation in software designing.[/quote] See, Darshna, a Stores Mgmnt consists of a database where we store the commodities (Stock) as a table having unique partno,description,qty,ListPrice,CostPrice etc.etc. This is …
Normally the routers contain one USB port and anoher Ethernet Port. You can use either of the two. See, from your explanation, already you have connected your pc with the USB. So, your LapTop cannot be connected directly with the router. You have to install a bridging software such as …
For a machine independent ODBC data source, you better use the File Data Source.
I think it is the code inside the next click that is bringing the same record again. Inside the next click, what presently searching is the first occurance of your Yasir, or whatever name. Instead of it, your datacombo should move to the next occurance of yasir in the combo. …
Application path is set by your installation program. Other wise if you want all the applications that are installed under an OS (windows), you have to search the registry and/or the directory ..\Program Files\the name of the directory containing the application. Normally they have the mnemonic names of the applications.
[quote=Mr.Wobbles;388154]I will, thank you[/quote] Cocurrancy control is a major issue in Database programming. Are you in a multuser environment?. If not your own adding and deleting is throwing this excepition. You have to declare your cursor to be optimistic so that it take care of a dynamic update. see to …
The file name in msdos FAT16 Filesystem environment takes only 8 letters and an optional period(dot) and upto 3 character extension. You should have formated your drive with FAT32. So that long file name and extension can be given for a file. Windows recoup this compatibility problem by restricting to …
See, every control event is associated with the form at the design time itself and when it become activated it automatically wait for all control events associated with that form. Why, you want specifically mention in your program to wait for the control to happen I can't understand. Please do …
A script file is never compiled, We have VB scripts, Java scripts.. why the very HTML is a script. Bu they only run in their own environment. The .bat files run in MSDOS environment. Correct? if you create .bat file in windows it changes its icon to notify you that …
The End.