User Profile

Collapse

Profile Sidebar

Collapse
Russell G
Russell G
Last Activity: Mar 16 '07, 07:35 AM
Joined: Oct 19 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Russell G
    started a topic Running a timed Macro
    in Access

    Running a timed Macro

    Hi

    I have a number of queries that I have included in a macro. I wish to run this macro at a certian time, usually after hours. I have been playing around with the RUNMACRO command and the CONDITIONS of the Macro, but dont seem to be getting it right.

    What I am looking for is a way to start the macro at say 16:00 hrs but the queries must only be run say at 20:00 hours.

    Your help is appreciated.
    See more | Go to post
    • Russell G
      replied to Access Database on Laptops
      in Access
      Hi

      There is a Product call DATA ON THE RUN that you might want to look into. We have used it for exactly what you are describing. It does have some limitations but works well with simple databases.

      Goodluck
      See more | Go to post

        Leave a comment:

      • Russell G
        replied to Either Calendar in Outlook or Access
        in Access
        Hi

        Try this link...There are some extremely good ideas around Calendars and Access...and many other topics

        http://www.fontstuff.com/access/acctut09.htm...
        See more | Go to post

          Leave a comment:

        • Russell G
          replied to barkarlo
          in Access
          Hi

          I may be over simplfing your problem but why not use the standard DatePart function where the interval is set to "w". IE DatePart ("w", «date», ) and the date being the start date of the period worked. The output of the above will be a 1 if the day was a Sunday and then sum the time differances where the above output = 1 and group by staff member. See help files in Access for more explanations.
          ...
          See more | Go to post

            Leave a comment:

          • Russell G
            replied to The Function PI()
            in Access
            Hi,

            Thanks very much for the info RE PI()...I have decided just to use the value of 3.141592654 it was eaiser.
            See more | Go to post

              Leave a comment:

            • Russell G
              started a topic The Function PI()
              in Access

              The Function PI()

              Hi

              I need to use the function PI() in a qAccess query....Proble m I can not find a function called PI. The function exists in EXCEL. I can use 22/7 or 3.14159...but it would be much easier to use the standard function.

              Am I missing it or not looking in the correct Help menu?
              See more | Go to post
              • Russell G
                started a topic Opening a MsgBox in a form
                in Access

                Opening a MsgBox in a form

                Hi

                Please help..

                I have a form updating a table. When data is entered into a Combo box, I would like to use the BeforeUpdate or AfterUpdate (??) to verify if this information already exists in "another" table..not linked to the table the form is updating.

                If the above it true I want a MsgBox to display a warnig message. On cancelation of the MsgBox the data must still be accepted as vaild....
                See more | Go to post
                No activity results to display
                Show More
                Working...