Search results

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

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

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.

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

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

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

StrSQ3 = Dlookup("[R Status]", "tbl_TransactionMasterclient", "[Cylinder Barcode Label]='" & Stringy & "' AND [Time of Transaction]=#" _ & DMax("[Time of Transaction]", "tbl_TransactionMasterclient", "[Cylinder Barcode Label] = '" & Stringy & "'") & "#") I wanted to test if the above wrks, how...

HI, How do u get a date field to update everytime you click on a commmand button.

Just a quick question, lookinng at the exmple below, does rs! stand for the filed within the table i am trying to add the infomration to and Me! equal to where i am trying to pick data from. As i keep getting an error to say that the field name is not reconised. rs![User name] =...

Hello, I am developing a cylinder tracking system, when i user logs in its necessary to record this action, as when they try to fill a cylinder i need to be able to record that this particular employee has updated the table and by recorindg the user login in i will able to do this. IS the...

Hi All, I am using an update query however when clicking on the run button within the query, i keep reciving an error message which i have attached. It basically refering that due to setting a primary Key on the table i cannot add all the records, however i need to set a primary key to the...

Hi All, Is it possible to change the format of a date picker, for instance once i have selected a date, its is visible as 09/11/2006, can this be edited to just the month and the year 11/2006.

I have a makeup query, were i am tryin to trim one of the fields, how ever i keep getting this message, Extra ) in query expresion 'TemplLines..[Trim([ARTNR])].' However in the field i have typed this "ProductNumber: Trim([ARTNR])" I cannot see were i am going wrong. I have included a print...

After a record has been found is it possible ot exit a the Find dialogue box and return to the form, wihitn the follwing code below? "Private Sub findrecord_Click() On Error GoTo Err_findrecord_Click Screen.PreviousControl.SetFocus DoCmd.DoMenuItem acFormBar, acEditMenu, 10, ...

I have two databases, were i have linked the second databse to a table in the first database. Within the seocnd database I have a table called tbl_Delupdate, i would like all the information form the first database table tbl_transactionmaster to be updated into tbl_Delupdate. I have tried the...

Hi, im really need help, just a bit pressured to sort this out as soon as possible, I have a form were depending on the quantity that is them amount of inputboxes appear to fill a cylinder with a particualr product. Even if there are two products, it only asks for one cylinder number, this...

At the moment i have a straight forward login form, were if the username matches to the password the user can log in otherwise they cannot. However i need a login based on access rights. For example if a user A log in he is the administrator and has access to all the tables, to be able to...

Is ti pssible to set more then one recordset at a time for e.g below one record is set Set rs = db.OpenRecordset("tbl_TransactionMaster") Could this be changed to more then one: Set rs = db.OpenRecordset("tbl_TransactionMaster and AberdeenWoLines") Is that possible, as i am...