Search results

Apologies if it had not made things clear. The import action would not complete. I receive an error message. To restate the problem: New database built. Tables I am concerned with are Customers & Orders Old databases for each Salesperson exist. As much of the information in these tables needs...

I have built one new Access databse which is intended to replace a number of old databases. The old databases record customers for a salesperson, and orders for each customer. A separate database existed for each salesperson. Everything is combined in the new database (with revised field names)...

Since I posted my last message, I have removed the Chart reports and the other reports all worked OK. I have now re-built my charts and everything is ok (touch wood). Still no idea why I had the problem. It would be good to know if anyone has any ideas.

Thanks for getting back. I incorporated the IsLoaded function and everything was working fine on all the reports I used this for. I then started using for Charts. The first was fine and then after the second I get an error message on no only the charts but all of the reports I had been working...

I have a report based upon a query. I did have separate start & end date prompts for the date range for the report but after seeing a report dialogue form in Northwind & some example databases felt this would be more helpful to users. It has a Start & End date boxes & a preview key. I set up...

Is there any way the title bar of a form can be set to different colours. My command keys to certain forms are colour coded and I would like the title bar to have the same colour? Thank you.

Pat, I apologise if I have not made things clear this end. The customer fields are not in my salesperson table and are in the Customers table. The SQL I posted was the one I was working with. I knew it did not contact the Customer name fields and therefore tried to add this table into my...

Pat, The SQL statement was: SELECT [Product Details].PolDetailsID, [Product Details].CustomerID, [Product Details].SalespersonID, [Forename] & " " & [Surname] AS FULLSALEPERSONNAME, [Product Details].PolStatus, [Product Details].ProductType, [Product Details].PolWritCommission, [Product...

Thanks Pat & Rich for getting back. I have managed to solve my problem. I created a Product Query which combined the salespersons name. This is used as the basis for a number of other queries. When queries require the Customers name I add the Customer ID from the Customers table when using the...

If any one could help me with this problem I would appreciate it. An overall salesperson is assigned to a customer but there may be individual products sold to that customer by different salespersons. One customer can buy many products. Tables are: CUSTOMER CustomerID SalespesonID SALESPERSON...