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.

Control Access Forms

---

Regarding: control of Access forms - here's something that works rock-solid foolfproof ... Assuming Access is running (if it weren't, you would not be trying to manipulate an Access form) ...

 accObject = ObjectGet(, "Access.Application")
 formObject = accObject.forms("name_of_target_form_in_quotes")

 ctrlObject = formObject.controls("Name_of_target_textbox1_in_quotes")
 ctrlobject.value = "New String for Textbox1"
 
 ctrlObject = formObject.controls("Name_of_target_textbox2_in_quotes")
 ctrlobject.value = "New String for Textbox2"
 
 ;etc
 
ctrlObject=""
formObject=""
accObject=""
exit
 
 

You have to know the Access Name of the form and of the controls.

If you don't you can use an ordinal number instead of a name, but you will have to experiment to find out what number corresponds to the form/control you want.

Once you find the number you can't depend on it always being the same, so run a line of code something like ...

message ("Form Name Is",accObject.forms(9).name)

to give you the name. Use the name in your code from then on .

---

Article ID:   W17141

File Created: 2007:07:03:14:28:26

Last Updated: 2007:07:03:14:28:26