Running A Query / Macro Through Scheduled Task?

Aug 25, 2012

I have a MS Access append query that updates a table from a linked Excel spreadsheet. Im trying to automate the running of the query during the night.

Ive tried a couple of ways to schedule the task with Windows Task Scheduler, although each time, it appears to start the job, but then just hang (task never completes, doesnt run the query or macro and when I log back into Windows, the msaccess.exe process is running).

Methods Ive used are:

- command line with /x macroname

- vbs script which runs the query / macro

Code:
'Read from a Microsoft ACCESS database
Option Explicit
dim oaccess
'execute another Access macro
set oaccess = createobject("access.application")
oaccess.opencurrentdatabase "H:Database.mdb"
oaccess.docmd.setwarnings false
oaccess.DoCmd.RunMacro "Macro1"
oaccess.docmd.setwarnings true
oaccess.closecurrentdatabase
oaccess.quit
set oaccess=nothing
WScript.Quit(0)

- .bat file which just has the command line in it.They all run fine when I am logged in, although it seems to hang when I am logged off the network. I have the correct permissions as Ive scheduled a Excel macro to run and its fine.

View Replies


ADVERTISEMENT

Modules & VBA :: Scheduled Task - Run Macro To Send Report Out?

Feb 3, 2014

I have a report that I run manually from my computer every day.

This report is created by a macro in microsoft access, then it runs a VBA macro to send it out..

Is there a way that I can add this as a scheduled task since I usually forget to send it out?

View 3 Replies View Related

Program Windows Scheduled Task

Aug 23, 2007

Hi All,

Does anyone one if it is possible to program a schedule for "Windows Scheduled Task" via VBA?

Reason:- A multi user application is set to give a 5 Min warning at the same time every day. After the 5min the users are politely kicked off.

At that time the Windows Scheduled task opens up the BE (only on 1 PC the fastest). The BE start form has a time event that backs up the BE and compacts and repairs itself then closes the application.

Not pretty I know but it works really well.

This shutdown time can be set/changed on the FE however, when it is the windows Scheduled Task has to also be changed which I would like to do automatically via VBA

Any help would be appreciated.

View 1 Replies View Related

Modules & VBA :: Scheduled Task On Windows Server

Apr 20, 2015

I have a vbs-script that opens my access database db.mdb and runs the module "Export":

dim accessApp
set accessApp = createObject("Access.Application")
accessApp.OpenCurrentDataBase("D:Datadb.mdb")
accessApp.Run "Export"

accessApp.Quit
set accessApp = nothing

This works fine as a scheduled task on a Windows 7 computer.

Is there a way to make this work on a Windows Server 2008 R2 ? When I double click the vbs-file, the file opens instead of runs. And when I create a scheduled task, nothings happens.

View 2 Replies View Related

General :: Scheduled Task To Import Daily CSV Exports?

May 18, 2015

We have small data dumps from a webservice delivered to us daily in csv format. I'd like to create a system where we can have the data automatically imported into either Access.

My idea is this:

1. CSV is downloaded to <x> folder.

2. Scheduled Task runs script to look in folder <x>

3. If CSV is found in folder <x>, import it's data into a fixed Access db->table.

4. Move CSV to an archive folder to avoid re-processing.

Is this feasible? How complicated would it be, and how to get it on track?

View 1 Replies View Related

General :: Task Scheduler To Run Macro?

Mar 19, 2014

Just got a new Windows 7 computer and installed Office 2013. I have a report that saves itself as a pdf in a temp folder and then attaches the pdf to an email and sends it out. I use a macro to run the report and everything works fine from there. I have a VBS file that runs the macro and clicking the vbs file makes everything work fine. the code is below.

When I tried to run it though the task scheduler it show as completing fine, but it doesn't. So I added a reference the vbs in a batch file (below) and output the logs to a temp file. After I ran the batch and opened the log I seen the message

Wed 03/19/2014 14:11:17.74 Username
C:Users*****DesktopAuto Reportsaragingrecent.vbs(1, 1) Microsoft VBScript runtime error: Permission denied: 'CreateObject'
Wed 03/19/2014 14:11:17.77

I turned UAC all the way down. turn off the virus scanner, and have local and domain admin access. I'm at bit a lose here. I had this working before but can't seem to remember how I did it. This is just one example I have several other reports that were schedule to run overnight, but they basically all use the same code and processes.

Code:
'launch macro
set accessApp = CreateObject("Access.Application")
accessApp.OpenCurrentDatabase "C:Users******DesktopAuto ReportsAgedTrialBalance.mdb"
accessApp.DoCmd.RunMacro "MCRecent"

[Code] ....

View 2 Replies View Related

Queries :: Pop Up Messages When Running Update Query / Macro

Jan 1, 2015

I have 3 different "buttons" on my form that run individual update queries. I know these update queries are running correctly. Decided to make a macro that will allow me to run all these queries by clicking one macro button.

My question is: Is there some way to stop the pop up msg that advises I am about to run an update query and the next pop up msg that informs me of how many rows I am going to update?

These pop up boxes are starting to drive me crazy when I run the macro.

View 5 Replies View Related

Windows Task Scheduler, Access Is Left Running

Jan 25, 2008

Hi,
WHen I used Windows task scheduler to start my application, and then close the application normally, the application closes but Access is left running, still visible in the task bar. The only way I can get it to close is by using task manager to kill it. I found an old KB article ( # 246953) that hints that this (or something like it) is a known bug in Access 2000 but supposedly was resolved by an Office 2000 service pack 2. But I am already running Windows XP, SP2. Anyone else having this problem? Any workarounds?

View 1 Replies View Related

Running Queries Using A Macro

Mar 11, 2008

Hi,

Can I use a macro to run multiple queries in sequence?

I searched on this but did not see anything that indicated how to do this.

Any pointers would be appreciated!

Thanks,

Mark

View 1 Replies View Related

Is There A Way To Know What Queries In A Macro Are Running?

May 16, 2006

I've got a Macro that runs well over 100 queries as well as sub-macros. I'd like to know what query the Macro is running. My best solution so far was to create a bunch of forms that open and close with the name of each query, but that's kind of sloppy. I don't think I can use the msgbox because it prompts me to press 'OK' to continue. Any thoughts?

View 2 Replies View Related

Running An Excel Macro From Access

Jun 14, 2004

Hi all,

I was hoping that someone could tell me if it is possible to run an Excel macro from an Access database. I am importing 3 Excel worksheets into Access and this macro needs to be run on all 3 evertime that this file is imported by the user (twice a week). If this can be done could someone please tell me how ??

View 14 Replies View Related

Macro Running Module Failure

Nov 15, 2006

hey there,
i have a macro that has 2 actions:

set warnings to warning on: NO
and
runCode to Function Name: cmdImport_Click()

where cmdImport_Click() is a Private Sub in a module within the same database.

when i try to run the macro i get an error that stated
"the expression you entered has a function name that MS Access can't find."

but if i open the module called ImportMSExcelFile and set my cursor on the Private Sub cmdImport_Click() and select the green arrow to run the procedure it runs fine.

any suggetions?

tuktuk

View 2 Replies View Related

Modules & VBA :: Running A Macro From Another Form

Jan 31, 2014

I have 2 forms and a macro in Form1 which runs throught every record to update the records, however.I would like to run this macro from the main form (Form2)

I have tried
docmd.openform "Form1"
Run Macro

but it doesnt work

View 4 Replies View Related

Modules & VBA :: Can Manually Stop Auto-Exec Macro From Running By Holding Down Shift Button

Dec 22, 2014

I can manually stop the AutoExec macro from running by holding down the shift button - how do you do it by VBA? I'm opening the db from Excel, and I don't want the Switchboard to display ...

View 1 Replies View Related

Queries :: Automate Outlook Task To Export Common Query Every Day

Jun 29, 2013

I've created an outlook task to export a common query I do every day, is there a way to automate it so it will happen automatically without me pressing Run?

I use office 2007 on a company laptop with tight network restrictions (so no Windows Task Scheduler)..

View 1 Replies View Related

Scheduled Shutdown Of Dbase

Jan 24, 2007

Hi,

I've searched the forum for a sample code on how to automatically shutdown database at a given time of the day, but i can't find any. There are lots of codes pertaining to inactivity / idle users but none on scheduled time.

My idea is to kick-off all users every 12:00nn, Monday to Saturday and then compact / backup database after.

I hope someone could assist me.

Thank you!


Sheila

View 1 Replies View Related

General :: Automated Task - Send Email Address To All Emails In Query

Sep 30, 2013

I want to automate a task in access....

I have a query that may have 6 - 7 different records for example each record contains a different email address, i need to get the first email then send and email to that address then go to the next record get that email address send an email to that email address until its gone through all the records...

I use this code to send an email, dont know how to loop through records and get the email...

Code:
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Dim strPath As String
Dim strFileName As String
Set appOutLook = CreateObject("Outlook.Application")

[Code] .....

View 1 Replies View Related

Queries :: Find Records Not Scheduled / Complete

Jun 4, 2013

I have a database for training. I have a table of employees with one of the criteria being active which is enabled by a check box. I have a second table of all of the training data. When I add a new employee, or I want to schedule someone, I want to be able to have a combobox on a form which I can select the type of training and then with a push of a button find if there is an active employee which has not had this training through results of a query.

View 14 Replies View Related

Modules & VBA :: Launch Access From Scheduled Tasks Without Interactive Login?

Sep 5, 2013

I have been searching the web for a solution to this problem. I have created a scheduled task on Windows 7 to automatically run a macro from a command line, however, it seems to only run when the user is logged onto the machine. Is there a way to run Access without the interactive logon? I would rather not leave the machine logged in with this account, but if that is the only solution, so be it.

View 7 Replies View Related

Modules & VBA :: Calendar Form - Allow Multiple Appointments Scheduled For Same Time

Mar 4, 2015

I am making a calendar form in Access and want it to look like Google Calendar as much as possible. I am wondering if there is a good way to go about setting up the form to allow for multiple appointments scheduled for the same time. Designing the form to be in Week View with half hour blocks has me at 210 text boxes. As far as I can tell, there isn't a way to dynamically add in controls unless you are in design view. However, how many appointments might be scheduled at the same time. I could add in as many text boxes as possible I guess, but that doesn't seem to be very efficient (and the base form is already at 210). Is there anyway to add in controls (such as text box or label) if a new appointment is added at the same time as existing ones?

View 5 Replies View Related

Modules & VBA :: Write A More Complex Macro That Will Start Another Macro At Preset Time

Dec 8, 2013

I am trying to write a more complex macro that will start another macro at a preset time, however I am getting stopped at the first hurdle - getting a macro to run another macro.

Here is the code i am using at the moment, all I want to do currently is click the first button, then get the second macro to execute. But no luck, getting error 2157 "cannot find the procedure"

Code:
Private Sub Command3_Click()
MsgBox "1st macro running", vbExclamation, "Note"
Application.Run "teststart1"
' Application.OnTime TimeValue("19:55:00"), "teststart1"

[code]....

View 1 Replies View Related

Running Balance As Opposed To Running Total

Mar 14, 2005

Can anyone tell me how to get a running balance on a report. I know how to create a running total, by setting the "running sum" property of a text box to "Over all".

I can't however see how I can adapt this to give a running balance (as in a bank statement for example). Attempts to do so end up in failure!!

Many thanks in advance.
Peter

View 2 Replies View Related

Form .. Query.... Macro...

Feb 18, 2005

Not sure where to put this one... So I'll go with forms...
I have a form "Reports Dialog" with 3 radio buttons to pick which report you want to preview and/or print. It works fine. Now what I want to do is add a subform"Select", visable only when the radio button is clicked on. This holds the parameters for the query for the item whose radio button you picked. So I set the subform visable to "NO"
Whats the best way to make it visable when the radio button is clicked? Can I do it in a Macro? Or is it better to put a line of VB in..... And I'm not good with VB yet....... So if that is it what would the code be.
Thanks

View 2 Replies View Related

Form, Query Or Macro?

Oct 7, 2004

How can I make a query or maybe its a macro that can
fill up a form after I enter some information, like the customer
id (i.e. social security). However, if its a new one, than I want
to be able to enter the new information for that new customer.
I really need this guys, can someone help me here?
Thanks,
Enivaldo

View 1 Replies View Related

Parameter Query In A Macro

Aug 22, 2006

I have a button in a Form which on being clicked runs a Macro containing the action of opening a parameter query. When this Macro is run, the optition to enter data into the parameter query is shown and providing a user enters valid data, there is no problem.

However, if the user cancels the action at this point (by clicking the Cancel button etc.), he is shown an "Action Failed" box with the optition to "Halt".

Whilst this does work, I imagine there is a more elelgant solution for catching & dealing with a "cancelled by user" response.

Any advice on how would be most welcome.

Colin

View 2 Replies View Related

Running Sum In Query Possible?

Sep 16, 2005

Hi!

Sorry I am to bother you. But I was wondering whether it is possible to create a running sum in a query (from each previous record just a simple add up)?

I know how to do in report (it is described in the help function) but for a query I cannot find anything.

Thx and rgds,
Lobhaan

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved