Search results for query: *

I had already asked a similar question to this and now was wondering if there is any way to show a specific record (to be the output on a report) based on two fields. This is the code I have for outputting a specific record based on the ID number - DoCmd.OpenReport stDocName, acPreview, ""...

HI, I was wondering what this error meant. I have a update query that produced this message - Microsoft Access can't update all the records in the update query. Microsoft Access didn't update 3 field(s) due to a type conversion failure, 0 record(s) due to key violations, 0 record(s) due to...

Hi all, I'm working on this database and one of the features I have to include is inventory control. I have units on order, units in stock and the reorder level. But I would like some help with updating these fields when items are sold and bought. I was wondering if any knew where I might find...

Hi, I have a form which contains records about patients. the primiary is PatientID and is based on the national ID number. I have compiled a query to show the patient's bill (invoice). from this query I have created a report. i have placed a button on the same form mentioned above that will...

hey there, two questions. i am running this query which is based on a 4 tables. one of the tables - Appointments - has in a field - Prescribed Medication - which may or may not contain information. in the query i have prescribed medicatio and it associated cost (from another table), but when i...

Hi all, I have a command button on my switchboard that was working before and now it's not. The button is supposed to open a report showing books that have been overdue for 1 week. When I click the button I get this error: Syntax error (missing operator) in query expression 'count[UserID]'...

Hey all, I have these reports that generate the number of books that were borrowed from a library on a daily, weekly, monthly, and yearly basis. I have switchboard that has these command buttons on it (daily, weekly, monthly, and yearly), when u click on daily, a dialog box appears asking the...

Hey, I have this library database I'm working on and I have a problem. I need to run a query to find out the books that are outstanding for one week from the current date. I have the visitor's info, the date borrowed and the date due (mm/dd/yyyy) in this query. Any suggestions? Lisa

Hey all, I'm working on this library database and turns out to be more work than I had expected. So on to the problems at hand. 1) This so much isn't a problem, more on the lines of needed advice. I am concerned about searching for records in forms. Do you think it is ok for the user of the...