98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Updating a table that has primary keys in it | Access forum
Updating a table that has primary keys in it | Access forum
Resolved · Medium Priority · Version 2007
Wed 29 Jan 2014, 13:25Delegate Martin said...
Martin has attended:
Access VBA course
SQL Server course
Updating a table that has primary keys in it
Hi,
I have a database with several tables in it each linked by not one but five (5) fields that form a primary key. The normal way of inputing data is via a form but I have 150 records to add and I have all the data in an excel spreadsheet so would like to do a bulk add and update.
All the data I want to add is to a single table that has all the keys contained within it. I have tried importing the data to the table and this works, in that I can see the additional data in the table. However, when I look at the data via the form I don't see the new records.
Any help would be much apreciated.
Regards
Martin
Fri 31 Jan 2014, 09:19Trainer Doug said...
RE: Updating a table that has primary keys in it
Hi Martin
Sounds a bit of a puzzle. If the data gets imported into your table it should appear in your form. Would you be able to email your database to info@stl-training.co.uk ?
Best to zip the file and ask for it to be forwarded to me.
Thanks.
Regards
Doug Dunn
Best STL
Tue 18 Feb 2014, 13:51Delegate Martin said...
RE: Updating a table that has primary keys in it
After several attempts I have managed to write an update query that not only updates the primary table but also its linked table that also has all five primary fields in it.
Little convoluted but can see why I needed to it this way.
A good learning session.
Thanks
Martin
Tue 18 Feb 2014, 16:58Trainer Doug said...
RE: Updating a table that has primary keys in it
Well done.
Sounds like you have solved it!
Doug
Best STL
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Switchboard StartupAn option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed. |
