Search results

I want to build a query where I enter a query name a the query lists all the macros that contain that query. I have looked at the MSysObjects table but cannot determine how macros and queries are related. Any help will be greatly appreciated.

I get the message above when using Transferspreadsheet method in an maco to create an excel spreadsheet from a query. When I run the query by it's self, it runs fine. If I use the Outputto method, it creates the spreadsheet fine as well. The difference between Outputto and Transferspreadsheet...

Good morning to this very helpful forum. I have a form that contains a textbox that the user inputs selection criteria that I use in a query. The query3 is built using an outerjoin from one query1 (contains base information) that matches on a primary key to query2 that is a crosstab query...

I have found a few things on this but not quite what I was looking for. What I need to do is display a name in the crosstab query ("Jon Smith", "Waldo", etc.) but I want them sorted on the ID number. If I include the number as the first part of the name then I get #1,10,100,1000, Etc instead of...

I have an application that was built in Access97. We have recently migrated to 2000 (boy do I hate anything with microsoft and the numbers 2000). I had a macro that calls a sub macro 12 times (gives a visual status to the user on the progress with the macro). This worked find under 97 for almost...

I want to prevent the user from seeing anything except the main form. I am able to handle everything except 1. On the unload of the main form is issue a cancel event which prevents them from going anywhere. The two exceptions are on the access application: file..Exit and clicking the X in the...