Search results

Thanxs for the reply people, i just read them, guna try it out.

Hi Thanxs alot for your help, is there any other way i could get around it like coding the inputbox in events prcedure in a form, which when clicked would bring both input boxs, and run the query!!!!!!!!.

Im not sure if this is the right area to post this but what i wanted to know is how i would set the field "status" to OutStanding when a record is added into the table.

One more question, when doing this, the input box displays, Enter parameter value how can you change this text?

I have an InputBox date box created in a query, How would i change the title of the input box from "Enter parameter value" to "Works order Import selection". iS IT POSSIBLE

How would you do this for two date fields, a from and too date.

Query thnx for making it clear which query to use, i have tried using the update query as i want to amend existing fields. However when creating the query in the Update To field i have tried to locate the other database by typing in: C:\Documents and Settings\shareen\My...

I have a query but i do not wish to see any repeating results, for example there cannot be a result with the same works order number and product number. for instance Product number Works order number 22180 565656 22180 565656 So u...

:confused: Hi i was wondering if any one can advise me, I have two databases and wish to update a an edited table from the second database to the origianl table in the first database. I tried an append query were i could browse for the first database. But this type of query was not suitable as...

If a cylinder has been returned i do not want the desciption label to show for that particular cylinder record, with the code below i was trying to do just that but even if a cylinder has been returned or not then the description label doesnt show, can anyone see what is wrong with this coding...

Hi Thanxs for that, I have changed the coding as suggested, however even if the cylinder number within the table matches the inputed cylinder number (Stringy3) a new record is still added were as i wanted that cylinder record to edited. Also if the cylinder number does not match the inputed...

Thankyou for that, the error message does not appear anymore, But i cannot carry out the function that i was trying to do, maybe my coding is set out wrong. If you look at the coding below, if the cylinder number entered within the inputbox (stringy3) is the same as a cylinder number already in...

Calculation Sowi my mistake, it was a report not a form, thanxs alot because that has worked. I also needed to work out the total for each different product, for e.g. if there is one 212110 product No showing for a customer there should be a label displayin the total of one for that...

Can anyone see what is wrong with this, stingy3 represents the cylinder number entered into the inputbox. The error message that keeps coming up is 'Too few parameters.Expected1.' Any ideas Set rs = db.OpenRecordset("SELECT * From tbl_Delupdate Where [Cylinder Number] = stringy3")

Calculation Hi, Thanxs for trying to trying to point me in the right direction, i am still getting the same error meesage even after trying your bit of code, as my report is based on a query, were table name is i have put the query name "CylinderBalance" is that right. I have attached a copy...

error I have tried the following but this code does not work it keeps saying error =Count([ProdNo])

Hi, Can some help, I have got a form with a field showing different product number on there, how is it possible to calculate the total of each product on the form?????

Checkbox Hi, I see what your saying, its just I havent got a clue how to make this loop work with my coding, did try to attempt to code a loop but did not work. Is der any examples u can give me!:confused:

Check Box Hi thanxs for your help, if you luk at the coding, once the check box is ticked the information is only added in acordance to that cylinder number, in desing view of the form there is only one cylinder number textbox. Therefore how would i make it possible for the information to be...

Hi, I have got part of this working, im trying to edit a table through a form after the user has selected a check box. What I cannot get working is when the user clicks on more then one checkbox. It must be some kind of loop that i need to inlcude can you anyone help I have attached the code...