Recent content by shaz123

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

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

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

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

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

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

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

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.

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

thankyou, i will try it out

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.

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

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

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

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