Search results

I would like to set up an event or macro that will run a query and save it as a worksheet in an excel file, then run another query and save it as the next page in the workbook and so on. Can anyone help me here? Thanks!

I need to create a macro that opens a query and saves it to a worksheet in an EXCEL workbook and then opens the next query and saves it to the next page in the workbook and so on. I can do this manually, but it is time consuming and inaccurate. I have another workbook that is linked to this...

I have a form that will feed parameters to a series of reports. In my test mode, I keep getting a runtime error 2055, "The expression "I" you entered is invalid." The code the debug function points to is below: Function CalcPercent(intNum1, intNum2, Pct) ' Pct indicates how number should be...

I am trying to print a 4 page report. In the page header, I print a field from the database. On the first 3 pages, the correct data appears. On the total page, the data from page 3 appears. I would like to print the word "Enterprise" instead. Any ideas?

I have 5 queries I run daily. I would like to create a form that runs all 5 just by pushing a button (There will be fields on the form that supply values for the queries) I would also like the form to paste them into an EXCEL file for a non-ACCESS type person to manipulate. Each one should go...

I found the following code in a response from prao but that topic disappeared. What do I do if one of the fields that is populating the form is blank. This code puts me in a debug loop. Private Sub cmdbankername_BeforeUpdate(Cancel As Integer) Me.BankerFullName = Me.cmdbankername.Column(0)...

In a form I want to enter a name and, on exit, I want to do a find on that name, first in the current table and if not found in a different table. Once a record is found in either table, I want to copy data to the current table record. If no record is found, just continue and enter manually.

I have a combo box where I look up names. I would like to do a find on that name either in the current table(if the name exists) or in another table and populate several other fields from the table on exit.