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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by shaz123

  1. shaz123

    Comile Error- when using a calneder

    I have a form with a number of textboxes, two of the textboxes represent a date field, a calender pops up once the user has clicked on the date textbox. Once the calender appears the user can select the date from the clander which is then directly inputed into the field bound to the form...
  2. shaz123

    Checkboxes

    Thanxs for you help, but I dont think i made myself clear enough, My form is based upon a table called tbl_TransactionMaster, which shows orders (line numbers) based on works order number. I wanted to give the individual the option to carry out partial and full deliveries. An individual has...
  3. shaz123

    Select statement

    Hi this is a quick one, i wanted to add this line of code to the select statement, however im getting this error message. "Expected list or Seperator )" Set rs = db.OpenRecordset("SELECT * From tbl_Delupdate WHERE tbl_Delupdate.[Cylinder Barcode Label]= '" & stringy1 & "' AND _...
  4. shaz123

    Checkboxes

    I have form, with a number of orders on there, i wanted to be able to give the user the option to select all the orders and update each record, however what happens is the user can select all the records by using a checkbox, then they click on a command button, when they click on that command...
  5. shaz123

    Updating a table

    I have the following SQL statements, when testing them they do bring back the correct information however they are not updatng the fields wihtin the tabl. The command button updating the table si based on the information being viewed fomr a listbox. i have also locked the listbox, so the...
  6. shaz123

    Setting a date to empty

    Sorry about that, the date functionality seems to be wrking now, havent changed anything but it worked. Thanx for ur help guys.
  7. shaz123

    Setting a date to empty

    I tried settng the date to null ny using the follwing code datMaxDate = Null I keep getting an error message saying "invalid use of null", Im trying to set this code to to null datMaxDate = Nz(DMax("[Time of Transaction]", "tbl_Delupdate", "[Cylinder Barcode Label] = '" & Nz(stringy1...
  8. shaz123

    Setting a date to empty

    If have got a loop, i have a date set to a variable the problem is the time it goes round the secind time round it gives and invalid date, is there a way to clear the date so before starting the next loop it will be set to empty or nothing.
  9. shaz123

    code not working

    Sowi aobut not explaning myself properly, it was bringing a null value. But what ive dun is looked up the date sepratly and it is now bringing up the correct value. maxdate = DMax("[Date of D Status]", "tbl_Delupdate", "[Cylinder Barcode Label] = '" & Stringy1 & "'") However i am now getting...
  10. shaz123

    Input box

    thankyou, i will try it out
  11. shaz123

    Input box

    Well the thing is depending on if the user clicks on yes or no button i needed to input some information into a table. How would u refer to a button on the msgbox.
  12. shaz123

    code not working

    I am trying to lookup the clinder barcode inputed into Stringy1, i occordance with the latest inout for that cylinder barcode number. I the cylnder number is already delivered a message below should appear, can anyone see why this code is not wkring StrSQ4 = DLookup("[D Status]"...
  13. shaz123

    Input box

    Is it possible to change an inputbox, showing the yes and no option instead of OK and cancel?
  14. shaz123

    Information not editing the correct record

    Thankx alot for your help, but i think its is guna be diffiuclt using a listbox and were as the worksorder number is not unique, what ive dun is created another form, where when opened it asks for the work order number, it then brings up all the orders for that number. again how would i count...
  15. shaz123

    Information not editing the correct record

    do u mean in this code were u say "You seem to be getting [Works Order Number] and [Line Number] from the list box, but you are not referencing the column in which these fields appear." is this not refering to the data in the list box '" & [Line Number] & "' '" & [Works Order Number]...
See more

Part and Inventory Search

Back
Top