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