Recent content by Carpetwarehouse

Hi just a quick one im sure for you experts. Im having trouble with a datasheet its ran from a macro button using BrowseTo command. Im having trouble with the where condition; i would like to show records where the [FittingDate] is blank... i have tried isnull() and [FittingDate]=""

I used some vba on the after update box as follows [Forms]![frmCustomerNew].requery Not sure if this works or not, it seems to do something as when i close the form in front to go back to the customer form its now on the first record as apposed to the customer record i was looking at...

Ok i Have a Customer form showing customer details, with a sub form datasheet showing Customer Jobs. From the customer form you click a button to take you to a Jobs Form showing the job details for each job for that customer. When i create a new job for that customer and close the Jobs form...

Hi This relates to 2 tables a customer and a jobs table both linked by [CustomerID]. I have a button opening the jobs form from the customer form showing jobs for that customer. When i go to add a record the [JobID] field on the jobs form shows (New) but the [CustomerID] is not passed over...

Thanks alot number 2 worked, which was the one thing i thought to try but i must of not linked the field up right.

Ok i have a customer form with a button that opens a job form the customer and job tables are linked with a customerid field. When the job form opens the records are filtered to show the ones matching the customerid displayed on the customer form. Problem is when i then go to add a new record...

Thanks for the links but they dont really answer my question they just explain the structure which i feel i know enough about...

I was using it but went back to paper while i try and make improvements, thanks for the link i will take a look...

Please see attached image of tables and relationships

Sorry if this is in the wrong section... Basically working on a Customer Order Database for my carpet shop. I have a Customer, Job and Order table. The order table contains the line items for each job and each customer can have many jobs. I have a field in the Order table showing the item...

Thanks thats done it! :)

I have a calculated field in a report footer which is as follows; CCur(Sum([Line Total])) Where the answer should be £147.72 Im getting 147.722 Any ideas?

Ahh i think ive solved it, i was using page footer instead of report footer!!

I have a Report (Invoice), which is based on a query. The query has two calculated fields in it [Quantity] - which multiplys the lengh and width fields and [Line Total] - which multiplys [Quantity] with [Unit Price]. I would like a total of the [Line Total] on the Invioce. What i have done is...

Is there a way of adding a footer in datasheet view? as thats how the data is displayed. I dont want to display on the main form, i want to calculate and display on the subform, but because its a datasheet there isnt any space to put fields like in a form and i cant get the totals line at the...