Rich,
Your Example was GREAT :)!!!!!!!!!
I finally made it work. THANK YOU, THANK YOU, THANK YOU!!!!!!!!!!
I was making it a lot harder than it needed to be.
Can you give me more step by step directions of what you did yesterday to make the report work. I can not have the form open at the start up of Access though. Do you know of another way to have the form opoen?
If you could still help me I would really appreciate it. I can sent you another...
What do I need to do to replace the 4 macros?
I do not know what to do to use the IsLoaded function on the open event of the Report.
Can you give me more step by step directions?
I copied and pasted the directions that I used. They are from Access Help. I changed the text color to Blue were is says to use Not IsLoaded
Use a form to enter report criteria
Create an unbound form that prompts for report criteria
Create an unbound form.
In Design view, set the following...
Error - "The object doesn't contain the Automation object "ExperationDialog"
I created a form called ExperationDialog. I used the directions in Microsoft Access help titled "Use a Form to Enter Report Creiteria" When I run the report I am getting an error that says:
"The object doesn't...
I have created a form called ExperationDialog. I used the directions in Microsoft Access help titled "Use a form to enter report Creiteria" I am getting an error that says,
"The object doesn't contain the Automation object "ExperationDialog"
You tried to runa VB Procedure to set a property...
ok, I hope you are still there. I deleted almost everything and made up some table info. But the darn file will not attach :( I keep getting an upload failed error. The file is small enough? Any suggestions?
hum I don't know if I can figure out how to make the database small enough to send you. I will see what I can do. Thanks so much for trying to figure out my problem. If you figure out what I am saying and have a solution please let me know.
If the form shouldn’t be opened when I click on “Reports” how do I open the Form? I used the IsLoaded function to open the form when I click on Reports. I used the Access help directions for “Use a form to enter report criteria”
What specifically do I need to do to open a report preview from...
I see what you are saying that the form needs to open then the report, but my report form never opens. How do I set it up so that the form opens and then the report?
How I have it set up is that when I click reports the first that that happens is the form opens up like it is supposed to. The...
The record source was already set to the query. I used the query wizard instead of creating it in design view, would that make a difference?
A report is not opening before the unbound form pops up. In the database view when I click on reports the first thing that happens is the unbound form...
I am getting closer. When I click on the report and enter the criteria and hit ok the form closes and it looks like nothing happened. When I go back and click on the query the results show up in a table view.
How to I get this information in a nice form that has a title, shows each field...