Replies

Hi Charlotte,
No I didn’t inherit the database but have built it very slowly since 1995 and in that time have managed without code. The present database actually comprises of 80 tables that are used regulary the others are backups or for test purposes, 170 queries, 67 forms and 86 reports. One reason you might consider the database is quiet big is because I am using one database for every office task from accounts to motor reports. Possibly I need to split them up into different databases? When I say one database it’s actually two because I have my tables seperate to the queries, forms and reports.
After reading a book (in the last two weeks) by J R Carter on Access, SQL and Vb I now know a bit more about code and SQL and with the aid of a book or by copying similar code and them modifying it to suit I am sure I could make something happen, I am just not sure what! Its not really the lines of code,within reason, but where to put it and how to start. I don’t know enough to see the big picture.
With regard to my Append Query problem. At the moment I click a comand button which runs a query that asks me for the month number, I enter the number click ok and approx 50 (at this time) new invoices are added to my invoice table. They are correct in every way, descriptive text, cost, date customer etc except for the invoice number which at this time is null (but could be the last number plus one for all the new invoices). I envisage adding code to this command button to run another query on the invoice table after the new records have been added to look for Null invoice numbers. Then do something like Do While Not EOF etc. The problem is what instructions do I put between this and Loop to make it add the correct invoice number to these new records? Thanks JohnMichael.

Thanks for replying to my append query problem WendellB but I really need to use code because I don’t know the implications of changing to an autonumber. There are 5000 invoices in my invoice table and the database comprises of 95 tables, although not all related! I might solve one problem and create a whole lot more. Anyway the knowledge could be usefull because I use the DMax +1 on quiet a few of my forms. Thanks once again. JohnMichael.