Search results

Hey guys once again i need your expert advice please. I have a form (frmEquipmentHire) with a subform (TESTSUB). in the subform is the prodcut ID and name, Quantity on hand, the Quantity order, and the price. Basically i need an update query to update the quantity on hand field in the back...

Hey thanks very much for your reply, and the code looks like it could work, but i know very little about VBA code, or any code for that, so could you do me a huge favour and replace your values with mine that i gave you in my first post and also write out the script for running my query so that...

Hi guys ive got a login form and im trying to put together a change password form also. now what i have already is a form with combo box for the username (combo0) a text box (oldPassword), and two more text boxes for (newPassword) and (verifyPassword). I think its all quite self explanitary for...

Yes thankyou :)

Ok guys so i have an inventory database which is really simple. im not sure if i should use a form or report for my next stage though. Basically i need it to do this: Enter client name and address Enter dates times etc Enter location draw from an employee table what crew will be on the job...

Ok so hey ive split my database. Packaged the front end as an ACCDE And trialed it. Some things i would like to clear up now :) Firstly are there any security features that i can put in place so no one tampers with it??? i have already made it ACCDE so anything else i should do?? I have...

Ok great, so would you be able to give me some steps on how to compile and the best way to split and store the databse? Thankyou

Hey guys I need your awesome expert advise once more. Basically ive finished my database for the mean time and i want to implement it into the business i have created it for for a tral period of a month. Heres the database in boht 2007 and 2003 form: K so give me your views on the databse...

one question when it deletesa a record, if i type in the combo box to retrieve the record in the first place lets say test1, well then when i press click obv it deletes the record but the name is still remaining in the combo box when what would be ideal is to have a clear form? Any ideas?

So how would i bring the actual underlying record into the form but keeping all the information in seperate text boxes?? rather then just pulling the infomration

Nope atm i have one table with the product info in it and thats all

Hey guys On a form i have got a combo box for the Product_Name [Product] and 3 text boxes linked to the combo box to show quantity[Product_Qua], unit[Unit] and section[Section] for the product. They are linked to the combo box by the =[Product].[Column](2) command. All i want to be able to do...

Dw guys ive just created to forms again thanks anyways :)

but the little background thing i cant delete for some reson i cant select it at all :/

K i built two forms with one of the templates, but ive decided i dont liek the template any more and want to get rid of the header and footer design, but when i right click and press page header and footer to take it off, i does it but the background that came with the template stays at the top...

It works thankyou very much :)

and now the unit 9 image is showing when the value is null

=IIf(IsNull([Unit],"",IIf( [Unit] =9,"C:\Users\Tom Burman\Documents\First Light\Floor plan unit 9.png","C:\Users\Tom Burman\Documents\First Light\Floor plan unit 10.png"))

Is thats correct becuase its saying it has the wrong amount of arguements for the function? :s

Ok so thats great it works thankyou, One problem though i want no image to be showing if the value of the unit text box is null. The unit 10 image is always showing if the value is null or 10 has been selected??