I have a continuous form, that is the parent form and child form all linked to separate tables on cloud database, this form is used for data entry and its property called date entry is marked as ‘YES’ as result once it opens you cannot see any exiting data its completely empty.
Symptoms:
Remember here I’m not editing anything, but adding new record which means that I will not be able to use WHERE CLAUSE which used in editing a specific record.
The attached database uses MS Access, and it is fast, that is the kind of speed missing when the same is linked to Cloud database.
Please advise with examples or show the filtering using the attached database, that way it will help me a lot to understand the concept. THIS PART IS REALLY CAUSING ME TROUBLE, ITS JUST A SMALL PART, BUT WHAT MAGIC IS REQUIRED HERE??????????????
Following are working super-fast no issues at all.
(1) Reports with over 8 million records works excellent
(2) Queries after converting to views excellent
(3) Action after converting to passthrough queries works fast
(4) Combo Boxes after using the code below works fast
Symptoms:
- The cursor moves from one filed to the next normally like it is in MS Access as long as there is no calculated control. At this point no problem, the same also happen with the subform.
- Problems areas, the switching from the parent form to the child form takes 45 seconds and the same happens in the subform when creating a new line, if you want to create 10 lines in the subform the cursor will take 450 seconds which is very bad.
Remember here I’m not editing anything, but adding new record which means that I will not be able to use WHERE CLAUSE which used in editing a specific record.
The attached database uses MS Access, and it is fast, that is the kind of speed missing when the same is linked to Cloud database.
Please advise with examples or show the filtering using the attached database, that way it will help me a lot to understand the concept. THIS PART IS REALLY CAUSING ME TROUBLE, ITS JUST A SMALL PART, BUT WHAT MAGIC IS REQUIRED HERE??????????????
Following are working super-fast no issues at all.
(1) Reports with over 8 million records works excellent
(2) Queries after converting to views excellent
(3) Action after converting to passthrough queries works fast
(4) Combo Boxes after using the code below works fast
Code:
Dim lngCount as Long
lngCount=cboBox.ListCount