Search results

WOW, really? We don't always drive the same way we bill so a map API is a defensible mechanism. The API does not know the route, access does because the user numbered the stops. It only asks the API for one stop at a time. So a day with 7 stops actually calls the API 6 times.

A few years ago I worked with members of this group and Stack Overflow to develop a callable module that sent a data string to the Google Maps API and received back simple travel time and distance information. (Thank you all for your assistance!) The data string contained Access table...

Thank you for the best looking answer so far. Do you know what the consequences of removing the "Office Click-to-Run Extensibility Component" (12f563b9.msi) might be to my Click-to-Run Office 365 Pro Plus installation?

In Windows 10 pro, I am using Visual Studio Community 2017 (VS), V 15.4.4, to create a Windows Forms interface to some existing Microsoft Access (.accdb) tables. When I attempt to establish a data connection from VS, using the process shown at...

From the button code use "Call SetUpBody" If you wish to include (pass) variables use "Call SetUpBody(var1, var2, var3, etc.) The variables should be public if they need to be available beyond the current module.

I have been using Windows 7 and Access 2013. I just updated a test machine and all went well until I tried to run some of my custom Access applications. Still with Access 2013 now on Windows 10. I am not sure why just yet but some commands like "DoCmd.RunCommand acCmdSaveRecord" are not...

Thank you sir! Dim i as integer Dim myNumber as integer Dim strSource as string Dim strDestination as string For i = 11 To 16 ' assign text box names to a strings strSource = "txtBoxA" & CStr(i) strDestination = "txtBoxB" & CStr(i) ' convert text box string value to...

This is probably a simple syntax question. How do I use Me. with a variable? (Access 2010) Dim i as integer Dim myNumber as integer Dim strSource as string Dim strDestination as string For i = 11 To 16 ' assign text box names to a strings strSource = "txtBoxA" & CStr(i)...

Thank you SQL_Hell, that was exactly what I needed to know. I did as you said and all worked well. I did learn a few things along the way that I would like to share in case others new to SQL Server 2012 SP1 have had similar issues. 1. Unlike other Microsoft products, such as Office, you can...

Hello Access Programmers, I have been assisting a small business (20 seats) with Access front end / back end services and they want to add SQL Server 2012 SP1. They are running a server with MS Server 2012 R2 and have asked me if they can install and run SQL Server 2012 SP1 on the same machine...

If you assigned a global variable for the email body, such as varBody, you could write a public subroutine that is called from your email button code. Public Sub SetUpBody() varBody = "Name: " & NameField & Chr$(13) & _ "Address: " & StreetField & Chr$(13) & _ "City/State/Zip: " &...

When you check a library it automatically applies to that entire database. If you have two libraries checked for outlook, uncheck the one that is not Microsoft Outlook 14.0. Microsoft Outlook 14.0 is the only outlook library that should be checked. You can examine the database I attached above...

In your Visual Basic Editor, on the menu at the top, click Tools > References in the window that comes up locate Microsoft Outlook 14.0 Object Library, check the box to the left of it and then click the Ok button. That should solve your Outlook compiler issues.

Paste all bwellbor's Functions and Sub's into a module called something like modOutlook. You could declare some public variables such as, varAddress, varCC, varBCC, varSubject, varBody, varGreeting and varIportance. Within your page code give values to any variables you wish included in your...

Hello Access Programmers, The attached database evolved with the assistance of members at this thread http://www.access-programmers.co.uk/forums/showthread.php?t=256064. The last issue remaining is an error that, I believe, is not solvable with VBA or related to it. Hence, my post in this...

This generates the same error and blank control. https://maps.google.com/maps?saddr=900+East+New+York+Avenue,+Deland,+FL,+32724&daddr=125+Jenkins+Street,+St+Augustine,+FL

What I end up with is: ="https://maps.google.com/maps?saddr=" & [txtGoogleAddress] txtGoogleAddress = 900+East+New+York+Avenue,+Deland,+FL,+32724&daddr125+Jenkins+Street,+St.+Augustine,+FL This results in the attached error and the Web Browser Control goes blank if I choose either Yes or No...

Bing specifies that spaces be replaced by "%20" but Google does not seem to be so specific. What should replace the spaces? (Answered through research "+")

namliam, I tried the Google URL you suggested instead of the Google API and it sort of works. (I used .com instead of .nl) ="https://maps.google.com/maps?saddr=" & [txtHome] & "&daddr=" & [StoreAddress] & ", " & [StoreCity] & ", " & [StoreState] This is the string that is sent to Google...

The attached database initially uses the following string for txtBingAddress 1%20North%20Woodland%20Boulevard,%20Deland,%20FL~1699%20North%20Woodland%20Boulevard,%20Deland,%20FL I see one error in my string, I only used the adr. once before the origin address. when I place it again between...