Setting and establishing a default connection before a SQL statement
Is it necessary to establish a connection and set it to the default before and after the execution of any SQL statement? I am develolping a multi-user system with 10 users in Visual Basic 6.0 with SQL Server 2000 and i need to know this for my setup.
Is it necessary to establish a connection and set it to the default before and after the execution of any SQL statement? I am develolping a multi-user system with 10 users in Visual Basic 6.0 with SQL Server 2000 and i need to know this for my setup.
2445 pts. 
Source code for multiuser programming in VB 6 with SQL Server 2000
hi to all, I'm developing a security software in Vb 6.0 with Sql Server 2000 as back end wherein 10 users will be there. I'm a newbie in multiuser programming. The question before me is that how to proceed further. My stand alone code is almost ready 50%. I'm using Ado for establishing connection...
hi to all, I'm developing a security software in Vb 6.0 with Sql Server 2000 as back end wherein 10 users will be there. I'm a newbie in multiuser programming. The question before me is that how to proceed further. My stand alone code is almost ready 50%. I'm using Ado for establishing connection...
How to pass value at run time from VB 6 to Access 2000 Query for reporting
I have developed a sall application. Data is in Access 2002, Development is in VB 6. For reporting I have designed Queries, using the queries I have designed the reports. It works fine. While run time I accepts the criteria or value from user, based on that I have to show reports. My question is...
Answer Question
| Oct 6 2008 10:19 AM GMT
Access, Visual Basic for Applications, Visual Basic developers
I have developed a sall application. Data is in Access 2002, Development is in VB 6. For reporting I have designed Queries, using the queries I have designed the reports. It works fine. While run time I accepts the criteria or value from user, based on that I have to show reports. My question is...
Answer Question
| Oct 6 2008 10:19 AM GMTAccess, Visual Basic for Applications, Visual Basic developers
Text Box Only Allows Certain Characters
I have a VB6 app running on windows application server, accessed via Symbol scan gun. Sometimes the user can't enter data they need to into a text box. I could enter spaces but no other characters or numbers. After entering spaces I tried to backspace and a box showed up (in the txtbox field)...
I have a VB6 app running on windows application server, accessed via Symbol scan gun. Sometimes the user can't enter data they need to into a text box. I could enter spaces but no other characters or numbers. After entering spaces I tried to backspace and a box showed up (in the txtbox field)...
crystal report 2008 and visual basic 6
Hello friends. I have a development in vb 6 and i need to use crystal report 2008 this because my client has this version of crystal. I need to include the object of this version of crystal in order to execute the report but i don't know wich control to use. Please help me. Thanks in advance.
Hello friends. I have a development in vb 6 and i need to use crystal report 2008 this because my client has this version of crystal. I need to include the object of this version of crystal in order to execute the report but i don't know wich control to use. Please help me. Thanks in advance.
How to set Font in word document generated using VB 6.3
How to set Font in word document generated using VB 6.3
How to set Font in word document generated using VB 6.3
Send mail from my second mail-account in Lotus Notes
Lotus 6.5 / VB6 user In our company, we have created an email account, accessable to some collegues. For some applications (sending an emergency SMS), mail has to be send out from that new address. The email content is automatically generated in VB (using Excel). With the script I use, I don't...
Lotus 6.5 / VB6 user In our company, we have created an email account, accessable to some collegues. For some applications (sending an emergency SMS), mail has to be send out from that new address. The email content is automatically generated in VB (using Excel). With the script I use, I don't...
How to save a file in VB 6
How to save any type of file to a particular folder after we get the file from common dialog control in VB 6.0
How to save any type of file to a particular folder after we get the file from common dialog control in VB 6.0
Microsoft Access in a Server
Hi I am using Vb6 as front-end which is installed in the client machines and MS access 2003 in my server as back-end. Can I create local copies in each client system and at a particular time I need to update the server database with the local databases
Hi I am using Vb6 as front-end which is installed in the client machines and MS access 2003 in my server as back-end. Can I create local copies in each client system and at a particular time I need to update the server database with the local databases
How can i position the modal form
How to change the position of a modal form on the screen thourg code in vb 6.0
How to change the position of a modal form on the screen thourg code in vb 6.0
Accessing SQL Server with a Visual Basic application
I have an application in Visual Basic 6 with SQL Server as the back-end. It is supposed to be run on a server, but it will not access the server when installed and run on a client’s machine. I think it might be a code issue; I have used the following coding at form load: cnh =...
I have an application in Visual Basic 6 with SQL Server as the back-end. It is supposed to be run on a server, but it will not access the server when installed and run on a client’s machine. I think it might be a code issue; I have used the following coding at form load: cnh =...
Receiving a DOS output with a Visual Basic script in SQL
I would like to solve this following complex script in SQL by using Visual Basic, either version 5.0 or 6.0. My first table name is tblClient, with fields ClientID and ClientName. My second table name is tblPurchase, with fields ClientID, Item Name, Qty and Price. I would like to pass one SQL...
I would like to solve this following complex script in SQL by using Visual Basic, either version 5.0 or 6.0. My first table name is tblClient, with fields ClientID and ClientName. My second table name is tblPurchase, with fields ClientID, Item Name, Qty and Price. I would like to pass one SQL...
How do I stop my VB6 application on a Windows2003 server using up all the connections on my 9i DB?
The root of the problem seems to be w3wp.exe interacting with the 10g client we use to attach to the 9i DB (due for upgrade to 10g soon). I can't really change the VB component since it's also required to run on Windows2000 - which it handles with no problems against the same DB. Also can't upgrade...
The root of the problem seems to be w3wp.exe interacting with the 10g client we use to attach to the 9i DB (due for upgrade to 10g soon). I can't really change the VB component since it's also required to run on Windows2000 - which it handles with no problems against the same DB. Also can't upgrade...
How to show list view in Microsoft Access report
i sample out some of the data from database. i shows my sampling in a listview in visual basic 6.0. now i want to show the sample to microsoft access. how's the coding?
i sample out some of the data from database. i shows my sampling in a listview in visual basic 6.0. now i want to show the sample to microsoft access. how's the coding?
How to play songs while program's exe (written in VB 6) runs.
Please show me the code to -- play songs, through Windows Media Player 9, while my program's exe (written in VB 6) runs. What I have tried is, In a form I have taken 1) 'Windows Media Player' control ('wmp.dll') from 'Project' Menu --> 'Components'. 2) 'FileListBox' control, which contains...
Please show me the code to -- play songs, through Windows Media Player 9, while my program's exe (written in VB 6) runs. What I have tried is, In a form I have taken 1) 'Windows Media Player' control ('wmp.dll') from 'Project' Menu --> 'Components'. 2) 'FileListBox' control, which contains...
Change Fonts of Menu Item Through VB6
My program is in varnacular language, i. e. input and output are in Gujarati (Indian) language, by changing the font to "Gopika.ttf". So, during the execution of my program I want to show menus also in Gujarati, i. e. 'Gopika' font. Normally, we change this from desktop --> properties -->...
My program is in varnacular language, i. e. input and output are in Gujarati (Indian) language, by changing the font to "Gopika.ttf". So, during the execution of my program I want to show menus also in Gujarati, i. e. 'Gopika' font. Normally, we change this from desktop --> properties -->...
connecting a excel spreadsheet with visual basic
Hi can i connect a excel spreadsheet to form in visual basic.. i must do calculations in runtime to that spreadsheet.. can u tell me a sample code.. Thanks,
Hi can i connect a excel spreadsheet to form in visual basic.. i must do calculations in runtime to that spreadsheet.. can u tell me a sample code.. Thanks,
