Recent content by nathangoldhill

Does anyone know of a good access book that could help me set up an Invoice\Credit system? Thanks in advance Nathan

Do you know of a book that could help me set up an invoice and credit database from scratch?

Hello, I wonder if anyone can help me I am using a select query as a subform, but it wont let me make any additions or changes. I have checked the properties of the subform and allow edits and allow additions are set to true. Any ideas? Thanks in advance. Regards Nathan

Cheers for that I will tidy it up a little bit and send it to you if that is ok.

Hello, Does anyone know where I can find Invoice Database Examples. I am creating a Invoice Database at present and am having difficulties trying to work out how to do the final total. I have many records for each inoice all linked by invoice number. I need to do a query of this table to...

Hello, I wonder if anybody can help me. I have a table called ITEM, within ITEM I have three fields ITEM NUMBER (Key Field), Item, Cost, I have another table called INVOICE ITEMS, Within INVOICE ITEMS I have six Fields, INVOICE NUMBER, ITEM NUMBER, ITEM, UNIT COST, Amount, Total Amount. I...

My form seems ro be sorting my data and I dont want this to happen. I want the data to appear in record form as its typed in. so a new record appears as the last record. This is not happening at the moment any ideas?

What is the best way to compare two tables to find differences between the data.

Yeah a compact and repair does fix it! But what causes this in the first place?

I have a problem that keeps re-occuring on my databases all different. When a user trys to filter for data the Access comes up with record is deleted. Although the data is their. I can solve the problem each time by cutting the tables out and pasting them in a old restored database. But this is...

I have set up an automatic mail merge to run using a parameter query. The problem is that when i do it automatically using the code below it crashes with a doctor watson. The weird thing is if i do it manually from word it works. I have also set it up using dde instead of obdc and it still also...

I have set up an automatic mail merge to run using a parameter query. The problem is that when i do it automatically using the code below it crashes with a doctor watson. The weird thing is if i do it manually from word it works. I have also set it up using dde instead of obdc and it still also...