(Msg. 1) Posted: Mon Oct 06, 2008 8:08 am
Post subject: edit function in a table Archived from groups: microsoft>public>access>tablesdbdesign (more info?)
I have a form that lists employee accomplishments. I have to update these
all the time. The form has a table in it, and one of the columns in the
table is called "Edit." It used to be that if I needed to change an entry, I
could click on the "edit" column, and it would open another form that allows
me to see the full texts of each entry, pulling up the specific entry that I
wanted to edit. Now, when I click on the "edit" column, it just brings up
the first form in the database, and I have to go find the record that I want
to edit.
I'm not sure what happened. I recently moved this database to a secure
location, so that content could be permanently enabled, so maybe I broke a
link somehow. Can anyone help me get the "Edit" column to link to these
specific records again?
(Msg. 2) Posted: Tue Oct 07, 2008 6:50 am
Post subject: RE: edit function in a table [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I expect there should be some code that you need to share. What code opens
the form? What happens if you click anywhere in the record prior to clicking
the Edit?
--
Duane Hookom
Microsoft Access MVP
"neuromoe" wrote:
> I have a form that lists employee accomplishments. I have to update these
> all the time. The form has a table in it, and one of the columns in the
> table is called "Edit." It used to be that if I needed to change an entry, I
> could click on the "edit" column, and it would open another form that allows
> me to see the full texts of each entry, pulling up the specific entry that I
> wanted to edit. Now, when I click on the "edit" column, it just brings up
> the first form in the database, and I have to go find the record that I want
> to edit.
>
> I'm not sure what happened. I recently moved this database to a secure
> location, so that content could be permanently enabled, so maybe I broke a
> link somehow. Can anyone help me get the "Edit" column to link to these
> specific records again?
>
> Thanks!
>
(Msg. 3) Posted: Tue Oct 07, 2008 1:16 pm
Post subject: RE: edit function in a table [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Duane,
Yes, I think it has to do with VBA code, but I know nothing about Visual
Basic, so I can't answer your first question. If I click somewhere else in
the record before clicking edit, the same thing happens: it pulls up a blank
form and it's record 1 of 1. I can click the filter button, and then it'll
take me to the other 350 records so I can search through them, but it doesn't
filter correctly so that the right record opens. I have compared the VBA
code for the edit function with another database on which the function works,
but they seem to be the same. Again, I don't know Visual Basic, so I
probably don't know what I'm talking about. Any suggestions?
Thanks!
"Duane Hookom" wrote:
> I expect there should be some code that you need to share. What code opens
> the form? What happens if you click anywhere in the record prior to clicking
> the Edit?
>
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "neuromoe" wrote:
>
> > I have a form that lists employee accomplishments. I have to update these
> > all the time. The form has a table in it, and one of the columns in the
> > table is called "Edit." It used to be that if I needed to change an entry, I
> > could click on the "edit" column, and it would open another form that allows
> > me to see the full texts of each entry, pulling up the specific entry that I
> > wanted to edit. Now, when I click on the "edit" column, it just brings up
> > the first form in the database, and I have to go find the record that I want
> > to edit.
> >
> > I'm not sure what happened. I recently moved this database to a secure
> > location, so that content could be permanently enabled, so maybe I broke a
> > link somehow. Can anyone help me get the "Edit" column to link to these
> > specific records again?
> >
> > Thanks!
> >
(Msg. 4) Posted: Tue Oct 07, 2008 1:32 pm
Post subject: RE: edit function in a table [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Try to go to the design view, find the code, copy it, and paste it into a
reply.
You could try creating a button in the detail section that would open the
form to display the current record. There is a wizard that should do all of
this for you.
--
Duane Hookom
Microsoft Access MVP
"neuromoe" wrote:
> Hi Duane,
>
> Yes, I think it has to do with VBA code, but I know nothing about Visual
> Basic, so I can't answer your first question. If I click somewhere else in
> the record before clicking edit, the same thing happens: it pulls up a blank
> form and it's record 1 of 1. I can click the filter button, and then it'll
> take me to the other 350 records so I can search through them, but it doesn't
> filter correctly so that the right record opens. I have compared the VBA
> code for the edit function with another database on which the function works,
> but they seem to be the same. Again, I don't know Visual Basic, so I
> probably don't know what I'm talking about. Any suggestions?
>
> Thanks!
>
> "Duane Hookom" wrote:
>
> > I expect there should be some code that you need to share. What code opens
> > the form? What happens if you click anywhere in the record prior to clicking
> > the Edit?
> >
> > --
> > Duane Hookom
> > Microsoft Access MVP
> >
> >
> > "neuromoe" wrote:
> >
> > > I have a form that lists employee accomplishments. I have to update these
> > > all the time. The form has a table in it, and one of the columns in the
> > > table is called "Edit." It used to be that if I needed to change an entry, I
> > > could click on the "edit" column, and it would open another form that allows
> > > me to see the full texts of each entry, pulling up the specific entry that I
> > > wanted to edit. Now, when I click on the "edit" column, it just brings up
> > > the first form in the database, and I have to go find the record that I want
> > > to edit.
> > >
> > > I'm not sure what happened. I recently moved this database to a secure
> > > location, so that content could be permanently enabled, so maybe I broke a
> > > link somehow. Can anyone help me get the "Edit" column to link to these
> > > specific records again?
> > >
> > > Thanks!
> > >
(Msg. 5) Posted: Tue Oct 07, 2008 1:44 pm
Post subject: RE: edit function in a table [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Duane,
I hope this is what you wanted. The only code i can find is this:
> Try to go to the design view, find the code, copy it, and paste it into a
> reply.
>
> You could try creating a button in the detail section that would open the
> form to display the current record. There is a wizard that should do all of
> this for you.
>
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "neuromoe" wrote:
>
> > Hi Duane,
> >
> > Yes, I think it has to do with VBA code, but I know nothing about Visual
> > Basic, so I can't answer your first question. If I click somewhere else in
> > the record before clicking edit, the same thing happens: it pulls up a blank
> > form and it's record 1 of 1. I can click the filter button, and then it'll
> > take me to the other 350 records so I can search through them, but it doesn't
> > filter correctly so that the right record opens. I have compared the VBA
> > code for the edit function with another database on which the function works,
> > but they seem to be the same. Again, I don't know Visual Basic, so I
> > probably don't know what I'm talking about. Any suggestions?
> >
> > Thanks!
> >
> > "Duane Hookom" wrote:
> >
> > > I expect there should be some code that you need to share. What code opens
> > > the form? What happens if you click anywhere in the record prior to clicking
> > > the Edit?
> > >
> > > --
> > > Duane Hookom
> > > Microsoft Access MVP
> > >
> > >
> > > "neuromoe" wrote:
> > >
> > > > I have a form that lists employee accomplishments. I have to update these
> > > > all the time. The form has a table in it, and one of the columns in the
> > > > table is called "Edit." It used to be that if I needed to change an entry, I
> > > > could click on the "edit" column, and it would open another form that allows
> > > > me to see the full texts of each entry, pulling up the specific entry that I
> > > > wanted to edit. Now, when I click on the "edit" column, it just brings up
> > > > the first form in the database, and I have to go find the record that I want
> > > > to edit.
> > > >
> > > > I'm not sure what happened. I recently moved this database to a secure
> > > > location, so that content could be permanently enabled, so maybe I broke a
> > > > link somehow. Can anyone help me get the "Edit" column to link to these
> > > > specific records again?
> > > >
> > > > Thanks!
> > > >
(Msg. 6) Posted: Tue Oct 07, 2008 3:05 pm
Post subject: RE: edit function in a table [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
That is the correct code and should open the form named "Accomplishments"
with a filter of AccomplishmentID equal to the AccomplishmentID of
form/subform where the code is running.
--
Duane Hookom
Microsoft Access MVP
"neuromoe" wrote:
> Hi Duane,
>
> I hope this is what you wanted. The only code i can find is this:
>
> Option Compare Database
>
> Private Sub Edit_Click()
> DoCmd.OpenForm "Accomplishments", , , "Accomplishmentid = " &
> Me.AccomplishmentID
>
> End Sub
>
>
> Is there somewhere else I should look?
>
> Thanks!
>
>
>
> "Duane Hookom" wrote:
>
> > Try to go to the design view, find the code, copy it, and paste it into a
> > reply.
> >
> > You could try creating a button in the detail section that would open the
> > form to display the current record. There is a wizard that should do all of
> > this for you.
> >
> > --
> > Duane Hookom
> > Microsoft Access MVP
> >
> >
> > "neuromoe" wrote:
> >
> > > Hi Duane,
> > >
> > > Yes, I think it has to do with VBA code, but I know nothing about Visual
> > > Basic, so I can't answer your first question. If I click somewhere else in
> > > the record before clicking edit, the same thing happens: it pulls up a blank
> > > form and it's record 1 of 1. I can click the filter button, and then it'll
> > > take me to the other 350 records so I can search through them, but it doesn't
> > > filter correctly so that the right record opens. I have compared the VBA
> > > code for the edit function with another database on which the function works,
> > > but they seem to be the same. Again, I don't know Visual Basic, so I
> > > probably don't know what I'm talking about. Any suggestions?
> > >
> > > Thanks!
> > >
> > > "Duane Hookom" wrote:
> > >
> > > > I expect there should be some code that you need to share. What code opens
> > > > the form? What happens if you click anywhere in the record prior to clicking
> > > > the Edit?
> > > >
> > > > --
> > > > Duane Hookom
> > > > Microsoft Access MVP
> > > >
> > > >
> > > > "neuromoe" wrote:
> > > >
> > > > > I have a form that lists employee accomplishments. I have to update these
> > > > > all the time. The form has a table in it, and one of the columns in the
> > > > > table is called "Edit." It used to be that if I needed to change an entry, I
> > > > > could click on the "edit" column, and it would open another form that allows
> > > > > me to see the full texts of each entry, pulling up the specific entry that I
> > > > > wanted to edit. Now, when I click on the "edit" column, it just brings up
> > > > > the first form in the database, and I have to go find the record that I want
> > > > > to edit.
> > > > >
> > > > > I'm not sure what happened. I recently moved this database to a secure
> > > > > location, so that content could be permanently enabled, so maybe I broke a
> > > > > link somehow. Can anyone help me get the "Edit" column to link to these
> > > > > specific records again?
> > > > >
> > > > > Thanks!
> > > > >
(Msg. 7) Posted: Wed Oct 08, 2008 11:55 am
Post subject: RE: edit function in a table [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hmmm... any thoughts on why the code is not working? Is there another
setting that may be off?
Thanks!
"Duane Hookom" wrote:
> That is the correct code and should open the form named "Accomplishments"
> with a filter of AccomplishmentID equal to the AccomplishmentID of
> form/subform where the code is running.
>
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "neuromoe" wrote:
>
> > Hi Duane,
> >
> > I hope this is what you wanted. The only code i can find is this:
> >
> > Option Compare Database
> >
> > Private Sub Edit_Click()
> > DoCmd.OpenForm "Accomplishments", , , "Accomplishmentid = " &
> > Me.AccomplishmentID
> >
> > End Sub
> >
> >
> > Is there somewhere else I should look?
> >
> > Thanks!
> >
> >
> >
> > "Duane Hookom" wrote:
> >
> > > Try to go to the design view, find the code, copy it, and paste it into a
> > > reply.
> > >
> > > You could try creating a button in the detail section that would open the
> > > form to display the current record. There is a wizard that should do all of
> > > this for you.
> > >
> > > --
> > > Duane Hookom
> > > Microsoft Access MVP
> > >
> > >
> > > "neuromoe" wrote:
> > >
> > > > Hi Duane,
> > > >
> > > > Yes, I think it has to do with VBA code, but I know nothing about Visual
> > > > Basic, so I can't answer your first question. If I click somewhere else in
> > > > the record before clicking edit, the same thing happens: it pulls up a blank
> > > > form and it's record 1 of 1. I can click the filter button, and then it'll
> > > > take me to the other 350 records so I can search through them, but it doesn't
> > > > filter correctly so that the right record opens. I have compared the VBA
> > > > code for the edit function with another database on which the function works,
> > > > but they seem to be the same. Again, I don't know Visual Basic, so I
> > > > probably don't know what I'm talking about. Any suggestions?
> > > >
> > > > Thanks!
> > > >
> > > > "Duane Hookom" wrote:
> > > >
> > > > > I expect there should be some code that you need to share. What code opens
> > > > > the form? What happens if you click anywhere in the record prior to clicking
> > > > > the Edit?
> > > > >
> > > > > --
> > > > > Duane Hookom
> > > > > Microsoft Access MVP
> > > > >
> > > > >
> > > > > "neuromoe" wrote:
> > > > >
> > > > > > I have a form that lists employee accomplishments. I have to update these
> > > > > > all the time. The form has a table in it, and one of the columns in the
> > > > > > table is called "Edit." It used to be that if I needed to change an entry, I
> > > > > > could click on the "edit" column, and it would open another form that allows
> > > > > > me to see the full texts of each entry, pulling up the specific entry that I
> > > > > > wanted to edit. Now, when I click on the "edit" column, it just brings up
> > > > > > the first form in the database, and I have to go find the record that I want
> > > > > > to edit.
> > > > > >
> > > > > > I'm not sure what happened. I recently moved this database to a secure
> > > > > > location, so that content could be permanently enabled, so maybe I broke a
> > > > > > link somehow. Can anyone help me get the "Edit" column to link to these
> > > > > > specific records again?
> > > > > >
> > > > > > Thanks!
> > > > > >
(Msg. 8) Posted: Wed Oct 08, 2008 12:09 pm
Post subject: RE: edit function in a table [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I would place a BreakPoint in the code to see what is happening. You could
then make sure the code is running and the values.
You could also change your code to:
Private Sub Edit_Click()
Dim strWhere as String
strWhere = ""Accomplishmentid = " & Me.AccomplishmentID
MsgBox "strWhere: " & strWhere
DoCmd.OpenForm "Accomplishments", , , strWhere
End Sub
--
Duane Hookom
Microsoft Access MVP
"neuromoe" wrote:
> Hmmm... any thoughts on why the code is not working? Is there another
> setting that may be off?
>
> Thanks!
>
> "Duane Hookom" wrote:
>
> > That is the correct code and should open the form named "Accomplishments"
> > with a filter of AccomplishmentID equal to the AccomplishmentID of
> > form/subform where the code is running.
> >
> > --
> > Duane Hookom
> > Microsoft Access MVP
> >
> >
> > "neuromoe" wrote:
> >
> > > Hi Duane,
> > >
> > > I hope this is what you wanted. The only code i can find is this:
> > >
> > > Option Compare Database
> > >
> > > Private Sub Edit_Click()
> > > DoCmd.OpenForm "Accomplishments", , , "Accomplishmentid = " &
> > > Me.AccomplishmentID
> > >
> > > End Sub
> > >
> > >
> > > Is there somewhere else I should look?
> > >
> > > Thanks!
> > >
> > >
> > >
> > > "Duane Hookom" wrote:
> > >
> > > > Try to go to the design view, find the code, copy it, and paste it into a
> > > > reply.
> > > >
> > > > You could try creating a button in the detail section that would open the
> > > > form to display the current record. There is a wizard that should do all of
> > > > this for you.
> > > >
> > > > --
> > > > Duane Hookom
> > > > Microsoft Access MVP
> > > >
> > > >
> > > > "neuromoe" wrote:
> > > >
> > > > > Hi Duane,
> > > > >
> > > > > Yes, I think it has to do with VBA code, but I know nothing about Visual
> > > > > Basic, so I can't answer your first question. If I click somewhere else in
> > > > > the record before clicking edit, the same thing happens: it pulls up a blank
> > > > > form and it's record 1 of 1. I can click the filter button, and then it'll
> > > > > take me to the other 350 records so I can search through them, but it doesn't
> > > > > filter correctly so that the right record opens. I have compared the VBA
> > > > > code for the edit function with another database on which the function works,
> > > > > but they seem to be the same. Again, I don't know Visual Basic, so I
> > > > > probably don't know what I'm talking about. Any suggestions?
> > > > >
> > > > > Thanks!
> > > > >
> > > > > "Duane Hookom" wrote:
> > > > >
> > > > > > I expect there should be some code that you need to share. What code opens
> > > > > > the form? What happens if you click anywhere in the record prior to clicking
> > > > > > the Edit?
> > > > > >
> > > > > > --
> > > > > > Duane Hookom
> > > > > > Microsoft Access MVP
> > > > > >
> > > > > >
> > > > > > "neuromoe" wrote:
> > > > > >
> > > > > > > I have a form that lists employee accomplishments. I have to update these
> > > > > > > all the time. The form has a table in it, and one of the columns in the
> > > > > > > table is called "Edit." It used to be that if I needed to change an entry, I
> > > > > > > could click on the "edit" column, and it would open another form that allows
> > > > > > > me to see the full texts of each entry, pulling up the specific entry that I
> > > > > > > wanted to edit. Now, when I click on the "edit" column, it just brings up
> > > > > > > the first form in the database, and I have to go find the record that I want
> > > > > > > to edit.
> > > > > > >
> > > > > > > I'm not sure what happened. I recently moved this database to a secure
> > > > > > > location, so that content could be permanently enabled, so maybe I broke a
> > > > > > > link somehow. Can anyone help me get the "Edit" column to link to these
> > > > > > > specific records again?
> > > > > > >
> > > > > > > Thanks!
> > > > > > >
All times are: Eastern Time (US & Canada) (change) Goto page 1, 2
Page 1 of 2
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other