Thank you Clive.
--- In MS_Access_Professionals@yahoogroups.com, "horastacatto" <zctek@...> wrote:
>
> Hi Peter,
>
> The two commands have different consequences.
>
> DoCmd.GoToRecord , , acNewRec
> will go to a new record and not affect records in the
> current session. Also the RecordCount will be
> incremented to include the new record.
>
> Me.DataEntry = True
> will go to a new record but will cause any prior
> records to disappear. The RecordCount will change to 1
> to include the new record.
>
> Regards, Clive.
>
> "Off-Group mail"
> >Hi Clive,
> >
> >Yes it was helpful.
> >
> >Question 1 was more asking if you are already in DataEntry Mode do >you prefer to add another record using the command
> >
> >Me.DataEntry = True
> > Or
> >Docmd.GotoNew Record.
> >
> >and which one is more effecient.
> >
> >Thanks for asking.
> >
> >Have a good day.
> >
> >Peter.
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "horastacatto" <zctek@> wrote:
> >
> > Hi jrweinwurm(Real name?),
> >
> > It is best to ask a single question at a time. You are
> > more likely to get a qquick response.
> >
> > So I will answer your first question.
> > "I find DataEntry mode a little mysterious and confusing"
> >
> > 1. When you open a form with 'Data Entry = Yes' you can view
> > records that are entered during the new session and none of
> > any previously saved records.
> > When you close the form, the session ends. If you reopen the
> > form, you will not be able to see the records that you entered
> > in any previous sessions.
> >
> > From what you say, this is just what you want.
> >
> > Hope that helps,
> >
> > Regards, Clive.
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "jrweinwurm" <jrweinwurm@> wrote:
> > >
> > > Dear Access Experts.
> > >
> > > I find DataEntry mode a little mysterious and confusing but I would like to use it as often as possible since no Records are fetched over the network when opening a form in this mode.
> > >
> > > Below are some questions I had about DataEntry mode.
> > >
> > >
> > > 1) If I am already in DataEntry Mode why does executing Me.DataEntry = True take me to a new Record? I also noticed it resets the filter and only shows the 1 new record.
> > >
> > > If already in DataEntry Mode do you prefer to use Goto NewRecord?
> > >
> > >
> > > 2) I opened my form in DataEntry mode using the following command.
> > >
> > > DoCmd.OpenForm "frmAnalyticals", , , , acFormAdd, , Me.cmbSubType
> > >
> > > I then later navigated to another record using the below code. Note the record was created in a completely different session a few days back.
> > >
> > > Me.Filter = "AnalyticalHeaderID = " & Me.cmbAnalyticalID
> > > Me.FilterOn = True
> > >
> > > After the execution of the above code I was suprised to see that Me.DataEntry is still True. How can this be?
> > >
> > > Is this an MS Access Bug?
> > >
> > > 3) Suppose my form is bound to a table with 100 records. If in DataEntry mode and then I execute DataEntry = False does Access fetch all 100 records. Based on my observations I think so. IT does a complete requery of the form correct?
> > >
> > > 4) In my current form, I am always navigating to one record using Filters to keep record fetches to a minimum and using DataEntry mode for new Records.
> > >
> > > For example:
> > >
> > > Me.Filter = "AnalyticalHeaderID = " & Me.cmbAnalyticalID
> > > Me.FilterOn = True
> > >
> > > I want to confirm that I am indeed minimizing network traffic with this coding style.
> > >
> > > I also want to confirm that the above technique works equally well if either using a JET backend or an SQL server backend with ODBC once I upsize.
> > >
> > > Thank you very much.
> > >
> >
>
Tidak ada komentar:
Posting Komentar