Search results

Worked a treat, thankyou

Sorry does'nt work get the same #error

Hi i have recently created a purchase order database and it runs great until i came to doing a report. the report lists Qty, Description, Unit Price, Total Price. The total is qty* unit price and this displays ok using =[Unit Price]*[Quantity] but when i try to total the total prices in...

Hi guys I have created a button on one of my forms to open another form, but when it is pressed is displays all the records associated with it , can i set it so it opens on a blank record only ready for inputing txt. Cheers

I have a form, with customer names address etc, with also shows a subform of work done for this customer, the sub form is in data sheet view so all previous jobs appear like a list. However i now need to add a report onto certain jobs, i know i can link a command button to a new form in form...

thankyou very much for your help i will take a look today.

sorry i know i am a bit thick, as i stated earlier i dont know a great deal about access and i have never used statements like the ones you mentioned, i have tided up the example slightly, what i want is if risktype1 looks up an id, then description and other fields are filled in automatically...

I am a complete novice at access and would appreciate any help i could get. I have attached samples of the files i am working on, there are 2 tables and 1 form, what i am trying to do is auto fill fields based on the info from the risk types table into the risk assessment form, however after...

Thanks i will give it a try today

Hi there i have been using this forum and have found it very useful, thanks to all who contribute here. My latest problem i am facing is i was wondering is there was a way that if and option is selected from field1 which is a list box can the next field be automatically updated with txt to...