Search results

  1. P

    Slow Loading Tab Control

    Working great now... don't know what was going on.
  2. P

    Slow Loading Tab Control

    I tried searching for posts by him regarding WAN but no matches.
  3. P

    Trying to implement the SetAccessWindow code

    It seemed to speed up dramatically once I put in your showminimized coding but after the work you did it got slower than before. However I believe it is related to the network. I outlined in my other post in the Forms forum what I think I discovered...
  4. P

    Slow Loading Tab Control

    I do however revert back to my original question due to noticing that right now the main form loads fast but the forms on the tabs that have the comboboxes are slow to load once the tab is clicked. Is there some way that those queries are causing the slow loading with the inner joins and whatnot?
  5. P

    Slow Loading Tab Control

    So it turns out that not all containers were empty. The reason why... Due to the code I posted to delay loading the forms and the not posted code that was determining what user groups saw what tabs... I had a couple of forms in their containers. The reason why... The code to delay loading the...
  6. P

    Trying to implement the SetAccessWindow code

    Yea... when I use the local tables it is lightening fast for me too... it happens when linking tot he backend on a network drive many states away from me (and all other uses as well unless they are in the same state as the backend). and that is where I get frustrated because while the...
  7. P

    Trying to implement the SetAccessWindow code

    Yea the hourglass does not work on mine due tot he access application basically not responding and therefore the hourglass does not appear. I really don't know what to do.... this thing opens so slow now it is frustrating. and today... 9 out of 10 times the app window won't minimize anymore. I...
  8. P

    Slow Loading Tab Control

    Correct. Any Ideas why it loads so slow then? What more info would be needed to make an educated guess?
  9. P

    Slow Loading Tab Control

    Through the great help by many here the re-write of my database is complete and fully functional. However I really need to re-address the seriously slow loading of my main form (frm_home) after changing to tab control from navigation control. This was dealt with briefly in another thread but...
  10. P

    Trying to implement the SetAccessWindow code

    I can deal with that... I really liked the no borders part but this accomplishes what I was looking for in the end. Colin... again... thank you so much for your valuable time spent on this for me. Thank you for catching that. Strangely enough that problem went away. I did however have to...
  11. P

    Trying to implement the SetAccessWindow code

    Yea... I only tried it to see if it had any effect. Thank you again so much for your time on this. I will try to figure out the report issue.
  12. P

    Trying to implement the SetAccessWindow code

    Colin I cannot thank you enough for the time you spent digging through my code. Maybe there is a difference between Access 2016 (yours) and 2013 (mine) because the registration form and lost password form still opened with the database window maximized behind them. They are both defaulting to...
  13. P

    Trying to implement the SetAccessWindow code

    Here it is. Login with user2, user2 for admin. The forms in question are frm_registrationform and frm_passchange. I have not tried any code on frm_passchange yet as I was trying to get frm_registrationform working first. Ignore the filename of the db... that was me being a smart-alec to myself
  14. P

    Trying to implement the SetAccessWindow code

    to be honest I do not know what I can remove and what I cannot. Let me work on making the tables local and strip out the data and I will upload the database.
  15. P

    Trying to implement the SetAccessWindow code

    I know I am missing something but I just do not know what
  16. P

    Trying to implement the SetAccessWindow code

    I reviewed you code like you said and I copied the code from frmFormQuery on open and on load events into my frm_registrationform which now looks like this: Option Compare Database Option Explicit Private blnGood As Boolean Private Sub Form_Load() On Error GoTo Err_Handler...
  17. P

    Trying to implement the SetAccessWindow code

    I tried that before posting about it. I added Option Compare Database Option Explicit Private blnGood As Boolean Dim blnShowWindow As Boolean Private Sub Form_Load() SetAccessWindow (SW_SHOWMINIMIZED) End Sub in the module for the frm_registrationform but it didn't stop the access app from...
  18. P

    Trying to implement the SetAccessWindow code

    So... to elaborate on my last question above... here is a screenshot of the login form (frm_loginform) The circled label links are the ones I am talking about. Just talking about the register as new user label link. I have an embedded macro for that one. When I click on it the database...
  19. P

    Export to Excel not working after SetAccessWindow code

    Very strange... I started over and copied all queries, forms, reports from the one that was not working into the new one and everything works. Makes no sense. One downfall though... it is back to opening slowly again. Whatever is different (which there can't be) is making it slow again. I...
  20. P

    Export to Excel not working after SetAccessWindow code

    Yea... I was just trying that and after commenting it out the export still didn't work. I went a step further and commented out the code for the tab change that was worked on in the other thread and the export still doesn't work anymore. I wonder what happened. Gonna take some more digging I...
Back
Top Bottom