(Msg. 1) Posted: Wed Jul 23, 2008 7:21 am
Post subject: Have form open to accept a new record Add to elertz Archived from groups: microsoft>public>access>gettingstarted (more info?)
I have a main form and a main form with subform. I would like these to open
ready to receive data, rather than populated with data from the first record.
I appreciate any help.
(Msg. 2) Posted: Wed Jul 23, 2008 7:24 am
Post subject: RE: Have form open to accept a new record Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Use the Data Mode argument of the OpenForm method and set it to acFormAdd.
--
Dave Hargis, Microsoft Access MVP
"rpbsr" wrote:
> I have a main form and a main form with subform. I would like these to open
> ready to receive data, rather than populated with data from the first record.
> I appreciate any help.
>
> Thanks,
> Robert
(Msg. 3) Posted: Wed Jul 23, 2008 7:51 am
Post subject: RE: Have form open to accept a new record Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Dave,
This sounds like a VBA solution, which I'm not very good at (but can
follow). Can you post an example? Does this use the OnOpen event?
"Klatuu" wrote:
> Use the Data Mode argument of the OpenForm method and set it to acFormAdd.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "rpbsr" wrote:
>
> > I have a main form and a main form with subform. I would like these to open
> > ready to receive data, rather than populated with data from the first record.
> > I appreciate any help.
> >
> > Thanks,
> > Robert
(Msg. 4) Posted: Wed Jul 23, 2008 8:12 am
Post subject: RE: Have form open to accept a new record Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
If you prefer to use a macro, use the OpenForm Action and select Add in the
Data Mode box. It requires nothing in any form event.
--
Dave Hargis, Microsoft Access MVP
"rpbsr" wrote:
> Dave,
> This sounds like a VBA solution, which I'm not very good at (but can
> follow). Can you post an example? Does this use the OnOpen event?
>
>
> "Klatuu" wrote:
>
> > Use the Data Mode argument of the OpenForm method and set it to acFormAdd.
> > --
> > Dave Hargis, Microsoft Access MVP
> >
> >
> > "rpbsr" wrote:
> >
> > > I have a main form and a main form with subform. I would like these to open
> > > ready to receive data, rather than populated with data from the first record.
> > > I appreciate any help.
> > >
> > > Thanks,
> > > Robert
(Msg. 5) Posted: Wed Jul 23, 2008 10:56 am
Post subject: RE: Have form open to accept a new record Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
The forms I'm referring to are opened from my switchboard, which use the
following OnClick events (=HandleButtonClick(number)) to open the form(s). It
sounds like you are suggesting I have the OnClick fire a macro to open the
form in Add Data Mode. I can see how this would work. Is my understanding
correct and will it adversely affect the Switchboard Table?
"Klatuu" wrote:
> If you prefer to use a macro, use the OpenForm Action and select Add in the
> Data Mode box. It requires nothing in any form event.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "rpbsr" wrote:
>
> > Dave,
> > This sounds like a VBA solution, which I'm not very good at (but can
> > follow). Can you post an example? Does this use the OnOpen event?
> >
> >
> > "Klatuu" wrote:
> >
> > > Use the Data Mode argument of the OpenForm method and set it to acFormAdd.
> > > --
> > > Dave Hargis, Microsoft Access MVP
> > >
> > >
> > > "rpbsr" wrote:
> > >
> > > > I have a main form and a main form with subform. I would like these to open
> > > > ready to receive data, rather than populated with data from the first record.
> > > > I appreciate any help.
> > > >
> > > > Thanks,
> > > > Robert
(Msg. 6) Posted: Wed Jul 23, 2008 11:00 am
Post subject: RE: Have form open to accept a new record Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
You don't even have to do that.
If you are using the Switchboard, Open the Switchboard manager and you can
select an option to open a form in add mode.
--
Dave Hargis, Microsoft Access MVP
"rpbsr" wrote:
> The forms I'm referring to are opened from my switchboard, which use the
> following OnClick events (=HandleButtonClick(number)) to open the form(s). It
> sounds like you are suggesting I have the OnClick fire a macro to open the
> form in Add Data Mode. I can see how this would work. Is my understanding
> correct and will it adversely affect the Switchboard Table?
>
> "Klatuu" wrote:
>
> > If you prefer to use a macro, use the OpenForm Action and select Add in the
> > Data Mode box. It requires nothing in any form event.
> > --
> > Dave Hargis, Microsoft Access MVP
> >
> >
> > "rpbsr" wrote:
> >
> > > Dave,
> > > This sounds like a VBA solution, which I'm not very good at (but can
> > > follow). Can you post an example? Does this use the OnOpen event?
> > >
> > >
> > > "Klatuu" wrote:
> > >
> > > > Use the Data Mode argument of the OpenForm method and set it to acFormAdd.
> > > > --
> > > > Dave Hargis, Microsoft Access MVP
> > > >
> > > >
> > > > "rpbsr" wrote:
> > > >
> > > > > I have a main form and a main form with subform. I would like these to open
> > > > > ready to receive data, rather than populated with data from the first record.
> > > > > I appreciate any help.
> > > > >
> > > > > Thanks,
> > > > > Robert
(Msg. 7) Posted: Wed Jul 23, 2008 11:07 am
Post subject: RE: Have form open to accept a new record Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Perfect, thanks Dave!
"Klatuu" wrote:
> You don't even have to do that.
> If you are using the Switchboard, Open the Switchboard manager and you can
> select an option to open a form in add mode.
>
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "rpbsr" wrote:
>
> > The forms I'm referring to are opened from my switchboard, which use the
> > following OnClick events (=HandleButtonClick(number)) to open the form(s). It
> > sounds like you are suggesting I have the OnClick fire a macro to open the
> > form in Add Data Mode. I can see how this would work. Is my understanding
> > correct and will it adversely affect the Switchboard Table?
> >
> > "Klatuu" wrote:
> >
> > > If you prefer to use a macro, use the OpenForm Action and select Add in the
> > > Data Mode box. It requires nothing in any form event.
> > > --
> > > Dave Hargis, Microsoft Access MVP
> > >
> > >
> > > "rpbsr" wrote:
> > >
> > > > Dave,
> > > > This sounds like a VBA solution, which I'm not very good at (but can
> > > > follow). Can you post an example? Does this use the OnOpen event?
> > > >
> > > >
> > > > "Klatuu" wrote:
> > > >
> > > > > Use the Data Mode argument of the OpenForm method and set it to acFormAdd.
> > > > > --
> > > > > Dave Hargis, Microsoft Access MVP
> > > > >
> > > > >
> > > > > "rpbsr" wrote:
> > > > >
> > > > > > I have a main form and a main form with subform. I would like these to open
> > > > > > ready to receive data, rather than populated with data from the first record.
> > > > > > I appreciate any help.
> > > > > >
> > > > > > Thanks,
> > > > > > Robert
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
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
Search
Profile
Private Messages
Log in/Register/Password
Office Other