User Profile

Collapse

Profile Sidebar

Collapse
hilmi123
hilmi123
Last Activity: Jul 7 '21, 10:57 PM
Joined: Jun 28 '21
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • hilmi123
    replied to browseto nightmare
    in Access
    Hi NeoPa,

    Thanks for trying, but I dont think you understand.

    In reality this is a very simple situation.

    The code to change the form in navigationsubfo rm works in some situations and not others. The factor that makes it not work is the code that is running before the BrowseTo cmd.

    Eg if there is a dialogue box in my case.

    So this works

    Code:
    DoCmd.BrowseTo ObjectType:=acBrowseToForm,
    ...
    See more | Go to post

      Leave a comment:

    • hilmi123
      replied to browseto nightmare
      in Access
      isladogs,

      I have a navigation set up with buttons on the left side.

      The "main menu" is always open, and the changeable subform is "NavigationSubf orm".

      So for example lets imagine I am on form x and I want to go back to the "home" form for the NavigationSubfo rm, I would use a browseto command to change the form loaded in the NavigationSubfo rm.

      The problem is,...
      See more | Go to post

        Leave a comment:

      • hilmi123
        replied to MS Access to SQL server connection string
        in Access
        Can you share your execution of the sql statement?

        For access front and sql be, you need to change your code for execution for delete, update and insert to "dbSeeChang es"

        Eg

        Code:
        CurrentDb.Execute sql, dbSeeChanges
        See more | Go to post

          Leave a comment:

        • hilmi123
          replied to browseto nightmare
          in Access
          Hi NeoPa,

          Let me try to explain further.

          "let me start by pointing out that 6054 is an error code. With an error code you will always have the message that code represents, which makes the error make sense to anyone trying to help. That makes life easy, which is why it's always provided."

          The error code I have uploaded an image to illustrate, it suggests the path to the browsed form is incorrect....
          See more | Go to post

            Leave a comment:

          • hilmi123
            started a topic browseto nightmare
            in Access

            browseto nightmare

            Hi all,

            First post, but long time browser.

            I have been using browseto over the years with mostly a good outcome, however I have now encountered some strange behaviour.

            I have a button which onclick changes to a different form. I can make this work fine, however on the onclick before the browseto command I have some vba code to check that all data on the form is correct before moving on.

            ...
            See more | Go to post
            Last edited by NeoPa; Jun 29 '21, 01:24 AM. Reason: Added mandatory [CODE] tags.
            No activity results to display
            Show More
            Working...