o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Automatically run Macro in Access database -

Hi,

I have an Access database named db1.mdb in my C:\ root that has a Macro named Macro1.

How would I get Windows 95 to automatically run Macro1 every hour using the System Agent? Would I need to create a batch file first and call that every hour? If so, what would the batch file look like?

Any help and examples would be appreciated..

Dan

 

Automatically run Macro in Access database -
Hi, I have an Access database named db1.mdb in my C:\ root that has a Macro named Macro1. How would I get Windows 95 to automatically run Macro1 every hour using the System Agent? Would I need to create a batch file first and call that every hour? If so, what would the batch fi

MS ACCESS - How can I get a Macro to Auto Run When Database Open + Closes -
Hello, Can anyone help ? I need to Automatically Run a macro when the database opens and Closes ??? Any Ideas ??

Macro startup! NEED HELP ASAP!!!! -
Hey. I need to know how to make it so the macro automatically starts when the excel document is pulled up. This is for a VB class and we're doing a mortgage program. I need to know how to get the macro to start automatically so it's more simplified (that's our goal, I guess). Thank

Access: AutoExec macro not running -
I'm trying to add an AutoExec macro to my Access project. I placed it in a standard module, but it is not running when I open the database. I tried defining it as a sub/function but still no luck. Also when I go Tools>Macro my only options are 1.VBE and 2. Run Macro I chose V

MS Access macro syntax -
I need to write an MS Access macro that compares consecutive records in an open database, and I am not sure what syntax I need to use in the macro. What is the MS Access macro syntax for: 1) referring to the current open database? 2) referring to a current record in the open datab

Macro in access and excel -
I have a macro in access set up that opens a query then transfers that data to a workbook in excel. From there, I have a macro that I wrote that will run in excel. How do I get the macro to run in excel as part of the step from my access macro? Rather than running my ma

AutoNew in Word template -
I've created a Word template with quite a bit of VB code built in to the AutoNew macro. It works pretty well, except that Word runs the macro before it finishes loading the document. Consequently, I can't access the last several pages of the document from my AutoNew VB code. Is th

Using Macro to fill in Parameter Query -
I have an MS Access query built that requires Month and Year to Run. I have set it up as a batch scheduling job to run each month on the first day of the month. I have already created a Macro to automatically run and download information into a spreadsheet and then send an email to t

Access, Objects and ODBC... -
Hello all, I have an Access '97 database that has a number of tables in it linked to SQL Server via ODBC (don't ask why - let's just say I'm trying to maintain someone else's crappy system!!) In Access, whenever you go to look in one of these linked tables it pops up the Connection d

Configure Macro Security Through Code -
How do I set the Macro Security to Low through VBA so that when the user confirms the first time that they accept the security warnings about vba script when launching an Access engine it automatically sets the Macro Security flag to low so they don't get asked again? Thanks

How can I run an Access Macro (need guru) -
OK, I've posted before about this: I need to create a patch to update an Access db by adding some new query objects, changing some data fields, etc. The best and easiest way I've found to do this is to build a Macro in Access directly, using the CopyObject and TransferDatabase comma

C/C++ executing an access macro using ADO DAO ODBC whatever... -
I have an existing MS ACCESS 2000 database, which uses a macro to update the records from 3 separate text files. This macro works perfectly. What I'd like to be able to do, is simply execute the macro from within my C++ code. The only alternative is to populate the db manua

Executing Access macro In VB6 -
Hi guys, I have an Access 2K database which has a macro that I need to execute from VB, I am using ADO to connect to my database. Can anybody tell me how to do such a thing. Any help will be greatly appreciated.

How to see macro code -
I got an Excel file that contains macro, if choosing 'enable macro' to open it, macro will begin to run automatically, launch a form window and minimize the Excel file (cannot maximize or restore it), which makes me not able to see the macro code in the Excel file. If I choose to 'd

Progress Bar running Access macro -
Hi all, I have a VB app that runs an MS Access macro in the background. The Access macro runs several queries. I want to show a progress bar on the VB form so that it shows how much longer it takes for the macro to be completed. How can I set the max setting? Please don't tell m

calling an excel macro from an access database that refers to that database -
hi i have a macro in excel that inserts some values into a table in a database in access, but i want to make it so i dont have to touch the excel file, instead i have a module in the access file that calls the sub in the excel file, but then i get an error saying that the database i

Word macro reading from an access database -
Help! I'm a VB6 programmer and have no idea about how to use vb within word. I want to write a macro that scans a word document for a phrase that matches an entry in an access database and automaticaly replaces it with another field in that database. Any help at all would be g

Calling Microsoft Access Module or Macro from VB -
I would like to call a Microsoft Access Module or Macro from a VB executable. This way I could schedule some database activity from my NT server. I do not know the commands to open an Access Database (with password protection) and us the DoCmd. Please Help!!

Automatically load a macro when a workbook opens -
Hi all, I've been trying to figure a way to run a macro everytime _ANY_ workbook is open. So I've tried these ways and they all fail: 1. Workbook_Open - This can be done only for a single workbook and I need the macro to be run on every workbook which is opened 2. Personal.xls - T

Converting Access Macro to VB -
Hi, I know this is stupid..but the Access 2000 help file doesn't give me a hint on where to find the converted Macro. In a design view, (after I create a report), I see that we can convert the Report Macro to VB (tool -> macro->convert Report's macro to visual basic. I rea

How to call a macro using VBA in Access2000 -
Hi All, I have a comand button on a form in an access 2000 database. Now using VBA I want to call a macro also residing in the same access database. Can anyone please help me with the correct syntax. Thanks

Executing MS Access macro from VB -
What is the easiest way to run an MS Access macro from VB6? I can connect to the MDB and query the tables and run queries, but I need to import 100000+ rows into a table. I created a macro that imports the data into a table and it runs fine. But how do I run this macro from VB6? Is

Outlook macro -
I have a macro in outlook which is activated when a new mail arrives (sub application_newmail). But sometimes i get two mails at the same time, and the macro works only for the latest email and the other one remains as it is. I need this macro to run for all unread mails in the inbox

running an Access 2000 macro via ASP -
Hi I have a MS Access 2000 database that contains a macro. When the macro is run it populates the database table with IP addresses currently in use on our network (the macro works). What I want to do is provide a webpage that connects to the database runs the macro and then from

How to use VBA to automatically update macro in another workbook -
Hi, I am currently writing some VBA script for excel, due to time constraint, I have to release the early version of utility to the users, all together there are more than 6 copies of them distributed out. Question, 1) For every change of new revision, I have to copy the l

Access macro -
I need a macro or vb code which automatically imports multiple csv files located in c:\output directory - & imports into two tables within access 2000. Currently my macro only selects one specific csv file - the csv file name is hard coded! I need to be able to read all csv file

AutoCAD and VBA question... -
Hi all. I need to execute a VBA macro at AutoCAD startup and I don't know where to specifiy to my AutoCAD which macro to use. For example, lets say I wrote a macro that writes the date on a specific area of the drawing. Now what if I want for that macro to be executed automatica

How to add the macro automatically in outlook 2000 -
I have made a macro in outlook 2000 that will filter the emails and send a specific email (according to the subject) to a folder in the hard disk, and it works fine. what I need is how to make a program that will (install) or add this macro to the outlook 2000 automatically without

Database security -
Hi - I am currently working on an ActiveX control (my first one so I am having a ball with it, let me tell you). The goal of the control is to detect if a database has been accessed by anyone using another program. I have a macro set in Access that will tell me if someone uses Acce

How do I run a macro automatically once excel opens -
Hi guys, I am currently extracting data to a spreadsheet from my VB app. However, once a user extracts the data successfully and Excel opens I want to run a macro without them having to click on Tools-->Macro-->Macro-->Run. How do I do this. Someone please help. It's qui

macro from Vb -
Hello all I have created a macro in the Access database, Can I call it from a VB program? thanks

Run Access Macro or Function from VB -
Does anyone know how to run a Macro (or Function) in an Access database from VB? I cannot find any DAO Object that has a method to do this. Is ADO the answer? Thanx in advance for your help.

On database open -
THis sounds simple enough, but I can't figure it out for the life of me. I have a function and a macro in Access which does exactly what it is supposed to do. What I want to do is run the function and macro as soon as the database opens. I don't want to put it in a form load because

help needed in Macros -
I am generating Microsoft project Plan using some java helper classes. I have a macro written which needs to be embedded in the MPP but the problem is that i want to save this macro in some format on my client system and as soon as i open the MPP, this macro gets attached to the MPP

Printing a report via DAO -
How do I print a report in a Access database thru DAO? Do I have to make a macro in Access and then run the macro from vb?? How is this done?? /Smirre

Importing text file into Access database using Excel macro -
Hi, I want to creat an Access Database and import text file in to the database using Macro in Excel. Please let me know whether it is possible or not. Thanks & Regards, Manohar.

connect Macro(VB) to Sql Server -
Can any body pls. help me..here's my problem. I have a excel file with macro in it(i used VB6 editor to make/edit Macro) and i want my macro to retrive some data from my Sql database. My question is, how will i connect my macro to my Microsoft SQL server (Version 8)? any inputs will be

Publisher 2002 - macro to resize graphics -
This question is actually for a co-worker. She wants a macro in Publisher that will automatically resize all the graphics in her file. Unfortunately, Publisher doesn't have a Record Macro option, and I've never used publisher in my life, don't even have it installed. Any ideas what ki

Search Access DBASE from inside of it .. =/ -
Well I need to do this, there is an acess database I have, I need to search for 2 specific fields from it by using a macro that automatically starts up when the dbase is loaded, sorry for my ignorance, never done antyhing like this.

Calling other Applications and Macros from Excel -
Howdy! I am trying to figure out how to open an access program, then run a specified macro in the access program then close it again. all from an EXCEL macro. Also, how to call another excel macro from an excel macro. Call Outlook from excel and have it run a macro in outlook