Search results

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

I just keep getting Upload of file failed. Is there another way to sent this to you? It is 2.73 MB.

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

ahhhh, I tried it three times each time I click on the command button Access closes down and it says it is closing because of an error. :(

I am unfortunately using Access 2000 and it will not recognize the file you sent because you have a newer version of Access.

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

oh my, that is what I thought I had. Ok I changed it, it says Between [Forms]![ExperationDialog]![BeginningDate] And [Forms]![ExperationDialog]![EndingDate] The text box properties names are BeginningDate and EndingDate so that should be right now, but it still doesn't work.

Hum, well when I click on the report the form I created pops up. There is not a button on my form though that opens a report. I only have an OK command button. I think I might need something that passes the values from the form to the report. The macros for the OK only hides the form. the...

Help creating a Report-I created an unbound form with a date range & 1 other criteria Hello, I am trying to create a report that will filter through a table and tell me whose applications are going to expire within a 3 months time frame (or quarterly), for different divisions. I used the...