How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask ATLPROG Your Own Question
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7260
Experience:  MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
Type Your Programming Question Here...
ATLPROG is online now

access programming - VBA I have a Datasheet that i use to

Customer Question

access programming - VBA

I have a Datasheet that i use to display a query of details relating to Projects.

i have a button that opens another datasheet (Datasheet Query B)and allows me to select True/False field for each record.

i would like to update the records selected with a Incremental value taken from a text box on the Form.

my aim is to collect the detail records i am interested and have them grouped together for printing in a later report

i have come across an error during my
access can't update all the records in the update query - 1 record(s) due to key violations.

any ideas where i might be going wrong, or alternatives for what i am trying to achieve?
Submitted: 4 years ago.
Category: Programming
Expert:  Richard replied 4 years ago.
Thank you for your question, my name is Richard.

Can I look at the Access File please?

Then I can see where the issue is occuring.

- Click the following link:
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

And also tell me where the form and button is located.

Thank you