Cool that worked, cheers. Sorry to be a pain but using this method how do I link a database field to a text box. For eg using the vb properties box of the textbox you select the ado control in the data source box and the data field property in the data field?
Is there any way to make connection paths in the vb Ado control generic?
From example hardcoded can look something like below:
Data Source=" & App.Path & "\db.mdb
Can you do something that will have the same effect on the ado?
I am using the following connection in VB to connect to an access db:
cn.Open ("Provider=Microsoft.jet.oledb.4.0;" & _
"Data Source=" & App.Path & "\db1.mdb")
However I am getting a runtime error saying that it cannot find the file but it also states the path to...
How can I get a datagrid to print only a certain set of data, say relating to a date or a number entered into a text or input box. I have tryed a number of sql statements but can't get anything to work.
I am trying to create an order form in Vb. There are text boxes to allow for the entry of quantities of a product required. However they will not all be used all the time so I need a way to save info. from only the full text boxes to the database. Any ideas?? I tryed a loop using a counter...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.