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

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 when i give the user the option to seleect all the orders on the first line is updated. how can i get all the records to be updated the code i...

I have an SQl statement which brings out the correct resutls however does not update the fields requested, Can any see what is worng with the followng code. When testing the code the results are exactly wat i want, but they dnt seem to be updating the fields. Theere is a command button on the...

Ive set maxdate to a date value, i am using the DMAX function as over a period of time once a Cylinder barcode is returned it can be used again so i need to check for the the latest cylinder barcode number. maxdate = Nz(DMax("[Time of Transaction]", "tbl_Delupdate", "[Cylinder Barcode Label] =...

Hi it seems to be bring up the correct date now, however i when the Date fo transaction si equal to null i except my code to eidt that record, however it keeps bringing up this message, "Invalid use of Null" When i run my code and it comes to this line "maxdate = DMax("[Date of D Status]"...

Meeage not appearing What i was trying to do, i look up the cylinderbarcode number entered into the inputbox and too see if the latest delivery date. if iwas to put it seperatly as you have suggested then i wanted the msgbox below to appear, however it does not appear Maxdate = DMax("[Date...

Can anyone see why the sql code below is not working, it works up unitl StrSQ4 = DLookup("[D Status]", "tbl_Delupdate", "[Cylinder Barcode Label]='" & Stringy1 & "'") But when i try to get the latest date for that Cylinder Barcode as shown below it does not bring out a value StrSQ4 =...

I have a form which shows a number of records, i have given the drivers the opion to select all the records and edit them, however when they do select all of the records, data is only edited for the first record, how can i get round being able to edit each record displayed.

i wanted to show the number of records in a text box, would i put Text11 = Count in the control source of the textbox. I did try this but i appears as name?.

How would i count the total number of records on a form

listbox I am trying to follow the example below, when trying to to this "The simplest way is to have your listbox have an underlying query as it's rowsource and in the query have the criteria be the combo box." I get the message "error in from clause" Can anyone see what is wrong with my...

Hi All, I have a list box which finds a record dpeending on the field selected. The field name within the listbox is based on the work order number, Onec it is selected the individual order name should appear when a works order number is selected. However if there is the same works order...

Thanx alot that was really helpful

Is it possible to change the colour of a textbox, after clicking on a command button?