Search results

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

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

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

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

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

Hello Access-Programmers, I am using the Access 2010 Web Browser Control in an attempt to display driving directions. I am working with both Bing and Google maps to see which works best. Also, the licensing terms are very different, if I understand the terms correctly, Bing appears more open...

Hello Access-Programmers, SQL statements were created using the built in Access SQL builder. In the attached database I created a split form named frmContact that uses the first sql statement below, in its RecordSource property. This causes the subform frmContacts_subform, imbedded in the...

Hello Access-Programmers, I would like to read the full name and various address fields from Outlook's contacts. I modified The code below from that found at http://www.vbaexpress.com/forum/showthread.php?27628-accessing-outlook-global-address-book. This accesses Outlooks address book, but it...

Hello Access Programmers, I have a form that has a button that opens a modal form on top allowing the user to perform a task, when done the modal form closes, returning the user to the underlying form to continue their work. That modal form creates some information that I would like to...

Hello Access-Programmers, I am passing the variables varEmployerID and varContactID into a form. The variables are coming into the form fine. The If/Then catches them perfectly. The combo boxes fill flawlessly. As I step through the statement below all seems OK. varComboContact passes to...

Hello Access-Programmers, I have a table (tblContact) with an auto number key field that is numbered sequentially (1-8) there are no deletions, each new record is appended. I wrote a simple FindFirst line to locate a record that is the first record in the table. The FindFirst failed to find...

Hello Access Programmers, This issue has come up here before, under slightly different circumstances, but I do not recall seeing it solved. http://www.access-programmers.co.uk/forums/showthread.php?t=159151 http://www.access-programmers.co.uk/forums/showthread.php?t=249217 I have an Access...

Hello Access-Programmers, I am trying to read the value of a control on an open form from a Public Function in a Module with no luck. I suspect the issue is syntax. Public Function MyFunction(varFormName As String, varControlName As String) If Forms(varFormName).Controls(varControlName) =...

Hello Access-Programmers, I have a simple date stamp that works great in a private sub within a form. (error handling removed for clarity) Private Sub btnDateStamp_Click() ' UserInit is global variable Me!Notes.SetFocus Me!Notes = Chr$(13) & Date & " - " & Time() & " - " &...

This is generating error 3251. What is amiss here? Thanks for looking at this. Private Sub btn_Click() Dim db As DAO.Database Dim rstTable As DAO.Recordset Dim VarID As Integer Dim varString As String Dim varString2 As String Set db = CurrentDB Set rstTable = db.OpenRecordset("tblTable")...

Hello Access-Programmers, I can open Outlook one time when running the code below. Subsequent attempts generate error 462 which I have captured and requested user action. This method seems a bit sloppy. Function SendEmail() On Error Resume Next Set OutApp = GetObject(...

Hello Access-Programmers, I am using Access 2010 and trying to import objects (not tables) from another (closed) .accdb into an open .accdb. I can count the module objects with CurrentProject.AllModules.Count. I need to read the modules names so I can try to import them using...

I have been asked to add features (and fields) to an existing database containing private medical data. The idea is to add features to the empty database, test it with fake data, purge the fake data and deliver it to the user in another state with a simple update button. The Access 2010 database...

This subroutine works for the “Ribbon” and the “Status Bar” but not the “Document Tabs.” What is the Document Tabs bar name in Access 2010 or is File > Options > Current Database > Display Document Tabs the only method to show or hide the document tabs bar? If the latter is true can the Options...

Results from this site assisted me several times when I used Google to search VBA issues. So by joining, I hope to gain further insight and maybe even help someone else. I created and modified several Access databases and Excel solutions at work and for friends, however, I consider my...