I am trying to access a table which is linked to a database in a local directory. I use the Common Dialog Box to get the path for the database on the server which was mapped to the local machine. I can move the linked tables around on the default (C:) drive and I can link to the table on drive...
I am trying to set the RowSource property of a DBCombo box from code. The DBCombo control name is dbcSource. The data control name used with this control is dtaSource. Selection dtaSource from the properties box works fine. But this line returns a Type Mismatch error:<br>
<br>...
I am attempting to use stored queries with parameters but I cannot seem to get it to work. I have already created the query with the visdata program. If I try to open the query directly as a recordset it responds with a not enough parameters error.<br>
<br>
How do I set a reference to the query...
Could someone please tell me what is wrong with the following code.<br>
<br>
With rstDestination<br>
.FindFirst "USERNAME = " & strUserName<br>
<br>
The recordset is opened as a dynaset, the variable strUserName is obtained from a lookup in a different table and the correct...
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.