Visual Basic :: Startup Macro In Access

Run A Macro At Startup Of Word
Hi everybody,

does anyone know how to run a macro when word starts?
The macro is in a global template, which is stored in the startup path of word.

The backround: On installation of the global.dot, I write a version string to an ini-file. On another ini-file the version string of the actual version of the global.dot is stored. If the both version strings are not equal, I want a messagebox to appear, telling the user about the update.

Everything works fine so far, but I had no success in running a macro at the startup of word.

Every idea is welcome. Thanks.

_____
viebas

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). Thanks for any help.

Loading Excel Macro At Startup
I've recorded a macro which formats numbers in a custom format. I want to assign the macro to a button placed on the toolbar (which I know how to do). I don't know where to store the macro code though, such that the macro is available at start up. I'm not sure if there's a startup template similar to the one in Word and on which every new word document is based, (Normal.dot). In any case, this wouldn't be desirable as the macro would get loaded into memory each time a new worksheet was opened. I also tried packaging the macro into an Add-In and including it in Tools/Add-Ins, but this doesn't work either. I also thought of putting it into a spreadsheet which is loaded automatically when Excel is opened, and which could be hidden. This isn't desirable either, though. I feel sure there must be a better solution. Any ideas?

A second question, I'd like to disable the macro button when there's no spreadsheet open. How can I do that?

Macro To Execture Automatically At Startup?
Hi,

Is there a way to get a macro to exectute at the moment an Excel spreadsheet is loaded?

Cheers,

Rob.

Edit by Moderator:
Please post Excel questions, in the Excel forum.

Thank you.

How Do I Fire A VB Macro For Word's Default Startup Document?
Hello All,

My goal is to force users of word to place a security classification on each new document in a header. I have written a routine to do this and it works fine on any new document.

In Normal-Microsoft Word Objects-This Document I have the following code:

Public Sub Document_New()
Application.Run MacroName:="add_header"
End Sub

The add_header macro is in a module in the same path, as a form used by the macro.

When the user starts word, the default document does not fire my procedure; and I certainly understand why. When 'new document' is selected, it fires correctly and works well.

Is there a way to have the default doc on startup run the procedure? If I put my macro call in an autoexec proceure, it fires, but fails because it runs before Word throws a new document..

Any help would be greatly appreciated!

Thanks,
Daniel Sefton
seftonde@myeastern.com

Can You Get An Access Macro To Include Running An XL Macro
Is it possible to have an MS access run its own "thing" and in the middle of it all call on excel to run it owns macro?

Possible To Launch A UserForm In Excel From Startup Macro Without Showing Excel?
Greetings to all VBA/Excel Excperts!

I have a project at work that is requiring me to utilize Excel/VBA (something I'm not super-conversant in) and I am wondering if it is possible to have a UserForm be the first thing that pops up when you launch (i.e. double click on) a spreadsheet (likely an .xlt but not necessarily)? I know I can have an Autostart Macro (or something of that ilk) that could launch the form, but I am hoping there is a way to do this so that it just looks like I launched the UserForm and am not firing up the entire Excel program.

As soon as the functionality encapsulated in the UserForm is completed it will shut down Excel, which is why I'd rather just have the form and nothing else.

My reason for doing this is to make deployment of this "application" simple - just drop the spreadsheet onto the target system (which of course must have Excel 2003 installed, which all of our company systems do) and double click. Saves having to create an install package for a plain ole VB app.

Thanks for any suggestions and/or taunts you may have!

Run Access Macro From Excel Macro
Hi

I am using Microsoft Office 2000 and trying to run an Access macro from an Excel macro, but my Excel macro does not seem to be working. When I run the Excel macro, nothing happens - I do not get an error and the code does not do what it is suppossed to. Below is my code:

Code:
Sub DisplayForm()
' Initialize string to database path.
Const strConPathToSamples = "C:Miscell est.mdb"

strDB = strConPathToSamples & "test.mdb"
' Create new instance of Microsoft Access.
Set appAccess = _
CreateObject("Access.Application")
' Open database in Microsoft Access window.
appAccess.OpenCurrentDatabase strConPathToSamples
' Run Access macro.
appAccess.DoCmd.RunMacro "Macro1", 1
End Sub
I have included the references to "Microsoft DAO 3.6 Object Library" and "Microsoft Access 9.0 Object Library."
Any help on this subject would be much appreciated.
Thanks

Access Startup
Is there a way to run code from a module on startup without calling it from a macro? Basically, is there a way to replace an autoexec macro with an "autoexec module?"

Startup Form For DB In Access.
Hello,

I am making a parts inventory and service request data base for work. I want the database to open up to a control form, it should just contain buttons to go deeper into the program, not any actual records or fields. But the only way I know to make forms automatically puts the record scroll controls on the bottom of the window. Is there any way to remove this or hide it?

Thank you, Vance

Access 97 Startup Question
When access 97 starts up and you have it set to hide all the toolbars and other access tools from the user, is there a way to show all the design tools and windows based on the user's login id and password? This way you could make an account for editing the database, rather than having to use that cheesy SHIFT bypass key.

Can A Startup Object Be Set In Access XP
Hi there folks, this is just a simple question.

I was wondering if a startup event could be set in Access XP. So that when the database is opened through explorer, a startup form can be chosen.

Many thanks

Question About Shift On Startup (Access)
Is it possible to replace the startup shift-key by an other combination??

Because many people know when you startup a database with the
shift-key you get the database window.

I would like to change this for example to shift + s

is this possible??

Running Code At Startup In Access 2k
Hi all,

I want to do something that should be simple - and yet I've wasted two hours googling about it. I have an MS Access database and I would like to execute some procedures in VBA whenever it starts.

To be clear, I don't want to put the code in the form-open event of my login screen - I want Access itself to call this. I guess what I'm looking for is a "database open" event, but I can't seem to find the syntax anywhere.

6x10^50th or so articles on the internet, and not a one about this.

Oh well, ce la vie and thanks in advance.

Access VB Load Form On Startup
This is probably an easy dumb question. But I cant get access to load my form at startup that I created in access. I know how to load forms and do all that programming in VB, but within access how do you load a startup form. Where exactly would the command code be put to load a form when the access file is opened.

Thanks

Microsoft Access Startup Wizard
Hi. Does anyone know if the window that pops up when Access is opened is programmed in VB or in C(++)? This is the window that prompts the user to create a blank database or to use a predefined template. Where is this code located if it is VB? I am trying to steal the code and put it in Word.

Chris

AD Startup Script - Access SQL Server
I have a startup VBscript (set by GP in Active Directory) that I need to access a SQL Server database.
I'm trying to have it use integrated authentication with ADO.

What permissions do I have to have on the database to allow the computers to talk to the DB before the user logs in?

I'm trying to avoid hard coding a username password as it passes clear text and it is sensitive info.

I've tried putting in the "Domain Computers" computer group into the DB but I get the message

Error Opening Connection
Error Description: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.

Any ideas?

Access Startup Form..urgent
how to make it so it appear everytime my .mdb is open that require to enter a password first before 'seeing' anything in it?..
thanks

EDIT : upss..sorry wrong forum, please move it

Diable Shift At Startup (Access)
How can I disable the Shift key at startup in my access database application?

Creating Startup Menu In Access Using Vb
hi
can some1 pls help. i need to create a startup menu in access using vb. can some1 help with the code part. i need to create switchboard manager in access as a atartup menu using vb

pls rely fast
thnxs in advance

Access 2003 Startup Menu Problem
Hi,

I created an access application and I set up the startup de-flagging every thing in the dialog box.
Now the result is that I can not entry into database tables, queries, ..any more.
What can I do? Does exit a magic word to re-enter on the access database?

Thanks

Edited by - kaiala on 12/17/2007 7:40:38 AM

Automatically Maximize Access Startup Form...
I have set a form in my Access database as my 'startup' form, the problem is however that the form is not maximized. But when I simply double-click my form it does open as maximized. Can someone please help me with some code to do this...
Thanx

"The answer is out there, Neo, it’s looking for you. And it will find you, if you want it to."--Trinity to Neo

Error In Pulling Up Microsoft Access Database With A Startup Form
I've got frmStartup that loads a hidden frmLogOutMonitor that closes out the original frmStartup form.
I have this because in other databases I may have frmStartup load other forms.

In the frmLogOutMonitor - Form_Open code I have the following:

Code:
Private Sub Form_Open(Cancel As Integer)
On Error Goto Err_Form_Open
'turns hourglass on
DoCmd.Hourglass (True)
'closes Startup form
SysCmd acSysCmdSetStatus, "Closing startup form ..."
DoEvents
DoCmd.Close acForm, "frmStartup"
'check properties for all databases
Call Check_Properties

The Check_Properties is a reference to Public Sub Check_Properties in a module and thus I have several of those that are under Form_Open that point to several modules in various areas. Each one of those modules also has error handling...
Keep in mind that frmLogOutMonitor is opened up as hidden - monitoring all kinds of events. It has a timer that uses ADODB to see if a table has a certain value that is checked off as false because if it isn't then it logs everyone out of the database!
If I don't have the proper Error Handling in this database (with another form) and it stops for some serious reason - then I start having issues with running the database. (even when I fix what's causing the error.)
Even if I decompile the database correctly - after all of that... remove the form from the Startup.... then decompile ... do a compression, then a repair...compile and save all modules.... then later put the form in the Startup....frmStartup it still will not run the database at all. It comes up with that Do you want to send this error to Microsoft?

So I know its technically corrupted. To overcome all this I create a new database and then load everything from the old one - since I can at least open the database if I don't have a form in the Startup. But I can't have this happen everytime I get an error. This is too serious to ignore that this will happen in the database.

When my .NET debugger comes up - it gives the following error:

Unhandled exception at 0x651078f1 in msaccess.exe 0xC0000005: Access violation reading location 0x001b89a7.
Address 651078f1 movzx eax, word ptr [edx+eax]

Do you want to Save changes to msaccess.sln?

An exception 'Unhandled Win32 Exception' has occurred in msaccess.exe

Any ideas how I can solve this?

Load On Startup (Not Windows Startup)
I would like to make a simple program that when it starts, it starts up one or more programs automatically. can anyone help?

Making A Program Startup On Startup...
How can I use code to alter the run line of win.ini as well as make things start up using the registry.

Run VB Tray App At Startup But Not Via Startup Folder
Folks,

I have created a VB tray app and want to install it so that it runs when the machine is started, however I don't want to use the startup folder.
(You know like the MSN Messenger App.)

Someone told me that you can use the registry to do this but didn't say how.

Any suggestions would be greatly appreciated.

Cheers
John

Startup With Windows, Without The Startup Folder?
How can i make my prog start up with windows, without having to use the startup folder in the start menu? please help.

Specifying A Macro To Run In Access
When I run the following code, I'm prompted to pick a macro to run...there's gotta be a way to put the macro name in the code to avoid this prompt...anyone know how to do it? The macro I'm trying to run is "autoexec" by the way. Thanks!

Code:
With objAccess
.OpenCurrentDatabase ("C:Documents and SettingsJim DayDesktopAmazonHomeHome-EMG.mdb")
.RunCommand (acCmdRunMacro)
.Visible = True
'Set objAccess = Nothing
End With

Run Access Macro
Can I run a MS Access Macro from VB6?

Corey

Access Macro Help
I am trying to incorporate a access database in with a vb program, and i successfully did so, but I need help with one of my macros I am running.

Is there some way to print a table in landscapre view with a macro?

How Do You Run A Macro In Access Via VB?
I have just set up a database replication in Access 2000.

Basically I am trying to build an application that runs indipendantly on 2 different PC's, but runs of the same data, using replication and synchronization.

I have now got both parts pretty much sorted, but was wondering if there is a way to synchronize the databases using a vb script, or if not, just to runa macro that I have created in the access database to do the job.

Ive not found anything really useful so far in my searches, so if anyone has any ideas, id be grateful to hear them.

so basically - how do I run a macro in a database externally from VB?

example details (im crap at decyphering people's vaariables):
database is c:/database/database.mdb
macro is called SyncMe

Cheers

Matt

VB, SQL, Access Macro
Hi guys,

I would like to know if anybody could help me with this specific question.
I try to insert string to access DB to a table throught SQL.

I would like to create a access macro for the insert event from the SQL above to the table i want to insert, so i can do something about this SQL command.

Thanks

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 files and import all records into two tables in access.

If CSV ends with *S.CSV - then import into my table called Summary_table

If CVS ends with *D.CSV - then import into my table called Detail_table.

Any advice on this would be great or help with VB code.

Use A Access Macro In VB App?!
How do I call a macro in Access from my VB app????

Run Access Macro For VB
Hello People
Is there a way to run a Access macro from a vb app.

Help is appreciated

thanks

Run An Access Macro
Hello
Does anyone know how to run an Access macro from an Access Object?

This does not work?

MyAccess.DoCmd.RunMacro "Mcr_Consolidate_ASTUs"

Am I missing something?
Any help would be great!!!

-Will

How To Run More Than One Access Macro In Vb
Hello All,
I am running a access macro in my vb code.
CODE'Macro start to do the import to the Raw table - Start
    txtStream.WriteLine "Thor Macro Start" & CStr(Now) & vbCrLf
    Dim accobj As Access.Application
    Set accobj = CreateObject("Access.Application")
    ' Set database path to web folder on IOSC Web
    accobj.OpenCurrentDatabase ("C:ThorVivekBackend.mdb")
    accobj.DoCmd.RunMacro ("Process")
    accobj.CloseCurrentDatabase
    Set accobj = Nothing
    txtStream.WriteLine "Thor Macro End" & CStr(Now) & vbCrLf
'Macro start to do the import to the Raw table - End

Specifying A Macro To Run In Access
When I run the following code, I'm prompted to pick a macro to run...there's gotta be a way to put the macro name in the code to avoid this prompt...anyone know how to do it? The macro I'm trying to run is "autoexec" by the way. Thanks!

Code: With objAccess
            .OpenCurrentDatabase ("C:Documents and SettingsJim DayDesktopAmazonHomeHome-EMG.mdb")
            .RunCommand (acCmdRunMacro)
            .Visible = True
            'Set objAccess = Nothing
        End With

Access Macro
Perhaps this isn't a VB question, but I didn't see any Access forums at this site and have noted a number of Access/Access related questions answered here.

Is it possible to record a macro in Access 2002 ? If so, any hints on how to go about it? There were no clues in the Access Help files and I see no options for recording in the menus. I do know that it's possibke in Access XP.

MS Access Macro
Please help. I have a database which has a report. The report has a query which needs to check that a field contains a date in a certain format. The date is written as the year, month, and day put together into one string. For example today would be written as 20010730. How can I use MS Access to get the values that are greater than the current date. Or even more simply how can I get the values of the current month, day, and year. I know this is a lot to ask for but any help would be appreciated.

Thanks in advance,
Calvin

Access Macro/VBA Question
I have a series of queries that I need to run before I run a report. The first one checks for new users in the database (set by security, not me). I have to manually take the results and add them into the User ID table. I then run the first query, a make-table query, that has specific data ranges. This is easy to do as I already have a date range condition in my reports that's driven by VBA. As soon as that query is ran, I have about 10 more to click through. Each time it tells me how many records I've appended each time. I have to keep track of the records updates and compare them to the first query number. If they don't add up, that means I've missed something or forgot to update the base table with new information. I need to check it as I go and determine, at the final query, if all the records updated equals the original number. At that point, I can make a report that reflects all of this. The only problem is that along the way, I need to change a field type at step 3, and add a field at step 9. Can this be done through a macro? I can't seem to find any command in a macro that does what I need, so I'm more or less stuck. Any help would be greatly appreciated!

Access - Search Macro??
I know very little about vba in access, so sorry if i sound dense.

I have a form, Invoices based on the invoices table. Is there a way of adding a button to this form so i can search for a specific name, and to display that name and date of the invoice?

I suppose really its just a macro to run a query...but i need to have an inputbox or something to enter the variable (name).

Thanks for any help...

Is There A Macro Recorder In Access???
Someone PLEASE tell me tere is a macro recorder in Access somwhere... Ive used the recorder for excel and it has made my life so much easier not to mention the learning curve much quicker for vba excel.. is there such a thing for access macros? I need to automate a very long process that deals with a whole mess load of queries, and tabless and modifiing data and stuff ... so if this thing existed that would be great if not can somone point me to a quick tutorial or syntax page for VBA access?

THX

Doc

Access Module/Macro In VB6
Hi

I have an access 97 db with a VB6 Front end, I have written a macro and module in access to email reports(queries) out to people. Is there a way that I can get the user to hit a cmd button to run these access macros and modules without opening up access, from the VB6 Front End?

I have done multiple searches and have found ways where this can be done however access needs to be opened up, my problem with that is that i have an autoexec macro that runs and also ive been told that doing it like this is pretty sloppy, anybody have any suggestions?

Access Macro With RunCommand
Hello

I am using the RunCommand in a Macro to preform the Menu command Synchronize Now (for data replication).

I created a replica using the tool and now I want to synchronize it.
Part of the "Synchronize Now" command is that you have to close the database inorder to synchronize with another database.

This work fine if I run it from the menu bar. But it seems to run in a loop when I use it in a Marco. It seems like the database is unable to shut down because a marco is running. I had tried using QUITE and CLOSE after the RunCommand in the macro but its doesn't work.

Thank

dave

Using Vb In Access Xp To Get Into A Macro's Commands
Hello.

I have been assigned a project to begin converting our many access 97 macro's into sql scripts to run much faster on the server.

As many of the access macro's involving creation of local tables and then append/update back to the server data i though i would do some generic analysis on the sql of queries in access compared t similar commands in Transact SQL.

Being a lazy, automation addicted programmer i though i would try and write a little bit of code to assess the chosen macro and output to a text box the sql of its queries/commands so i can analyse it as if the macro was a SQL script. I understand that the access sql i will see is different from T-SQL but i figured it was worth a look.

So here's where i am up to. I have a form with a button and a combo box. The button does this:

Code:
Private Sub Command4_Click()
Set dbs = CurrentDb
With dbs
For Each mc In .Containers
If mc.Name = "scripts" Then
For Each md In mc.Documents

Combo2.AddItem (md.Name)
Next md
End If
Next mc
End With
Set dbs = Nothing
Set mc = Nothing
Set md = Nothing
End Sub

basically it adds the list of macro's in the current db to the options of the combo box.

ok so when i select one of the options in the combo box i have this event:

Code:
Private Sub Combo2_AfterUpdate()
Set dbs = CurrentDb
With dbs
For Each mc In .Containers
If mc.Name = "scripts" Then
For Each md In mc.Documents
If md.Name = Combo2.Value Then
'get the query names here.....
End If
Next md
End If
Next mc
End With
Set dbs = Nothing
End Sub
what i was hoping to do was extract the query names i want to add them to another combo box, and then cycle through its options in order to gather the relevant sql and out put, technically i can do the latter, but i cannot work out or find any help referencing the macro object's contents in Access Xp help or the programming access XP book.

The problem is i am stuck trying to interrogate the macro/script object as a document to get it list of commands, and filter them for open query.

please help.

Startup Macro In Access

hi alli want to create a macro in access which runs every time the database is opened. i've found that a macro named autoexec runs everytime a db is opened but that runs only when we open the database using access. i want to run the macro when i open a connection to access db in vb. Is it possible?