Morning all,
I've used access a lot over the past years but I've never got too involved with creating new databases, just using and modifying templates.
I am currently using an inventory template and over the years i have done some basic modifications to make it exactly what we need. I've had a few hiccups and issues along the way but I've always managed to fix them with a bit of googling.
The database I have been using has been working faultlessly for over a year now so I thought it was about time to turn it into a template so I can keep an inventory of other product categories (engine parts). However although to basic template works it seems to have created several 'bugs'. The first of which is it changed one of the forms 'allow edits' to a no. I managed to rectify this with a bit of help from this forum but I now have another issue which is annoying me and I cant seem to find a solution; I can add a product using a 'new product form', click 'Save', all goes well no issues, puts the correct data in the correct table etc, however if I then click on the record to edit any of the information, when I go to click save it comes up with an error: 'The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship. Change the data in the fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again'. If I click 'Ok' and then 'Save' again it then saves fine. I can then check the table and the data has updated successfully.
I very much consider myself a noob when it comes to coding, VB and macros etc so I have tried to follow some of the 'how to's but none of them seem to apply to my current situation.
Throughout all this my original database is working absolutely fine still with no issues.
Any help would be greatly appreciated before I bin the whole thing and give up.
Thanks
I've used access a lot over the past years but I've never got too involved with creating new databases, just using and modifying templates.
I am currently using an inventory template and over the years i have done some basic modifications to make it exactly what we need. I've had a few hiccups and issues along the way but I've always managed to fix them with a bit of googling.
The database I have been using has been working faultlessly for over a year now so I thought it was about time to turn it into a template so I can keep an inventory of other product categories (engine parts). However although to basic template works it seems to have created several 'bugs'. The first of which is it changed one of the forms 'allow edits' to a no. I managed to rectify this with a bit of help from this forum but I now have another issue which is annoying me and I cant seem to find a solution; I can add a product using a 'new product form', click 'Save', all goes well no issues, puts the correct data in the correct table etc, however if I then click on the record to edit any of the information, when I go to click save it comes up with an error: 'The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship. Change the data in the fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again'. If I click 'Ok' and then 'Save' again it then saves fine. I can then check the table and the data has updated successfully.
I very much consider myself a noob when it comes to coding, VB and macros etc so I have tried to follow some of the 'how to's but none of them seem to apply to my current situation.
Throughout all this my original database is working absolutely fine still with no issues.
Any help would be greatly appreciated before I bin the whole thing and give up.
Thanks