Search results for query: *

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...

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

Here's the scenario. I need to find a CustomerID for a Word customer record. I pull the Word customer info into an Access form and then try either DLookup or the Seek method (DAO) to find the CustomerID from a common unique identifier, ClassCode. That is, the Word record and the Access record...

I've been using the following method to import HTML data from a website: DoCmd.TransferText acImportHTML, , "MyList", "http://www.server.com/MyList.htm", True This has been working fine for 18 months. Then the ISP upgraded servers and it's quit working. I've been shopping other ISP's, but...

I've been using the following method to import HTML data from a website: DoCmd.TransferText acImportHTML, , "MyList", "http://www.server.com/MyList.htm", True This has been working fine for 18 months. Then the ISP upgraded servers and it's quit working. I've been shopping other ISP's, but...

I have created a fill-in form that I want to deploy to a website. I want people to fill out the form and then submit it to me by email. I really don't care whether it's the entire form or just the information on the form. Please, someone point me in the right direction so I don't spend...

I have a form that incorporates a subform space. The subform space is occupied by different subforms depending on the data that is to be displayed. The subform space is named SubFormSpace and the different subforms are connected to the SubFormSpace by setting the SourceObject property thusly...

I have two customer tables with identical fields. One is for current customers and one is for outdated customer records mainly old names or addresses that have been superseded by new info in the current customers table. Both tables have CustomerID's that identify the customer like this...

Looking for some already written code to write mp3 ID3v2 tags. Any pointers? AvGuy

I want to specify criteria in a query that comes from a form control using the Like operator. Only I want to limit the number of characters to 4, like this for a criteria statement: Like Left(Forms!MyForm!MyControl,4)* In other words, if the value in the control is 123456 I want to limit the...

I need to concatenate fields in a table using DAO. My problem is that there can be up to 40 fields to be joined and the code is getting rather lengthy. I don't know how many fields there are for each record until the field is tested for a null value. The only approach that I can think of is...

Access has the ability to create tables by using SQL data definition queries through SQL. I'm trying to create a table with a hyperlink field type, but am having trouble with the syntax for that field. Access gags if I just specify HYPERLINK, e.g. DoCmd.RunSQL "CREATE TABLE MyTable...

I have a DB with some MP3 files embedded into it. I want to be able to export the MP3 files out of the MDB file to the hard drive. Any clue on how to do this? AvGuy

Using Access97 I want to pause code in an event procedure until a file downloads from the net. I'm using the FollowHyperlink method to access a zip file. After it downloads I can use Shell/Wait to unzip the file, but need a method to pause the code during the actual download procedure. I'm...

I want to download a file using the FollowHyperlink method and then bypass Windows' Open or Save Dialog box. Any ideas on how to do this? AvGuy