Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
OLE with Access
- 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 and Named Arguments
Keywords: Named Arguments
Question:
In your docs about OLE, you talk about "named arguments." Are these like the system variables in VBA? For instance if you open a form in MS Access, you can open it for editing using the option ACEDIT. I've tried replacing it with a numeric option, (I understand access uses zero-based subscripts) but this doesn't work either. I also made sure I had the correct number of args such as msaccess.docmd.runmacro "Macro1",,,,,). I also tried "" (for NULL string inside the commas. (to no avail.)I've got my Winbatch to start Access and open the correct database, but I can't get it to open a form or run a macro. I'm currently using DDE to send the macro commands. I'd prefer to use winbatch for OLE since VB is a little cumbersome.
Here's a sample VB program that works...
Private Sub Form_Load()
Dim AccessDB As Object
Set AccessDB = CreateObject("Access.Application")
' Make Excel visible through the Application object
AccessDB.Application.Visible = True
AccessDB.Application.UserControl = True
AccessDB.Application.OpenCurrentDatabase ("c:\data\access\OMC Region EA.mdb")
AccessDB.DoCmd.OpenForm "Daily"
AccessDB.DoCmd.Close acForm, "Daily"
AccessDB.DoCmd.RunMacro "CSD Daily"
' Close Access with the Quit method on the Application object
AccessDB.Application.Quit
' Release the object variable
Set AccessDB = Nothing
Unload Form1
End Sub
Here's my Winbatch script...
MyDB = ObjectOpen("Access.Application")
dbname = "c:\data\access\duty.mdb"
;MyDB.visible = 1
MyDB.visible = @true
MyDB.usercontrol = 1
MyDB.OpenCurrentDatabase(dbname)
MyDB.DoCmd.openform "Test"
myform = MyDB.Forms(0)
MyDB.DoCmd.openform myform
myform = "Test"
MyDB.DoCmd.openform myform,,,,,
;message("",myform)
message("MS Access","Close Access")
;timedelay(3)
;ObjectClose(MyDB)
I've also tried numerous variations on the openform method (as described previously)
As always, thanks for your help...
Answer:
- There seem to be no parenthesis on your lines. WinBatch needs parenthesis around all arguments.
- Might also need to subdivide the OLE constructs. Try...
MyCmd=MyDB.DoCmd MyCmd.openform("Test")
Article ID: W13664
Filename: OLE and Access.txt
File Created: 1999:04:15:16:55:32
Last Updated: 1999:04:15:16:55:32