Recent content by bajanJedi

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, ""...

thanks for replying. i tried ur suggestion but it won't work. i have a calculation in the 'update to' field, so when i switch over to select query it doesn't show any records period. the query is for updating products in stock. so when one item is sold the table with the units in stock field...

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...

no worry folks, i got it working. bajanJedi

THWatson... thank you so much. the code u gave is working nicely :) i never thought i could have finished this part of this database. here i was going around the world worrying about sql coding and that piece of code was what i needed :) thanks again. bajanJedi

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...

anyone else with some ideas on this?

ok i got the first one figured out. but the second one i'm still a bit lost. i already have a query and it has a unique identifier called PatientID. i'm lost at the criteria part. the form has a button to open the patient's bill report (which is based on the query). i thought maybe there was...

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...

ok, yes i put that in and now it's working... much thanks :D Lisa

OK, I saw somthing about SQL, SQL Pass through and this popped up. I wasn't sure if this is what you meant. SELECT tblUsers.UserID, tblUsers.Title, tblUsers.Name, tblUsers.Address, tblUsers.Parish, tblUsers.[PhoneNo(H)], tblUsers.[PhoneNo(W)], tblUsers.CellNo, tblUsers.Email...

Nope, that still doesn't work.

ChaZ, UserID is the actual field, I tried removing the "criteria", but it brings up the same error msg. Golom, I tried that and it produced another error: You canceled the previous operation.

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]'...