Recent content by NSTLouis

I have a database of service requests. Each service request is given an entry date. I need a query to tell me if we have 3 requests for the same service within 30 days of each other. So, the 30 days is a moving target. I don't want 3 requests within a specific 30 day time frame. Any ideas on...

Thanks - that was immensely helpful. I've been stuck on this problem for a month and it is great to move forward again.

I am having exactly this same problem. Perhaps I could get a copy of the samples too? Did your problem ever get resolved? clanriordan@juno.com

Thanks for all the advice, I will give that a try. Since you are the second person in as many posts to tell me to ditch the macros, I guess I should heed that advice.

Thanks, but I do not know a bit about visual basic. I'll give it a try, but if anyone has any other ideas that use macros or event procedures I'd prefer to go that route.:confused:

I am using the following in the control source of form2's Lname field: [Lname]=Forms![form1]![Lname of form1] However, if the user came to form2 by way of the switchboard or if Lname was blank in form1, I want the user to instead get the prompt [Enter Last Name]. How can I ammend the above...

I am designing a db in access97 for several users. Problem is most users work from a field office and are not constantly connected to the network. (don't ask why - this is city government). If I copy the db to each of their laptop hard drives, is there a macro I can give them that will save...

I have a query which powers a form and a report. The query has a parameter requiring the user to enter [fieldname]. I want to put a command or macro button on the form which takes them straight to a print preview of the report, but I don't want them to have to enter the [fieldname] again -...

I am having the same issue, only trying to capture the field to filter the underlying query so that I can use a macro to jump straight from the form to the report. Any ideas on how to design a command button or a macro to accomplish this?

The control source is simply [sumofaccount] and then I have Running Sum in the properties box set to "over group". So in the footer formula, when I do the same thing, set control source as above, I get only the first number in the running total list instead of the final number. It doesn't...

I am designing an expense report where one column in the detail section is the running sum of expenses for each account[sumofaccount]. I now want to put a formula in the account footer that calculates [appropriation]- [sumofaccount]. But instead of the final running sum number, the report...