Search results for query: *

I have a database that I inherited, that doesn't have a good method of allowing me to track records. It has 150 records in it and what I want to print on a report the coresponding record number to the event. For example, if I want to work on record 15 of 150, how can I capture the #15 and put...

I am trying to put a count of how many records there are on a report. Title Count Dr 100 Mr 50 Mrs 45 Ms 5 I want to display the total count in the Header. Total Count: 200 which is a total of all of the counts. I tried an unbound text box stating...

I have an Access 97 database with numerous groups set up for security. I had a user complain this morning that they no longer have access to a form that worked fine last week. I checked all the permissions and everything seems fine. I wonder if the .mdw is corrupt. Is there anything I can...

I don't know anything about VBA, but I am having an issue with the size of my Access DB growing by several megs each time it is accessed. I read an article about trying to recompiling it. I finally figured out how to do that, but I get the following error: "Method or data member not found."...

Does anyone have a good template they use to gather requirements to develop new databases?

I developed a database in Access 2003 and then tried to convert it to Access 97 for users that only have that version. I have done this before and it worked fine. However on this current database, I get the following error: Compile error: Method or data member not found. It seems to hang...

In MS Access 2003, I have 4 test records in tblRecordsCheckedOut. I built a query prompting a user to enter the name of the person checking out a file. When I enter the name, I get a blank record back. If I hit enter (which retrieves all records) I get all 4 records the way it is supposed to...

I have a database, and need to calculate what the average days overdue files are. I have one report that shows when [DateFileDue]is greater than 30 days. I have been tasked to figure out what the average amount of time for overdue files using [DateFileCheckedOut] [DateFileDue]. How can I...

I am working on a database to check out files. I have a field DateFileCheckedOut, and DateFileDue. I would like to know how to add 30 days to the DateFileCheckedOut, and automatically add it to the DateFileDue field. I have tried DateAdd, but it didn't work the way I thought. Any ideas...