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

The database compiles fine. It still won't create an MDE file. Any other ideas?

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

Thanks. Using the form is fine except I need to pass two fields to the report and the combobox only allows me to pass one field. I need to pass the queryname and the title of the report. I created a table with the report title and the queryname. How do I pass both of these to VBA from a...

Another option could be a crosstab query with the years as the colume headers. John

I would write a query and base the report on the query. In the query prompt for the input data from the form by using criteria such as [Forms]![frmFormName]![cboCountry] for the country and Between [Forms]![frmFormName]![txtStartDate] And [Forms]![frmFormName]![txtEndDate] for the date...

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

Here is some code I use to add a sequence number to a field in a table. This may work for you. Sub Sequence(TableQuery As String, RankField As String) Dim rstRank As Recordset Dim db As Database Dim Statement As String Set db = CurrentDb() Set rstRank =...

Unfortunately that doesn't work for this aplication. The form is a simple switchboard form with buttons and no text boxes. The queryname(s) are hardcode in the OnClick event of the button so there are no opportunities to use Forms!MyFormName!MyTextBoxName. I need a method to pass the...

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