query

[kingsgambit]

I have build a database which contain several queries that I have designed using access.
I would like to be able to write these queries in vb code instead, does anybody know of examples on how to write them, or any websites that would teach me.

 

[kingsgambit]

I am in the process of building a database for the company I work for, they then want to sell it to the clients. I made the database into MDE database, this protects the forms and vb code but not the queries.
I know I can password the whole database but if the queries where written in vb they would be protected.
The only way I have thought of is to copy the SQL of the query into the row source

 

[Jimbob]

If you really wanted to you could convert all your queries to SQL strings and call them from vb,

i.e. on the 'OnOpen' event of the forms you could open a recordset (using SQL and vb), then use command buttons e.t.c. for moving through the recordset and populating your fields from the recordset...