Greetings!
I use an Access Data Project with a SQL Server backend. I have 50 users total, speed is a necessity. I'm working on a retrofit for this database that will incorporate form meta data into a separate portion of the application so that admins can make minute changes to control properties on the fly (Enabled, Locked, BorderColor etc..). I've designed and populated several tables with information regarding these properties, and I use a hidden form that is hooked up to the view for this information for the individual forms to read from in the On Load event to apply the changes to control properties. Currently I have a function that loosely goes like this...
Form!frmPermissionsConfiguration.Form.Filter = "Control_ID = " & ControlID
Form!frmPermissionsConfiguration.Form.FilterOn = True
Then I can simply read from the required fields using:
Form!frmPermissionsConfiguration!ChkEnabled or something similar depending on the form.
My issue is that as the configuration tables grow, the load time of forms is increasing. I ran a SQL Server Trace and discovered that every Form.FilterOn = True call causes the form to be refreshed. So my question is...
Is there anyway to simply read control values from a hidden form if you have the Primary Key without causing a form refresh?
I use an Access Data Project with a SQL Server backend. I have 50 users total, speed is a necessity. I'm working on a retrofit for this database that will incorporate form meta data into a separate portion of the application so that admins can make minute changes to control properties on the fly (Enabled, Locked, BorderColor etc..). I've designed and populated several tables with information regarding these properties, and I use a hidden form that is hooked up to the view for this information for the individual forms to read from in the On Load event to apply the changes to control properties. Currently I have a function that loosely goes like this...
Form!frmPermissionsConfiguration.Form.Filter = "Control_ID = " & ControlID
Form!frmPermissionsConfiguration.Form.FilterOn = True
Then I can simply read from the required fields using:
Form!frmPermissionsConfiguration!ChkEnabled or something similar depending on the form.
My issue is that as the configuration tables grow, the load time of forms is increasing. I ran a SQL Server Trace and discovered that every Form.FilterOn = True call causes the form to be refreshed. So my question is...
Is there anyway to simply read control values from a hidden form if you have the Primary Key without causing a form refresh?
