User Profile

Collapse

Profile Sidebar

Collapse
jzalar
jzalar
Last Activity: Nov 20 '08, 09:05 PM
Joined: Sep 26 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jzalar
    started a topic Dlookup from a Query
    in Access

    Dlookup from a Query

    I am using Access 97 (No choice) and I trying to get the VBA to do this.

    1. Open a query "X-Misses-1"
    2. Pull the value from the field "total misses"
    3. Use that value in a loop to run an append query that # of times.

    Here is where I am, and I am stuck on

    Code:
        Dim stDocName As String
    Dim Temp As Integer
    Dim Count As Integer
    ...
    See more | Go to post
    • jzalar
      started a topic Making Access 97 open Excell 97 when opening OLE objects
      in Access

      Making Access 97 open Excell 97 when opening OLE objects

      I have Access 2007, Excel 2007, Access 97 and Excel 97 running on my Windows XP computer. When I try to open up a Pivot Form in Access 97, Excel 2007 Opens. I can not figure how to make Excel 97 Open when I open any OLE object in Access 97. Any Ideas.
      See more | Go to post
      • jzalar
        replied to Access 2007 Data Collection Error
        in Access
        Thank you for the suggestion. I am sorry to say it did not work. I also tried deleting the Search Folder that is created when this Add-in is installed. I know the addin is first installed when the data collection Wizard is initally ran. That wizard doesn't run after it is ran the first time. Is there a way to force MS Access to rerun a Wizard.
        See more | Go to post

          Leave a comment:

        • jzalar
          started a topic Access 2007 Data Collection Error
          in Access

          Access 2007 Data Collection Error

          I recently installed office 2007 just to make my life more difficult. I started to use the Email Forms for data collection last week. Started up my computer yesterday and I could no longer use the feature. I get the error message " The Microsfot Office Access Outlook add-in is disabled...." I tried everything I could think of to get the Accolk.dll file to load into Outlook but failured. Has anyone seen this or have any idea how to...
          See more | Go to post
          • jzalar
            replied to Auto Syncing Replicas
            in Access
            Sorry for the delay but I had to go to Ny for work and this wasn't part of that work. I tried it today but I can get it to run. I am not very good with VB so I keep getting complier error when debuging. This is what I used.

            Code:
             Dim MyDB As DAO.Database
Dim rstReplicas As DAO.Recordset

Set MyDB = CurrentDb()

Set rstReplicas = MyDB.OpenRecordset("tblReplicas", dbOpenForwardOnly)
            ...
            See more | Go to post

              Leave a comment:

            • jzalar
              replied to Auto Syncing Replicas
              in Access
              Will be trying it today. Thank you for the help.
              See more | Go to post

                Leave a comment:

              • jzalar
                replied to Auto Syncing Replicas
                in Access
                Sorry about the confusion. I am looking for "Replicatio n Code" that I can put into a macro that will run the sync procedure out of sight of the user. The only thing I found was from the Microsoft website http://support.microsoft.com/kb/183710/en-us

                This is kind of what I need, but an actual working same so I can change the BD names and paths....
                See more | Go to post

                  Leave a comment:

                • jzalar
                  replied to Auto Syncing Replicas
                  in Access
                  I would like to have a button on the master that automatically (without pop up and choices) syncs all of the replicas to the master....
                  See more | Go to post

                    Leave a comment:

                  • jzalar
                    started a topic Auto Syncing Replicas
                    in Access

                    Auto Syncing Replicas

                    We are lucky and get to run an 11 year old version of Access (97). I have set up a master with 5 replicas. These are located on various network drives in our organization. Is there any macro/code I can use to have the master auto sync each of the replicas when opened? the Microsoft website sucks and didn't help me at all. I would love any advice or help.
                    See more | Go to post
                    No activity results to display
                    Show More
                    Working...