Recent content by glove008

Is there a way to "refresh" the reports collection like with tabledefs? My problem is that I create a few report in VBA and then try to set a property on it, yet it doesn't realize it exists yet (even though it clearly does). Any advice is appreciated.

I'm "automating" a lot of table creation and updates in VBA. I don't want my user to have to click ok every time I update a table. Is there a way to either cancel this confirmation screen or do a "click" in VBA? The "OK" button has emphasis, so a simulated enter or space bar would work, but I...

This is probably a simple task, I just don't know enough about Access at this point to complete it: I have a large table of document numbers (DocNums) which may appear multiple times. The table also has a primary, autonumbered key (DocKey). I have another table that has a list of "special"...

I have a table of documents including the "DocNum" (actual indentifier for that document, not the table key). Since each of the documents can appear several times, "DocNum"s can appear several times as well. I need to find the first instance of each "DocNum." Any suggestions? Is there some...

Copying tables between databases with VBA code I'm fairly new to Access and VBA. I need to copy a table from one Access database to another one using VBA. The code is running as an action from a form that is in the database being copied into. Any help is appreciated. My last attempt was...