Replies

Your database is the tables. Everything else can be copied (drag the origingal in explorer to create a complete copy and rename )or exported to the new database. Now all that is left is for your user to create a new table and I think that the process of creating you a new table gives you the choice of current or other db.
The create new table can be done with an SQL expression in code which can be done by creating the table via a query, switching to SQL view and copying the code. I’m fairly sure that you could add the new table name to the SQL. My difficulty is that I am unable to remember the detail and would have to spend half an hour fiddling and testing to get the precise syntax. I hope this gives you some pointers if no one else gives you a more precise answer. The target db name and path could be put in a string, but the syntax of including a string within an SQL is a bit hairy.
Hope this helps.
Mike

It looks to me as though you need a report which is based on a query.
The query will select the product and possibly the customerID. You can make the ID not show by unchecking the show box in the query.
You say you are a beginner: Tables store the data, Queries are used to ask questions of the data and if you use more than one table in the query it is here that you can get a db which appears to work but doesn’t give all the results – see MS web site on designing databases. It all depends on which of the 3 kinds of query joins you select. Forms are for displaying or entering data passed through to the underlying table. Reports are for taking away answers to your questions about the data. If you are a newbie then the above might point you to look at various aspects. Access is powerful and seductive but it is easy to make mistakes and get wrong or incomplete data so always test with 10 or 12 records and work out what you should get on paper first, so that you can be sure you are getting results which are both complete and correct. Hope it helps and am not teaching my grandmother to suck eggs.
Mike

Yes of course but its 369k. I’ve zipped it but still too large. Is there an email address I can send it to?
Mike

On Normal.doc It fails to save new docs based on Normal.dot and also existing docs.
However I opened a letter template that I created and use occasionally and that saves fine.
I can workaround it but it would be nice to cure it and not have to waste time working round by copying and pasting into docs based on the other template
Thanks for your time.
Mike

Thank you all for your help and for your time. IF and when I cure it and if its anything unusual I’ll post it
Mike

Thanks, It wasn’t the danger of deleting data so much as not getting it to run even as well as it does at present that has me worried. MS apps less and less like having earlier versions on the machine at the same time. I don’t use add ins a lot but its a nuisance when you see a useful one and want to try it out.
Thanks for your time.

Both Excel and Word and Access all have Addins greyed out. Tried Access help repair and Office Repair both without success. Reluctant to attempt to delete Access completely and reinstall as I have several important Apps running under Access.
Thank You for your time. Why does the world tolerate Microsoft???

Thanks for your response
Yes XL and Word both appear to be available.
In Access Builders work from time to time, but most times not.

Thank you for your reply and the time and effort you kindly spent in describing hoow to downlooad the License file. Unfortunately it didn’t do the trick. I’ve tried all sorts including the undeleting of Office 2k and 97 (Where’s the add /remove software gone from the control panel in 98 SE?)
I shall now try reluctantly with Access 2000.
Thanks again for your efforts.
Mike