User Profile

Collapse

Profile Sidebar

Collapse
AI Man
AI Man
Last Activity: Apr 9 '07, 03:46 PM
Joined: Apr 4 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • AI Man
    replied to Call Macro from closed Data Base
    in Access
    The last post has some minor items to clarify. Here is the same data with more clarification. Specifically clarifing how to use the path ways.

    'Create a second Access session
    Public Sub OpenAccess()
    Dim appAccess As New Access.Applicat ion
    Set appAccess = Access.Applicat ion
    appAccess.OpenC urrentDatabase "\\Path to folder holding Database\Databa se name.mdb"

    appAccess.DoCmd .RunMacro...
    See more | Go to post

      Leave a comment:

    • AI Man
      replied to Call Macro from closed Data Base
      in Access
      This is a listing of some of my coding. Hope it helps people.

      'Create a second Access session
      Public Sub OpenAccess()
      Dim appAccess As New Access.Applicat ion
      Set appAccess = Access.Applicat ion
      appAccess.OpenC urrentDatabase "\\Foldername\D atabasename.mdb "

      appAccess.DoCmd .RunMacro "Macro Name", , ""
      ' Can't remember exact wording for the above line of code....
      See more | Go to post

        Leave a comment:

      • AI Man
        replied to what is VBA
        in Visual Basic
        VBA (Visual Basic For Applications) is a rather simple computer language Microsoft developed. Its original purpose was to allow users of Windows applications to create more advanced applications. This in turn snowballed into a language that is widely used and very flexible.

        For example, using VBA - or VB if you prefer - I can run an Access program that opens Excel spreadsheets, runs Excel macros or saves data in Word, Excel, Access...
        See more | Go to post

          Leave a comment:

        • AI Man
          replied to Animating a Picture
          in Visual Basic
          Here are some ways to time things out in VB.

          In this instance the program will not run until after 7 AM.

          Do
          If Time > #7:00:00 AM# Then
          MsgBox ("Time is " & Time)
          Exit Do
          End If
          Loop


          This one simply delays a process for a set amount of time. This example would delay the process for 1 asecond. I am pulling it off the top of...
          See more | Go to post

            Leave a comment:

          • AI Man
            started a topic Call Macro from closed Data Base
            in Access

            Call Macro from closed Data Base

            Greetings,

            I have been searching the web and Access relentlessly trying to find a way to call an Access macro from a different Access data base.

            Example - The form button gets clicked and the first macro executes. Then a second macro is selected from a closed data base so that the query in the second database can run. Alternatively open the second data base and call the macro.

            In other words I need to...
            See more | Go to post
            No activity results to display
            Show More
            Working...