Search results for query: *

I have a large MSAccess 2000 database (1.5 GB) that I developed over time to provide quick access to transaction details and summaries for my company. (Yes, I know I should move this to SQL server but our SQL gurus are tied up on other projects) I update this database every month and create...

When I try to create an mde file from a 1.2 Gb access DB, I get the error message "Microsoft access is unable to create an MDE database". The database has been compressed and repaired. I'm running access 2000. Any suggestions to fix this will be greatly appreciated. thanks. John

When I print Excel worksheets, I like to print in the footer the date & time, the page number of number of pages, and the file name & worksheet name. Currently, I have to manually set this in every worksheet I create or open. Any ideas how I could programmically set these for all worksheets in...

I have created a report that reports the data from crosstab queries into unbound fields on the report. If I explicitly define the query name in both the report properties and the report VBA everything works fine. Since I have about a dozen queries to run I am trying to create a single report...

I have developed a generic report that I wish to run using different queries as the RecordSource. I need to be able to pass parameters from an OnClick event from a form to a report to print or generate a preview based on the parameters passed. I plan to hard code the query name in the form...

I have a report which runs against a crosstab query which generates a monthly summary of sales by agent. Every month a new month is added to the data. The query automatically includes the data but the report must be modified monthly to include the new month's data. I'd like to generate a...