Re: [MS_AccessPros] Multiple reports question

 

Jim,

I typically don't place any dynamic filters in the report record source queries. Someone somewhere needs to run the report (unless automatically scheduled). In almost all cases, I create a WHERE CONDITION that is used in the DoCmd.OpenReport method. 

Regards,

Duane Hookom

MN

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, August 29, 2017 10:57 AM
To: luvmymelody@yahoo.com [MS_Access_Professionals]
Subject: Re: [MS_AccessPros] Multiple reports question

 

Oh and one more thing. the reason I remembered that I needed to change the criteria to the Between (Date()-30) And (Date()-Weekday(Date())+6) was because I send the query to another database for other users to use the same report. So the reference to the form name is different than the other database.

Jim Wagner

---

On ‎Tuesday‎, ‎August‎ ‎29‎, ‎2017‎ ‎08‎:‎48‎:‎33‎ ‎AM, luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

Hello all,

I am really trying my best to keep the footprint small for the databases I support. But the powers that be are not helping.

I have a report that I process and email to division leaders every Monday. the source of the report is a query with the criteria of Between (Date()-30) And (Date()-Weekday(Date())+6) for Effdt.

I used to use 2 text boxes on the form to get the criteria. But it seemed to not always work. The text boxes also populate the text boxes on the report for the data range criteria. So I went with the criteria in the query to be stable every time.

Now they want another report that they can choose the criteria date range.

Is there a way to at run-time change the criteria to a user prompt and leave the default criteria?

Thank You

Jim Wagner

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___