?
Solved

MS Access: Edit Button

Posted on 2008-11-06
8
Medium Priority
?
860 Views
Last Modified: 2013-11-28
Hi,
I am new at Access and I am creating an intake system for work.  I have a "browse all intake" datasheet where all the data entered into the intake will be displayed.  I would like to add an "edit" button into the datasheet so that the users can edit the data where needed.  Can someone please help me with this?  Thank you for your time.

0
Comment
Question by:sarah_siu
  • 5
  • 3
8 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22902162
sarah_siu,

1. All "Editing" should take place in a from, not the table.

2. Furthermore, you cannot put buttons on a anything in "Datasheet View" anyway.

3. Lastly, (Unless explictly disable it) the form should be in "Edit" mode by default.
So I don't see the need for an "Edit" button.

Can you please clarify what you are trying to accomplish with this system?

JeffCoachman

JeffCoachman
0
 

Author Comment

by:sarah_siu
ID: 22904294
I have a Browse_All_Intake form in the datasheet view right now which can be accessed by pressing a button on a form.  I would like to add an "edit" link to this datasheet (in the first column) so that when i go into this "edit" link, the form pertaining to the line of data will pop up and then the user can edit whatever they want on the form and save it back to the table.  So, not so much an edit button as oppose to an "edit" link in the first column. How do I tie the edit links for each line of data to its the correct form?  
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22905605
Try this:

Click the record Selector button (The button/box immediately to the left of the record), to jump to the "Edit" Form.

JeffCoachman
Access-EEQ23883437OpenRelatedRec.mdb
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22905700
Try this:

Click the record Selector button (The button/box immediately to the left of the record), to jump to the "Edit" Form.

JeffCoachman
Access-EEQ23883437OpenRelatedRec.mdb
0
 

Author Comment

by:sarah_siu
ID: 22905785
I see what you mean.  When I select the record selector button, only the fields in my "browse_all_intake" shows up as a form.  

What I would like is to have the actual form (the form that the user had originally filled in with all fields in the database table) to pop up instead.  I know I have to create an edit link so that it links to the form but i'm not sure how to go about it.  Do I need to create a macro and then input it in the "on-click" section in the properties?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 1000 total points
ID: 22907554
sarah_siu,

How many form do you have to do this?
I count 3 so far?

"When I select the record selector button, only the fields in my "browse_all_intake" shows up as a form."
Didn't you know what fields the  "browse_all_intake" form would display?

Basically you need to examine the code I put on each form.
Then apply the same code to the forms you want to use.

Try this on your own first, then post back if you have any issues.

JeffCoachman
0
 

Author Closing Comment

by:sarah_siu
ID: 31514139
Excellent job.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22908310
;-)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question