Recent content by NewfieLab

I have a multitable query created in a access 2000 database and all the tables in the query have one to one relationships. I have a connection made to the database in visual basic and a recordset created to access the data in the query based on a sql statement. both the connection and the...

this is the way I do this; the first thing I do is to make a small table in the database the has a column with the different items you want to appear in the list in the order you want them to appear in the list. Then you need to put an ADO Data Control on the form and set is connection string...

I have a multitable query created in a access 2000 database and all the tables in the query have one to one relationships. I have a connection made to the database in visual basic and a recordset created to access the data in the query based on a sql statement. both the connection and the...

I almost have this done but I am held up by a syntax problem. below is the info "EnvConnect" is the name of my connection to the database and I works fine "qrySampleInfo" is the name of the query in the database I want to connect to (it also works fine), and...

I don't know if this will help you with your problem, but the following is how I link my form to an access database; You need a connection to the database and a recordset, for the purpose of this example i will call the connection "tom", the recordset "bob", the database...