Recent content by AudreyCole

tman72: Thank you ever so much! How refreshing to find something that provides a solid solution to a known problem. Thank you again for guiding me there. Audrey

Hi. Trying to create a runtime in Access 2003. I start the Packaging Wizard, and when I get to the choice of language, choose English. It tells me I have to choose the place where a full version of Access is installed to cache the files. I do, but it never lets me select the folder. It is...

Jim: Interesting musings about 'secondary' recordsources. That explains why, when I msgbox'ed the count from the report footer, it first gave me 0, then gave me the ultimate count. Thanks. I've decided to write a little function that can be the control source for a counter on any report. If...

Jim & Tranman: Thanks again for your feedback. In fact, I am typically using a subquery with a dcount. Occasionally, I'll use a subreport if there are several items to count. I normally try to avoid domain functions because of speed, and try to avoid managing extra items, such as queries...

Tranman: Thanks for the idea. That's basically what I've done to get the reports working, but it bugs me to have to manage another 148 queries for the reports that need stuff like this counted. I kept thinking: There HAS to be a better way! Perhaps not. Thanks again. I appreciate your...

Jim: Thanks for your response. Good idea about the format/print count. That will perhaps keep the number from being LARGER than it should be, which I'd seen before. Unfortunately, it doesn't help the situation in which if I have more than 2 pages in print preview and only look at a subset...

Hi again, Tranman: I am indeed following your instructions. When I create a query that has only enough records to fit on a single page, it all works fine. If I have more than a single page worth, that's where the variability comes into play. I created a group footer to start a new page after...

Hi, Tranman: Thanks so much for your reply. I implemented your ideas, and get interesting but not accurate results. I put the incrementing code in the OnFormat of the group header (I'll describe putting it in OnPrint below). Whether I use OnPrint or OnFormat in the report footer, and...

Hi again. I tried creating a global counter in the OnOpen of the report, an integer that I set to zero, and incrementing it in the OnFormat of the group header. I'm having trouble with 1. making it global so the header event knows about the counter and 2. putting it on a report control. Do I...

Tranman: Thanks for the idea. I'll give it a try. Audrey

Hi. I want to count up the number of GROUPS on a report, not the number of records. I thought I could do this by using a running sum on a control in the group, but, alas, that doesn't work. I have clients with projects; sometimes a client will have multiple projects. The report is grouped by...

ChaZ: That solved it! Thank you ever so much! Audrey

Thanks for your reply. I have my system set to compact/repair upon exit and it doesn't ask for the password the second time. I'll find out if my client does. If this doesn't solve it, any other ideas? Thanks, Audrey

My client tells me his copy of a database secured with the database password asks for the password when he opens it, and then it asks for it again when he quits the app. I can't get my copy to do that in Win95. He's using XP. Can anyone help? Thanks, Audrey Cole

You can also run the MS Access Workgroup Administrator from each user machine to make sure their Access application is pointed to the correct security file.