How can I add an edit record button Jamie76 28.09.2006 12:33:02 Hi, I would like to add an 'edit record' button to my form. Can anyone help getting me started on doing this. I'm pretty new to Access so am not that familiar with it. Do i need to change the data in the table in order for this to work? If so how can i create a button that takes me to the relevant item in the table? Thanks Jamie

Re: How can I add an edit record button "Graham R Seach" <gseach[ at ]accessmvp_REMOVE.com> 28.09.2006 12:50:10 Jamie, Unless you've done something wierd, you already have the ability to update (edit) the data in the form. Why do you think you can't? Regards, Graham R Seach Microsoft Access MVP Sydney, Australia --------------------------- "Jamie76" <Jamie76[ at ]discussions.microsoft.com> wrote in message news:BB7B504A-980F-45BD-B1A8-A2E21C8045F0[ at ]microsoft.com... [Quoted Text] > Hi, > > I would like to add an 'edit record' button to my form. Can anyone help > getting me started on doing this. I'm pretty new to Access so am not that > familiar with it. Do i need to change the data in the table > in order for this to work? If so how can i create a button that takes me > to > the relevant item in the table? > > Thanks > Jamie >

Re: How can I add an edit record button Jamie76 28.09.2006 12:55:01 Thanks for the reply Graham, I had locked the fields as i want to be able to share the database on the network and didn't want people accidently altering stuff. There is probably a very simple way arouns this but as i say i am a bit of a novice. Cheers "Graham R Seach" wrote: [Quoted Text] > Jamie, > > Unless you've done something wierd, you already have the ability to update > (edit) the data in the form. Why do you think you can't? > > Regards, > Graham R Seach > Microsoft Access MVP > Sydney, Australia > --------------------------- > > "Jamie76" <Jamie76[ at ]discussions.microsoft.com> wrote in message > news:BB7B504A-980F-45BD-B1A8-A2E21C8045F0[ at ]microsoft.com... > > Hi, > > > > I would like to add an 'edit record' button to my form. Can anyone help > > getting me started on doing this. I'm pretty new to Access so am not that > > familiar with it. Do i need to change the data in the table > > in order for this to work? If so how can i create a button that takes me > > to > > the relevant item in the table? > > > > Thanks > > Jamie > > > > >

Re: How can I add an edit record button Cheese_whiz 28.09.2006 17:43:01 I think what I did was add this to the form "on current" event: Private Sub Form_Current() Me.AllowEdits = False End Sub ____________ Then, I added a control button to the form, just cancelled the wizard for it, clicked on it, clicked on the "on click" event, and added this: Sub MyEditButton_Click() Me.AllowEdits = True End Sub _____ After that, I went and added/formated the text/picture for the button. Seems to work ok. I'm no expert though. CW "Jamie76" wrote: [Quoted Text] > Thanks for the reply Graham, > > I had locked the fields as i want to be able to share the database on the > network and didn't want people accidently altering stuff. There is probably a > very simple way arouns this but as i say i am a bit of a novice. > > Cheers > > "Graham R Seach" wrote: > > > Jamie, > > > > Unless you've done something wierd, you already have the ability to update > > (edit) the data in the form. Why do you think you can't? > > > > Regards, > > Graham R Seach > > Microsoft Access MVP > > Sydney, Australia > > --------------------------- > > > > "Jamie76" <Jamie76[ at ]discussions.microsoft.com> wrote in message > > news:BB7B504A-980F-45BD-B1A8-A2E21C8045F0[ at ]microsoft.com... > > > Hi, > > > > > > I would like to add an 'edit record' button to my form. Can anyone help > > > getting me started on doing this. I'm pretty new to Access so am not that > > > familiar with it. Do i need to change the data in the table > > > in order for this to work? If so how can i create a button that takes me > > > to > > > the relevant item in the table? > > > > > > Thanks > > > Jamie > > > > > > > > >

Re: How can I add an edit record button Cheese_whiz 28.09.2006 17:48:02 Terrible explanation by me! When I say "clicked on the 'on current'" and "clicked on the 'on click'" events, what I meant is clicked on them in the properties window, and then chose the (...) button that appeared and "code builder" to get to where the code goes. Also, the beginning and ending lines are already included when you do that, so all you have to add is the middle line with the AllowEdits in it. CW "Cheese_whiz" wrote: [Quoted Text] > I think what I did was add this to the form "on current" event: > > Private Sub Form_Current() > Me.AllowEdits = False > End Sub > ____________ > > Then, I added a control button to the form, just cancelled the wizard for > it, clicked on it, clicked on the "on click" event, and added this: > > Sub MyEditButton_Click() > Me.AllowEdits = True > End Sub > _____ > > After that, I went and added/formated the text/picture for the button. > > Seems to work ok. > > I'm no expert though. > CW > > > "Jamie76" wrote: > > > Thanks for the reply Graham, > > > > I had locked the fields as i want to be able to share the database on the > > network and didn't want people accidently altering stuff. There is probably a > > very simple way arouns this but as i say i am a bit of a novice. > > > > Cheers > > > > "Graham R Seach" wrote: > > > > > Jamie, > > > > > > Unless you've done something wierd, you already have the ability to update > > > (edit) the data in the form. Why do you think you can't? > > > > > > Regards, > > > Graham R Seach > > > Microsoft Access MVP > > > Sydney, Australia > > > --------------------------- > > > > > > "Jamie76" <Jamie76[ at ]discussions.microsoft.com> wrote in message > > > news:BB7B504A-980F-45BD-B1A8-A2E21C8045F0[ at ]microsoft.com... > > > > Hi, > > > > > > > > I would like to add an 'edit record' button to my form. Can anyone help > > > > getting me started on doing this. I'm pretty new to Access so am not that > > > > familiar with it. Do i need to change the data in the table > > > > in order for this to work? If so how can i create a button that takes me > > > > to > > > > the relevant item in the table? > > > > > > > > Thanks > > > > Jamie > > > > > > > > > > > > >

Re: How can I add an edit record button "Graham R Seach" <gseach[ at ]accessmvp_REMOVE.com> 29.09.2006 12:08:54 OK, all you need to do is add a button, and add the following code to it's Click event: Me.AllowEdits = True Regards, Graham R Seach Microsoft Access MVP Sydney, Australia --------------------------- "Cheese_whiz" <Cheesewhiz[ at ]discussions.microsoft.com> wrote in message news:F8F1A439-8699-4B1B-8CD7-62A5AE4BB31A[ at ]microsoft.com... [Quoted Text] > Terrible explanation by me! > > When I say "clicked on the 'on current'" and "clicked on the 'on click'" > events, what I meant is clicked on them in the properties window, and then > chose the (...) button that appeared and "code builder" to get to where > the > code goes. > > Also, the beginning and ending lines are already included when you do > that, > so all you have to add is the middle line with the AllowEdits in it. > > CW > > "Cheese_whiz" wrote: > >> I think what I did was add this to the form "on current" event: >> >> Private Sub Form_Current() >> Me.AllowEdits = False >> End Sub >> ____________ >> >> Then, I added a control button to the form, just cancelled the wizard for >> it, clicked on it, clicked on the "on click" event, and added this: >> >> Sub MyEditButton_Click() >> Me.AllowEdits = True >> End Sub >> _____ >> >> After that, I went and added/formated the text/picture for the button. >> >> Seems to work ok. >> >> I'm no expert though. >> CW >> >> >> "Jamie76" wrote: >> >> > Thanks for the reply Graham, >> > >> > I had locked the fields as i want to be able to share the database on >> > the >> > network and didn't want people accidently altering stuff. There is >> > probably a >> > very simple way arouns this but as i say i am a bit of a novice. >> > >> > Cheers >> > >> > "Graham R Seach" wrote: >> > >> > > Jamie, >> > > >> > > Unless you've done something wierd, you already have the ability to >> > > update >> > > (edit) the data in the form. Why do you think you can't? >> > > >> > > Regards, >> > > Graham R Seach >> > > Microsoft Access MVP >> > > Sydney, Australia >> > > --------------------------- >> > > >> > > "Jamie76" <Jamie76[ at ]discussions.microsoft.com> wrote in message >> > > news:BB7B504A-980F-45BD-B1A8-A2E21C8045F0[ at ]microsoft.com... >> > > > Hi, >> > > > >> > > > I would like to add an 'edit record' button to my form. Can anyone >> > > > help >> > > > getting me started on doing this. I'm pretty new to Access so am >> > > > not that >> > > > familiar with it. Do i need to change the data in the table >> > > > in order for this to work? If so how can i create a button that >> > > > takes me >> > > > to >> > > > the relevant item in the table? >> > > > >> > > > Thanks >> > > > Jamie >> > > > >> > > >> > > >> > >