Recent content by jamiek555

Run Module from Button Sorry for my lack of skills - I am still learning... I know how to create a form with a button and how to set the "on click" event - but I am not sure how to direct it to run a module. Can someone please post detailed instructions? My Module is called...

Thanks...all better now... Thanks Casey, Not only did I need to do this, but I needed to switch the DAO library above the ADO library. Now I am stuck on getting my module to run when I open a query (see my post in the Queries section). Jamiek

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

Never Mind... ...I found it...:D

DAO vs. ADO Library How do you set the DAO library higher than the ADO library? Thanks in advance

DAO vs. ADO Library How do you set the DAO library higher than the ADO library? Thanks in advance

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...

Sorry I wasn't very clear. Here's what I am looking at TblProducts (Contains following fields): ProductID (key) (for example Product A) ProductDescr ProdInInventory (# of product I have in stock, for example 10) TblOrders (Contains following fields): OrderID (key) ProductID ((key - linked...

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...