Search results

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

Thanxs for your response neileg, but i am new to this, what i am trying to do is update all the fields from the AberdeenWOLines to AberdeenWOLinesclient, were the Worksorder number, Lie number and Product number are set to primary key. Were would i put the join between the two table if i need to...

Sowi for the confusion Sowi for the confusion, it is an update query, below is the SQL of the query UPDATE AberdeenWOLines LEFT JOIN AberdeenWOLinesclient ON AberdeenWOLines.WorksOrderNumber = AberdeenWOLinesclient.WorksOrderNumber SET AberdeenWOLinesclient.WorksOrderNumber =...

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

Thankyou, that was really easy and it worked by just changing the format option on the date field

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

Its ok it seems to be working by itself now, however i have another question, whn i do click on the add button when there i have not filled in all the fields the message box warning that all the fields are not filled in does appear, however another message also appears saying "the cylinder...

Its ok it seems to be working by itself now, however i have another question, whn i do click on the add button when there i have not filled in all the fields the message box warning that all the fields are not filled in does appear, however another message also appears saying "the cylinder...

Hi Guys, ive tried the coding shown by workmad3 and i keep getting the follwing error message, Runtime error 438, "object does not support this property or method" It does not like the coding in red. If strWhatField <> "" Then MsgBox "Please complete required " & strWhatField & " field."...

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

if i set the works order number, productname and line number as primary keys, would this prevent an order being added with the same line number/product number/works order number

Hi ST4RCUUTER, The query is based upon a makeup query, the makeup table is based upon linked to tables. I have created and append query to extract information form the specgas Makeup query results. what im trying to di is when the append query is clicked on the secind time do not want the...

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

Thankyou so much for your help, it worked

Thanxs for that, refering back tot he original post do you know how to 2- Once the inputbox appears a message is displayed "Do you wish to fill a cylinder for works order number:-0003102647000001 However i need to split the two numbers 003102647 and 000001. It should say "Do you wish to fill a...

I spotted one error, "If Stringy3 = rs![Cylinder Number] Then" which ive changed to "If Stringy3 <> rs![Cylinder Number] Then" But it still does not work