Search results for query: *

Under Tools >> Options you can set the position of the cursor in a text box.

Get a copy of the book "Writing Word Macros" by Steven Roman (O'Reilly ISBN 1-56592-725-7) This book exposes the Word Object Model and will step you through the basics on how to program Word. You can, as the above code example shows, control the Word application from Access. I use this...

MrBread: Any idea how to do this in a new workspace with a runtime version of Access which won't support the CreateObject method? AvGuy

Evalesthy: I had a look at his SOON add-in and it is a creative bit of programming. Unfortunatley, he uses the CreateObject method to fire the code in the other application and this method won't work with runtime Access. M/S says to use the GetObject function, but this only permits SQL...

Actually this technique does work. However, since I'm trying to do this on client machines that have only runtime Access, it fails; even Microsoft says it won't work with runtime. So back to square one, create a new workspace, start an .mdb file that has the download code in it within the new...

Probably this won't work - I haven't tried it yet, but I have my doubts. Usually this code is invoked from another application such as Excel or Word. Running it from within Access will, I suspect, simply create the database within the default workspace so the file will still be locked. The...

Have you considered creating the output in Access tables and then exporting them to Excel worksheets? After all, it's rather easy to programmatically add columns to tables in Access and drop dead simple to export tables to Excel. Seems to me that would be a better approach.

Oh, I see. No, that's not possible, because the file is locked until the workspace where it was created is closed. No difference between linking and importing in that regard.

Thanks for your suggestion. Linking is a separate function that depends on server side configuration. Most ISP's don't provide the necessary tools that permit linking and Excel/Text transfer through the Microsoft ISAM's. It's the persistent failure of these functions that's driven me to try...

Well obviously I had considered shelling out to another application such as a compiled VB program, but that has its own set of complications. I want to stay within the Access application if I can. What I'm trying to do now is use a separate workspace to invoke an mdb file that performs the...

Are you sure this is correct? If Me!["frmItxt_GISDone"].Value Is Null Then Using the Me! syntax identifies the term following as an object on the form but enclosing it in quote marks identifies it as a literal term. And does the frmItxt stand for the form name or a control on the form? If the...

I want to download an mdb file and then import tables from it programmatically. I've finally got Access to wait for the download to complete, but I've run into a new wrinkle. I can't access the downloaded database because the file is locked until I close the workspace where the code is...

WScript.Shell seems to be more appropriate to server side scripting using IIS. See: http://www.microsoft.com/technet/desktopdeployment/depprocess/osddlex_6.mspx

That may be an approach too. The actual HTTP download code using the Internet Control is as follows: Private Sub Download_Click() stSite = "http://MyDomain.com/MyFile.mdb" stDest = "C:\My_DL_Folder" Dim objHTTP As InetTransferLib.HTTP Set objHTTP = New InetTransferLib.HTTP With...

I'll give it a try. I had just conceived an approach to open a separate mdb for the actual DL and shell & wait from the calling mdb until the DL completes and the other incidence closes. This may be better. Thanks for all your hard work and your willingness to share it. AvGuy

Probably you would need to monitor the operation of the database through a different application. The other application could periodically test the automated application with a timer event that runs a query against the automated database and then sends an email if it fails to get a response. AvGuy

I need to download an mdb file from a web server and import tables from the downloaded file - and I need to do this in code. What's the best way to get Access to wait for the download to complete before continuing? AvGuy

Seems to me it should be me!ClassCode rather than me.ClassCode. And no, that doesn't work. Just yields an error, "Operation is not supported for this type of object.

No, it's not a format problem. The class codes are simple, like this: PQ20663 and it's not confined to just that field. Like I said, I've indexed other fields in the table such as the customer name and then tried to find them after pulling the variable in from Word. They don't work either...

Seek, FindFirst and DLookup do not find the record.