Transferring text from PCOMM to Access form text field

S

SelfTaught1

I am writing VB macro that will screen scrape text from a Personal
Communications(IBM) display and assign this text to a text box on an Access
form. I am using the following code and getting a Syntax error. Any help
would be greatly appreciated.

[PCOMM SCRIPT HEADER]
LANGUAGE=VBSCRIPT
DESCRIPTION=
[PCOMM SCRIPT SOURCE]
autECLSession.SetConnectionByName(ThisSessionName)

REM This line calls the macro subroutine
subSub1_

sub subSub1_()
dim AcApp, Acmdb

set AcApp = CreateObject("Access.Application")
Acapp.opencurrentdatabase "Z:\mortgage.mdb"
AcApp.visible = true
with autECLSession.autECLPS
Acapp.Forms!FormName!TxtPolicy = .GetText(2, 3, 30)
End With
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assigning text from outside source to Access form text box 0
Running an Access 2003 macro from VB Script 3
vbs for macro 1
Database Startup in Access 2003 30
Macro to open Access from Appointment form? 4
Problem exporting custom text multi-line field from Outlook to Access 2
Deploy code to launch a custom form from Toolbar button. 1
Code for the topic :E_ACCESSDENIED error when logging into a CDO session to access Global Address Bo 0

Top