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

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

Steve, I am using the DateBorrowed field. The query reads like this Field1 - Week: Format([DateBorrowed],"ww"), Field2 - DateBorrowed, Field3 - CountOfBooksBorrowed: DateBorrowed.

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

Ohhhh.... I see it. I deleted the "sub-query" from the DateDue criteria and placed the 1 in the calculated field criteria. It's working now. Much thanks. I was also wondering if you knew anything about the ActiveX Date Picker control. I have these reports that have to be generated...

Ok, I had to change around the DateDue and Date(). I ran the query to make sure it would work and the calculations are right. Now when I place thIS bit of code in the criteria (SELECT DateDue FROM tblUserLoans WHERE DateDiff('ww', [DateDue], Date()) = 1) I get this message - 'At most one...

OK, I maybe I should also mention I know nothing in SQL so I had to retrieve the help files. I placed the code in the criteria section [as it said in the help file] along with the select and from. Well I can tell you it [finally] runs. But it's only showing one record and the record is not the...