Search results

  1. R

    Solved Grey bar at the bottom of form

    It is not the status bar... It is somethin on the form view level.
  2. R

    Solved Grey bar at the bottom of form

    Any Ideea where from comes that Grey Bar on the bottom of the from and how can I get rid of it?
  3. R

    Solved VBA Compact & Repair

    Clear!
  4. R

    Solved Unhide Navigation Pane on AutoExec

    it works like this Created a kind of Landing form, linked to settings table All the job is done in the On_Load event I also set a timer for 2 seconds, the closes the Landing and opens Main
  5. R

    Solved Unhide Navigation Pane on AutoExec

    I was thinking on that Not even in the Main Menu form, but in a blank form This may work The ideea is to prevent the user to mess with the "behind the scene" items
  6. R

    Solved Unhide Navigation Pane on AutoExec

    DoCmd SelectObject (Ass, , True) DoCmd.RunCommand StickFinger
  7. R

    Solved Unhide Navigation Pane on AutoExec

    How else can I do an AutoExec?
  8. R

    Solved Unhide Navigation Pane on AutoExec

    Enlightening! I was wayting for such an answer, indeed...
  9. R

    Solved Unhide Navigation Pane on AutoExec

    This thing it drives me crazy Really don't understand why they are not mirroring a command Ok... Now it works from Menu = True, NavPane = True But for Menu = false, NavPane = Flase Menu is Hidden (thanks God) but the Navigation Pane runs into error The crazyest thing is that I am using...
  10. R

    Solved Unhide Navigation Pane on AutoExec

    That's waht I am trying I created a function in a module and ttryed to Run it as Code in a Macro Fails to unhide Public Function ToggleMenuAndNavPane() As Boolean Dim showMenu As Boolean Dim showNavPane As Boolean showMenu = DLookup("Menu", "Settings") showNavPane =...
  11. R

    Solved VBA Compact & Repair

    I'm affraid that this is the answer.
  12. R

    Solved Unhide Navigation Pane on AutoExec

    Based on a table called "Setting", containing fields "Menu" and "NavPane" as boolean, I want to run an AutoExec macro to show or hide the Nenu and Navigation Pane, I am able to work with the Menu and also to Hide the navigation Pane Anything I tried so far to Unhide the Nav Pane (value set tu...
  13. R

    Solved VBA Compact & Repair

    What is that?
  14. R

    Solved VBA Compact & Repair

    Using Access 2019 Sub CompactAndRepairDB() Dim strDBName As String strDBName = CurrentDb.Name Application.CompactRepair strDBName, strDBName ' Delete the original database file Kill strDBName ' Rename the backup file to the original database name Name strDBName &...
  15. R

    Solved VBA Compact & Repair

    A limitation may be possible here, i guess. Tryed and failed few times. I fond some indications on net that the process may be prohibited, others are saying that it is possible... nothing worked
  16. R

    Solved VBA Compact & Repair

    The buildt in overwrites the current file, while creating a backup
  17. R

    Solved VBA Compact & Repair

    Trying to raplicate the whole behavior of C&R buildt in function
Back
Top Bottom