Search results

That worked perfectly!! Thank you very much!

Thanks for the DB. To make sure I understand how this works, the 2 zip codes need to be within the table randomzips, then the code will go out to google and retrieve the distance?

Only 2 zip codes.

Here's what I have at this time: strhttp = "http://maps.googleapis.com/maps/api/distancematrix/xml?origins=" strhttp = strhttp & strOZip & "&destinations=" strhttp = strhttp & strDZip & "&units=imperial&sensor=false" Application.FollowHyperlink (strhttp) MsgBox "Determine the distance"...

I import information pertaining to a shipment. I have to calculate the driving distance between 2 zip codes. Currently I go to mapquest, enter the two zip codes, then paste the distance within my DB. I've looked at applications that calculate the distance, but they do not calculate driving...

With a few, slight changes to the text, this worked perfectly. Thanks for your assistance!

THANK YOU!! I'll work on this tonight.

I have Access2010 sending out emails for me. Here is the code I'm using 'Text of Body msg = saluation msg = msg & Chr$(13) & Chr$(13) & "Thank you for giving Safe Car Auto Transport the opportunity to assist you with your shipping needs!!" msg = msg & Chr$(13) & Chr$(13) & "Attached is the...

Dim objAccount As Outlook.Account Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.mailitem 'Determine the correct account For Each objAccount In Outlook.Application.Session.Accounts If objAccount = "Dispatch - Safecarautotransport.com" Then 'Create the Outlook session. Set...

I solved my problem. I was able to determine that the name of the Outlook.pst was causing the wizard to not execute. What worked for me was making sure that ".com" existed within the file name. Their maybe other solutions.

Hello, I'm trying to link emails within Outlook 2010 into an Access 2010 DB. After selecting the Inbox to be linked, I receive the following message, Microsoft Access can't find the wizard. This wizard has not been installed, or there is an incorrect setting in the Windows Registry, or this...

I just realized, I can use an export spec. So, a query could do the same thing. Thanks!

dcmd.transfertext

With using a query, how do you specify the output file to not have quotes around each data field?

Thanks for spending time on my problem. Yes, I needed to export a table because of the file specs that are needed on the import process. Comma separated with no delimiter. I solved my problem last night. In my further research, the problem was being caused by my copyobject command. I don't...

These tables are exported, and then imported into an accounting package. The accounting package requires that each membertype be an individual import. That's why I need individual tables/files based on member types.

I've recently split a DB. I've attached two db's to show my problem. First use TestDBGood Within tbl Export New IPG Customers, their exists 44 new customers. These customers need to be inserted into individual tables based on the field "Acct Type". Within form frm Import Data, here is what my...

I'm creating a form that contains a combo box using an ODBC connected table that contains purchase orders. The user selects the desired purchase order. Once the purchase order is selected, I need to display the purchase order items that are a part of this purchase order. The purchase order items...

I found an article from Google. I had to install the add-in off of the original Office CD.

I've installed both the AccessRuntime and the Service Pack 1. They both seemed to install without any errors, but I can't determine how to use it. Searching Google, I read a posting where once the DB is opened, selecting File, Save & Publish, I should see an option named Package & Distribute...