Search results for query: *

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

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

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.

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?

Hi peeps, I have a combobox where i select a works order from, the results are displayed on a list box. The number of records in the list box is displayed in the text field. Once an individual has clicked on the combobox, depeding on the number of records on the listbox, when clicking on the...

Is it possible to count the amount of records in a listbox on a form.?

I am trying to refer a listbox to a Combo box, can any see what is worng with this select statement. i keep getting meesage "syntax error in from clause" SELECT Qry_Delivered.[Cylinder Number], Qry_Delivered.[Cylinder Barcode Label] FROM Qry_Delivered =Form!Qry_Delivered1!Person;

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

Hi, Im a bit stuck on validating, what i need to do is to be able to check if a cylinder already in use, by checking the status of the cylinder, if for example the cylinder new status is equal to null then the cylnder is out with a customer and it cannot be used again, however if its status...

How do u get a msgbox to show the results of an select statement, For instance below im a trying to show the results of a Select statement called StrSQ2, but this show the actual Select statement and no the result i was hoping. MsgBox "The Cylinder Serial Number for the inputed barcode No is =...

Hi, I have got an input box, were production scans a the barcode no, the information is then recorded into another table. What i need to do is pick up the cylinder serial number matching to the barcode number scanned. Both the fields are originaly within one table, would i need to use an sql...

Hi, I have a date field on a form, by using the code : now(), however it only really shows the current date when I open the form. as i need to log the time an individual has attempted to click on a command button on a form it is not wkrking correctly as the date and time is exactly the samne...

I have two tables one called AberdeenWOLines and AberdeenWOLinesclient, both have a field called status. I have created and update query were i am trying to update the status of AberdeenWOLinesclient to AberdeenWOLines. However when i run the update query it somtimes works correctly and...

Hi, Just a quick question i have a table "tbl_TrnasactionMaster", with the follwing fields Employee ID, User Name and Time, Time of Transaction, What i need to do is to prevent the same record form being entered more then once, for instance the folwiing should not be allowed. Employee ID...

Hi all, I have got a login screen, were i am checking against the tbl_user if the password entered and user name is valid, if not then the user is informed, however it gets a bit trickier were as im have got another piece of coding were the the user name is picked up in corrsepondence to the...

I have an inputbox on a form which asks for a cylinder number, the user has to therefore type an cylinder number which they want it to be filled, at the moment the individual can type in any cylinder number, but i would like the cylinder number entered to be validated against the cylinder master...

I have an input box which appears once a command button is clicked on, Once the inputbox appears a message the message displayed is "Do you wish to fill a cylinder for works order number:-0003102647000001 What i need to do is split the two numbers 003102647 and 000001. It should say "Do you...