Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bajanJedi

    Showing specific records based on two fields

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

    update qry msg help

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

    update qry msg help

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

    Keeping track of inventory

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

    viewing specific records in a report

    no worry folks, i got it working. bajanJedi
  6. bajanJedi

    Showing specific record in report

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

    Showing specific record in report

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

    viewing specific records in a report

    anyone else with some ideas on this?
  9. bajanJedi

    viewing specific records in a report

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

    viewing specific records in a report

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

    Syntax error in switchboard

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

    Syntax error in switchboard

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

    Syntax error in switchboard

    Nope, that still doesn't work.
  14. bajanJedi

    Syntax error in switchboard

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

    Syntax error in switchboard

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

    Using 2 Date Pickers in a dialog box

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

    Using 2 Date Pickers in a dialog box

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

    Query for books outstanding for one week

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

    Query for books outstanding for one week

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

    Query for books outstanding for one week

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

Part and Inventory Search

Back
Top