Search results

I am using Acc2000. I have a module written that I would like to run as soon as I open a particular query. It is not a function - it is a procedure. I do not want to use a form (with a button) to run the module. How can I do this? Thanks, JamieK

I am using Access 2000. When I step through or run the code below and get to the "Dim db as Database" line, it gives me an error: Microsoft Visual Basic: Compile Error - User-defined type not defined Why? How can I fix this? Do you see any other glaring problems with my code? Thanks in...

I think this should be simple...but.... I have a table called "BOOKS" that lists all the books I stock. The "BOOK_INVENTORY" field contains the number of copies I have in stock (e.g. 10 copies). I have a query called "BOOK ORDERS" that lists the Order No., Order Line No., the book ordered and...