Recent content by Terri58ds

Thanks for the replies and your reassurance folks. Plog, I had been wondering if I needed to do something like that but I agree, it does just complicate the table (not easily readable) and adds another layer. Nope, price is just a hardcoded number. Repeating the same word just looked odd and...

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...

Thanks so much for the info and links. I've had a quick read two days ago and hope to read in depth this weekwend. ETA: HiTechCoach's links pointed me to some great info from Crystal. On further reading and linking through, I found a dead simple solution - the Object Dependencies already...

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...

Statsman, Is there a way to import/convert the Word document to a report to use as the template you describe? I recently had to recreate a Word doc as a report and it took me ages doing it from scratch in design view.

Blank Rows: I had the same issue with fixed number of lines last week and found the answer on this forum under the topic "Fill page with blank field" topic number 31873 http://www.access-programmers.co.uk/forums/showthread.php?t=31873 There was a sample DB attached but seems to be removed...

Thanks for the suggestion which put me on the right track. The listbox was wide enough, I didn't have a horizontal scrollbar and had plenty of space on the right after column 5, but you clued me in to investigating the column widths. After goofing around a bit I got it fixed. THANKS! What I...

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...

Thanks to all for your help. Paul: I've checked DOA and tweaked my code as you suggested. This is great as I can get up and running fast by grabbing bits of old code. Bob: Thanks for that explanation which helps a lot. My new project was actually started on my home machine (Access 2000)...

Thanks Paul. Aha! That's why my 97 project converted to 2000 still works (DOA 3.6 is checked) but the new project (DOA not checked) doesn't accept the same code. However, the one book mentions that DOA only works with Jet engines, whereas ADO also works with SQL as well as stating ... "...if...

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...