Edit previously saved Field in a Form
in [Getting Started]
|
From: Palto Fondberg on 9 Jun 2008 06:13 Hi I want to be able to edit some or all fields which have previously been entered on a form. Records have been previously entered and saved by being typed in and/or selected on a form. When I select a particular CustomerID, I can view particular saved records, and I want to introduce the option to amend particular fields. I want to have an 'on click' event, whereby I can edit these fields. Although I've looked at "allow edits" and such like, I'm struggling with what exactly I should do, and what code to use/how to structure it. Can someone help please?
From: Jeff Boyce on 9 Jun 2008 09:52 If you bind a form to a table you should be able to "edit" the fields display via the form. -- Regards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ "Palto Fondberg" <dummy(a)dummyaddress.dummy> wrote in message news:OzCY9lhyIHA.4704(a)TK2MSFTNGP03.phx.gbl... > Hi > > I want to be able to edit some or all fields which have previously been > entered on a form. > Records have been previously entered and saved by being typed in and/or > selected on a form. When I select a particular CustomerID, I can view > particular saved records, and I want to introduce the option to amend > particular fields. I want to have an 'on click' event, whereby I can edit > these fields. Although I've looked at "allow edits" and such like, I'm > struggling with what exactly I should do, and what code to use/how to > structure it. Can someone help please? > >
From: Palto Fondberg on 9 Jun 2008 09:24 Yes Jeff. For others out there who are looking for help on this, I figured out what I was doing wrong. You can't amend Form details if that particular Form is based on a query which cannot be amended. [ie: as a quick check, run the underlying query behind the form, and try and edit one of the fields - if you can't do this, then you need to look into how you have created the query - you may have to delete one or more tables within this query before you have an "amendable" query - Once you have a query which allows you to edit the result fields then you can use this to base your form on - hence you will then be able to edit the fields. I hope this makes sense - Jeff, am I right? thanks "Jeff Boyce" <JeffBoyce_IF(a)msn.com-DISCARD_HYPHEN_TO_END> wrote in message news:%23F3ML%23iyIHA.524(a)TK2MSFTNGP05.phx.gbl... > If you bind a form to a table you should be able to "edit" the fields > display via the form. > > -- > Regards > > Jeff Boyce > www.InformationFutures.net > > Microsoft Office/Access MVP > http://mvp.support.microsoft.com/ > > Microsoft IT Academy Program Mentor > http://microsoftitacademy.com/ > > "Palto Fondberg" <dummy(a)dummyaddress.dummy> wrote in message > news:OzCY9lhyIHA.4704(a)TK2MSFTNGP03.phx.gbl... >> Hi >> >> I want to be able to edit some or all fields which have previously been >> entered on a form. >> Records have been previously entered and saved by being typed in and/or >> selected on a form. When I select a particular CustomerID, I can view >> particular saved records, and I want to introduce the option to amend >> particular fields. I want to have an 'on click' event, whereby I can edit >> these fields. Although I've looked at "allow edits" and such like, I'm >> struggling with what exactly I should do, and what code to use/how to >> structure it. Can someone help please? >> >> >
From: Jeff Boyce on 10 Jun 2008 09:10 I couldn't have said it better myself. Thanks for posting back what you found ... it will help others who are looking for this answer. -- Regards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ "Palto Fondberg" <dummy(a)dummyaddress.dummy> wrote in message news:OoF94QjyIHA.4864(a)TK2MSFTNGP06.phx.gbl... > Yes Jeff. > > For others out there who are looking for help on this, I figured out what I > was doing wrong. You can't amend Form details if that particular Form is > based on a query which cannot be amended. [ie: as a quick check, run the > underlying query behind the form, and try and edit one of the fields - if > you can't do this, then you need to look into how you have created the > query - you may have to delete one or more tables within this query before > you have an "amendable" query - Once you have a query which allows you to > edit the result fields then you can use this to base your form on - hence > you will then be able to edit the fields. > > I hope this makes sense - Jeff, am I right? > > > thanks > > "Jeff Boyce" <JeffBoyce_IF(a)msn.com-DISCARD_HYPHEN_TO_END> wrote in message > news:%23F3ML%23iyIHA.524(a)TK2MSFTNGP05.phx.gbl... > > If you bind a form to a table you should be able to "edit" the fields > > display via the form. > > > > -- > > Regards > > > > Jeff Boyce > > www.InformationFutures.net > > > > Microsoft Office/Access MVP > > http://mvp.support.microsoft.com/ > > > > Microsoft IT Academy Program Mentor > > http://microsoftitacademy.com/ > > > > "Palto Fondberg" <dummy(a)dummyaddress.dummy> wrote in message > > news:OzCY9lhyIHA.4704(a)TK2MSFTNGP03.phx.gbl... > >> Hi > >> > >> I want to be able to edit some or all fields which have previously been > >> entered on a form. > >> Records have been previously entered and saved by being typed in and/or > >> selected on a form. When I select a particular CustomerID, I can view > >> particular saved records, and I want to introduce the option to amend > >> particular fields. I want to have an 'on click' event, whereby I can edit > >> these fields. Although I've looked at "allow edits" and such like, I'm > >> struggling with what exactly I should do, and what code to use/how to > >> structure it. Can someone help please? > >> > >> > > > >
|
Pages: 1 Prev: Cummulative Next: updating data from one table to insert into a scond table |