Search results

Hi All, I'm not sure whether this should go elsewhere really, but the problem is on a form so I've put it in forms. I have a Service Reminder form which is supposed to pull up customers who's services are due in the next 2 months. I can then print letters from the form to send to the...

Hi All, I have a Job Log form whereby a customer name is entered, along with details of the job. I have arranged it so that if the user tries to enter a new customer (ie. their details are not on the system), another form pops up in which to enter the new customer details. I have done this by...

Hi All, We've just had a power cut and 2 of us were in the process of adding a record to the database. The primary field is an Autonumber and, on re-entering the information for the record, we have found that 2 numbers are missing. Ie. instead of record numbers 1,2,3,4, we now only have 1 &...

Hi All, I'm producing a report which is split into 2 columns on the page (7.5cm wide each). I have a sum in the Report Footer to add up the total of all the figures in the report. Even though there is enough space on the first page to print the report footer, it is printing it on the next...

Hi All, I'm trying to create a report which shows the profit made on a selection of jobs. It involves 4 tables (invoice details, job details, customer details and hours worked). The problem I have is when I come to produce a grand total of the amount charged to customers in the report footer...

Hi All, I'm not terribly Access-savvy yet... I have created a report which calculates the profit we have made on labour on our jobs, along with invoice details and actual hours worked. Eg. Job No.1, Customer Smith Invoice No. 123, Total Value £300.00, Labour Charged £180.00 Hours Worked...

Hi All, This is my first post here and I imagine there will be many more as I have only just started out using Access to create a database at work and I am sure that I'm breaking many rules along the way. Anyway, over the weekend, my boss tried to add some information (to the "Memo" field) in...