Hi Sorwen, My database has 3 distict views ie Agents (main db), Leads and Projects.
Sub Test() Dim w1 As Workbook Dim w2 As Workbook Application.
I would appreciate if someone could give me guidance on how to circumvent the use of Select in this code Check which ports are open to the outside world.
Helps make sure that your firewall rules are working as intended.
Hi, I am building an app that uses around a hundred dynamic controls across 3 different views. It can become really time consuming and program intensive tp keep creating/destorying that many controls.
I am currently making the screen invisible, building the view and then making the screen visible which looks iffy. Resume code the screen shows each control appearing and the old control disappearing as if the Suspend and Resume was not there, it simply made no difference. Do Events in the code and nothing that would cause a screen update. If you still want to do it without tabs then my first thought is that instead it might be better to make a new Windows Control Library for each view and then just create/destroy an instace of each view.
Calculation = xl Calculation Manual Dim s Conn Params, s SQL As String Dim db File, db Path, db Name As String This Workbook. Select db File = "Counsellor Data.mdb" db Name = "Counsellor Data" db Path = Sheet3. Whereas previously the flickering caused by seeing the sheets as the code was working through has gone now it flickers between a blank excel sheet and my screen-saver. There were only 4 de-bugs - surprisingly few considering you had nothing to validate with I do appreciate the difficulty of your trying to this 'in the dark' and I would understand if you feel this is too constrained.If you decide to soldier on I have attached the code as it now looks with the debugs ironed out SCREEN-FLICKER-2Check which ports are open to the outside world.Microsoft is conducting an online survey to understand your opinion of the Technet Web site.