Database Search

match allmatch any Look in all areasLook in current areas Check all datesPrevious dayPrevious 3 daysPrevious weekPrevious fortnightPrevious monthPrevious 2 monthsPrevious 3 monthsPrevious half-yearPrevious year

TechHome

• Access 2000 Advanced DML Transactions
• Access Recordset to CSV File UDF
• Access RunCommand Constants
• ACCESS Table or Query Exists
• Access to Excel via SQL
• Access Visible Problem
• Adding Fields to an Existing Access Table
• Advanced DML Transactions
• Advanced SQL in the Jet 4.0 Provider Example
• Another OLE with Access Example
• Automating Access Tutorial
• Check if Access Table Exists
• Commit Rollback Begin Trans Updatebatch
• Control Access Forms
• Count Access Records
• Csv to Access
• Dealing with ACCESS 97 Field Types
• execute a macro in Access
• Execute a Public function in Access
• Export Access Report in Choice of Formats
• Export MDB to Flat File
• Find Read and Insert Data in Access
• Gather ACCESS Table and Column Information Into Excel
• Get Access Version That Created MDB File
• Get Column Data From an Access Database
• Get Record Count
• How to Use the OpenTable method
• Launch Access Macro from Commandline
• Loop thru a recordset in Access
• Office 2003 Macro Security Issue
• OLE and Access
• OLE Import a table into Access
• OLE Import Table into Access
• Open Access DB with DAO
• Pack an Access Database
• Query and Export Data from Microsoft Access
• Read Write Delete Tables from Access DB
• Repair MDB
• Retrieve Data in Access
• SQL UPDATE Fails with Access
• UDF to Return Record Count
• Updating Table From Filtered Recordset
• Ways to Get Data from and Access file without Access installed

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

OLE with Access Example

Keywords: 	 OLE Access

---

Question:

We are trying to automate running an Access97 form and "pushing" a button. I have looked through the Winbatch Web site and the hard copy documentation for an example on how to do this. Does anybody have an example of using Winbatch to push a button on Access 97 form which they are willing to share?

Answer:

Here's how to start access and open a form, but can't push the button on it until you know it's name. Need Winbatch version 99A or newer...

	AccessDB = ObjectOpen("Access.Application")
	ADB = AccessDB.Application
	; make sure use full db path/name
	ADB.OpenCurrentDatabase ("c:\data\access\expert advisor reports.mdb")

	ADB.Visible = 1
	ADB.UserControl = 1

	ADBCmd = ADB.docmd
	ADBCmd.openform("CSD Surveys")

	ADB.closecurrentDatabase

	;' Close Access with the Quit method on the Application object
	ADB.Quit

	;' Release the object variable
	ObjectClose(AccessDB)

the above opens the form "CSD Surveys" in the specified dbase.

To click the button, you probably need something like...

	ADBCmd.Command11.click 

***after*** you open the form...

get rid of the ADB.Quit line and access will remain open and running on the desktop.

---

Article ID:   W13662

Filename:   Another OLE with Access Example.txt

File Created: 1999:04:15:16:55:32

Last Updated: 1999:04:15:16:55:32