none
automated method of editing records using forms RRS feed

  • Question

  • Hello,

    I am new to access and have been trying to solve this problem for days, and can't seem to dig up anything online. Any help will be appreciated!

    I am making a database to rent out equipment at my company. You can find my current version here if interested:https://1drv.ms/f/s!AkwyiifpjisUgdQseWttuH-E6yYPDw

    My problem:

    I would like to edit records using a form. I know this is possible when you have a table inside the form displaying all of the records available, and you just choose which one. However, the problem with this, is that my users don't know what item to pick in a table, they want to choose an image (picture of bike, not description of bike).

    What I have been trying to do is:
    I have a table with records for bikes, and I have a form that is used to view the bike information along with the images. I have a button beside each bike that says "check out". I have managed to get this to work. The problem comes with "check in". I can't seem to figure out how to get the button macro to ensure I am editing the correct record. 

    Any ideas?? 

    Thanks in advance!!

    Matt

    Wednesday, March 29, 2017 1:32 PM

Answers

  • Hi Matt,

    Haven't downloaded your file but you should have an ID field to identify each record uniquely. The ID field will make sure you're editing the correct record.

    Hope it helps...

    • Marked as answer by Matt_wpg Wednesday, March 29, 2017 8:53 PM
    Wednesday, March 29, 2017 2:37 PM
  • Thanks @.theDBguy

    I actually just got it working by using three forms in total. The user can use a continuous form to see the images, then click a button that brings opens a "detail form" (single form). Then finally a button that says "check in" will bring them to the check in form, which opens in "edit mode". This now does exactly what I want.

    For some reason, it was not abiding by the unique ID with my previous method. I think it may be because of how I have the relationships setup? I am still a beginner at access, so this is quite the learning curve for me right now.

    Thanks for the reply. hopefully this helps someone in the future.

    • Marked as answer by Matt_wpg Wednesday, March 29, 2017 8:53 PM
    Wednesday, March 29, 2017 8:52 PM

All replies

  • Hi Matt,

    Haven't downloaded your file but you should have an ID field to identify each record uniquely. The ID field will make sure you're editing the correct record.

    Hope it helps...

    • Marked as answer by Matt_wpg Wednesday, March 29, 2017 8:53 PM
    Wednesday, March 29, 2017 2:37 PM
  • Thanks @.theDBguy

    I actually just got it working by using three forms in total. The user can use a continuous form to see the images, then click a button that brings opens a "detail form" (single form). Then finally a button that says "check in" will bring them to the check in form, which opens in "edit mode". This now does exactly what I want.

    For some reason, it was not abiding by the unique ID with my previous method. I think it may be because of how I have the relationships setup? I am still a beginner at access, so this is quite the learning curve for me right now.

    Thanks for the reply. hopefully this helps someone in the future.

    • Marked as answer by Matt_wpg Wednesday, March 29, 2017 8:53 PM
    Wednesday, March 29, 2017 8:52 PM
  • Hi Matt,

    You're welcome. Glad to hear you got it sorted out. Good luck with your project.

    Wednesday, March 29, 2017 9:07 PM