Search results

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]=""

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...

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...

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...

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?

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...

Ok I have a form which is a summary of details about jobs, on this form is a sub form which is based on a query which displays in datasheet view. The query calculates the area by multiplying the length and the width fields and multiply the area by the unit cost giving a line total. What i want...

Hello hoping someone can help me ive been searching the internet all afternoon. I have a combo box on a form which looks up products from a products table. The products are commonly sold products but i would like to be able to have the choice of selecting one from the list or manually typing...