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.

There are 26 fields

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

Thanks Rich but my problem is a little different in that the criteria applies to the base query (query1) and not the crosstab query. The crosstab only adds addtional data to those rows selected from the base. I also tried creating another query over the top of this one and still had the same...

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

Sorry; It appears that the post removes extra spaces so things did not align correctly Dept................Jon Smith...Jane Doe.....Rob Lear Grocery...................X.............X................X Pharmacy................X...............................X

Thank you for your reply Jon but I may not have been clear. The values I want sorted are the Column Headings not the Row Headings. If I add the id to the row heading I get multple rows. Ex. of what I want Dept. Jon Smith Jane Doe Rob Lear Grocery X...

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