Search results

Can you do that if you are just using an docmd.Outputto (i.e. NOT docmd.openreport)? If so, do you know what that code is? I looked before and didn't find much on it. Thanks, Stoss

Thanks again for all your help. If I am understanding you correctly. The only way to achieve the goal I want is to have 2 reports (the exact same (minus the recordsource)) and 2 querys that will function nearly the same? In my initial thought process I thought this would end up being my only...

Oh, I should have also mentioned that this automated approach is using the DoCmd.Outputto to run this (as I want it to be hidden without the user seeing it run) -Stoss

Yeah, I see how this can be confusing...let me try to explain. I have a report that I run usually from a button click. When a person clicks this, they are asked a [start date] and an [end date]. I want this dynamic just in case "the manager" want to put in a different date criteria. However...

Again, thanks for the reply. Well, at this point, I guess I am not going to be able to do what I want to do with it. Making the controls with the dates in them is a good idea, just seems clunky. I dont like having hidden controls on the form. Anyways, i really appreciate your help. I guess...

Thanks for the response John. The problem is, when I run these reports manually it ask for dates and I put them in, easy enough, but I need to run these automatically as well as manually. I can manipulate the dates later on but for now my hurdle is passing those parameters automatically (just...

I was wondering if someone could give me some advice. I have a report that is run using parameters [Start Date] and [End Date]. This is run from a cmd button, which works just fine. However, I now need to ALSO have an automated way of doing this task (basic date manipulation later on). So...