Search results

Any ideas Thnxs for your response, I have tried adding If rs.recordcount>0 then put your block of code for what to do if the cylinder exists else put your block of code for what to do if the cylinder does not exist end if To my code, the error message does not appear now, however when i type...

thanxs for your quick response, The form is bound to a query, with a number of tables. Me.status refers to the text field "AberdeenWOLines.Status". Do u think it could be because i have coded the command button to luk up the tbl_transactionMaster "Set rs =...

With the coding below i am trying to input a cylinder number into the tblupdate table, when the cylinder number inputed matches the cylinder number within the tblupdate table the cylinder status is set to returned, however if the cylinder number inputed does not match the cylinder number inputed...

Hope I am posting this in the right area, I have a command button on form, which when clicked on brings up an inputbox, and inserts particular information into certain tables. Most of the code works however when i want to change the cylinder status from outstanding to filled in the lines table...

I have an command button, when once selected brings up a inputbox to enter a date is it possible to : 1 - add an Calender to the Inputbox to be able enale the user to select a date instaed of typing it in. I am able to add a date picker calender to a date text field, however i do not know or...

It works thankuuuuuu, i was missing the Between

It works thankuuuuuuu

Yes my original code was: [Forms]![Works Order Import Date Selection]![Enter From Date] And [Forms]![Works Order Import Date Selection]![ Enter End Date]

Yes my original code was: [Forms]![Works Order Import Date Selection]![Enter From Date] And [Forms]![Works Order Import Date Selection]![ Enter End Date]

Hey, I do leave the form open whilst the query runs, when you say show the query desing do you mean show you what happens when I input the dates into the form, If yes i have a atthaced some screen shots in Word. Thanku again

Thankyou, for your help both of u, i tried both ways and for what i was trying to do this coding worked "DoCmd.GoToRecord , , acNewRec". Thank alot

I have a command button on a form which i would like to click on to clear all the textbox on a form. Witihn the event procedure of the command button i have tried cylindernumber = "". This does clear the text box however it deletes the information from the table to, which i do not want to...

:D Thnxs for quick response the query is running of a linked table which is connected to one of our db2 databases, as it ha some sensitive inofmration i cannot send the linked table, even if i did i dnt think it the query would run on ur end. However I will send u a copy of the query and the...

Thnx alot for ur help, its sorted

Thnaxs for that have made the approiate amendments however after i have inputed both dates and selected ok the Query runs, but does not bring up any records between the dates selected. I have tested to see if this works when i have typed "Between [Please Enter Document Date From yyyymmdd] And...

Thankyou for that it was so basic, i was just going the long way round

I tired wat you said, put this in the Query criteria "[Forms]![WorksOrder Import Date Selection From]![Enter From Date] And [Forms]![WorksOrder Import Date Selection To]![ Enter End Date]" I also created to forms one for the from date and the other with the To date, i also creasted a command...

I have a form which allows an individual to add a cylinder record, i would like to validate the form in the sense that if the cylinder has already been added into the table it cannot be added again. So once the cylindernumber has been typed within the text field and the add button is clicked...

thnxs for the reply, Ivew sorted by setting the value in the desing view of the table, thanx anyway

I dnt think ive explained my self very well, I have typed this in the query "Between [Please Enter Document Date From yyyymmdd] And [Please Enter Document Too Date yyyymmdd]". this then brings up two input boxes, whic is what i want. However of you look at the word document loaded, were it...