Search results

Hello and thank you for this forum I have an access database where I can open a Bing Map from an address located in text boxes (street Address, City, State, zip, CountryorRegion. My question is how could I revise this code to open a Bing Map or Google Map from Lat/Long Coordinates located in...

Hello and thanks for taking this question I have multiple tables of data in my access file that I have imported from an on-line source. I have also previously formatted each field (ex: long integer, Short date, text w/50 characters), within my tables to match queries I use repeatedly. So...

Thanks in advance! I have a 4 page tab form and when I open this form I want it to open on page 3 always. Thanks Again Hdata:)

As I was previously typing my question it appears that my post went away. Maybe else timed out will try again. Appending data from a single table into two tables in a one to many relationship. All is well appending to these tables, my problem occurs when I try to run an update query, in...

Goal: Append Data from one table [TestData-AA] into two related tables: tblLandSales and tblDeedData. Don't think possible from Query Design window, maybe from SQL Design window? Maybe right or left join? 1st Append: Primary table tblLandSales　 Set rstLandSales = db.OpenRecordset(" Select * "...

Thank you in advance for I know not what I'm doing. I have a current access 2013 database which is doing fine, however I'd like to proceed with better automation. I have access to online information which I would like to incorporate into my database's existing tables. The external database...

Hello I would like to know how to turn on & off the Dictation Box for Access 2013. Thanks in advance.

Thanks in advance. I'm using a lookup table to populated a combo box on my form. I use a provided list of input strings (hundreds) in my combo box and the list is provided in all caps. How can I convert these provided words (strings) to first cap from either the quarry level or form level...

I want to put command buttons in the Page Header, however the page header is not visible from form view? What is the purpose of Page headers? Thanks for your insight

Thanks in Advance! I'm trying to create a formula at the table level which creates a circular reference problem that way I am doing it. I am using two fields; acres and square feet. One acre = 43,560 sq. ft. I would like to input the number of acres and get the number of sq. ft. calculated...

I currently use Windows 7, and office 2010 and I am building an access database system. Maybe a few hundred thousand records. I plan to divide the database between front and backend, for multiple user purposes. Questions: Will I be able to set the max number of users? Also, Do you...

I'm looking for a way with VBA to find the name of a textbox control after inserting the cursor in that textbox. Possible? Thanks in advance.

I'm trying to format textbox text with a first cap. I've seen lower case and upper case (<) (>); any way to format 1st cap. Thanks

All seemed to be working well, however, I noticed that all my subtable records in the database are exporting with each Primary table record. In my output, i'm looking to see each primary table record followed by one or more subtable records from a one to many relationship. Thanks in advance...

I have succeeded with retrieving subTable data from a One to many relationship, however, I'm stuck in an infinite loop processing the first record of the subtable and not moving to the next one. Any Help, Thanks in advance. Dim db As DAO.Database Dim rstLandData As DAO.Recordset Set db =...

I am trying to export text to a 2010 word document from an access 2010 database with DAO. I have successfully been able to export text from the main table tblLandSales via variables (below) and then subsequently a document. I used the following code: Dim objWord As Word.Application Dim docm As...

I am trying to export an attachment item (Picture .jpg) to a word document. I have been exporting text to a word document successfully with below syntax " With rst strLandSalesID = Nz(.Fields("LandSalesID")) strPhotograph = Nz(.Fields("Attachments")) However, attachment do not work...

I am trying to retrieve the county name I keep in a lookup table. However, I can only get the number code for that county name and not the actual county name. I'm using the following syntax. strCounty = Nz(.Fields("fk_CountyID")) I use a main table with a lookup table called tblCounty...

I'm trying to run a word 2010 sub routine from the Access 2010 module. So far I have been able to launch a word document with attached word template from the Access module. I have many subs located in an attached word template which I have not been able to launch from Access. Any suggestions...

Greetings, (Access 2010) ON 9/10/13 I requested help with an embedded macro in a Microsoft sample database called the Student Database. In design view of the Student list form, I deleted the provided embedded macro on the ID field, and also the txtOpen field on this form so I could try to...