Search results

I need help with a table design for on a DB involving piping, valves and fittings. The table has 5 fields and uses a combination of 4 fields to identify each valve and insualtion thickness to get the item price. It appears that so many fields are repeated data that I question if it is...

I wish to store the $ totals calculated on an invoice/report back into an invoice summary table. How can I do this using VBA? I currently produce a daily invoice for labour and materials used on a job which is signed by the client daily. From a form I enter the job number, date, invoice number...

I want to document my database so I know what tables are used in a particular query and which forms use that query. In this way if I have to change a table or query I know which other objects I need to update. I also want to track and document the changes I make to the various database objects...

On a multiselect listbox I cannot use the up, down arrows or drag the vertical scroll bar on the right hand side. What properties should I look at? (Access 2003) The listbox functions perfectly other than this problem. I can select/multiselect the records but to move down the list (150...

Hi folks, I'm new to your forum and need some help figuring out the 2003 equivalence to the 97 recordset code I am used to. I would like to add, update, delete data to my tables using recordsets. I learnt Access 97 at college 10 yrs ago and haven't used it for many years. Now I have to do a...