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