Recent content by Hdata

Thank you, your suggestion for title is much better.

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

Well Mr. Doc Man you certainly have a great knowledge of this topic and I sincerely respect your efforts. I will do a considerable amount of research of what you have just told me. My primary occupation has been commercial real estate valuations, originally coast-to-coast industrial properties...

Doc Man, you have raised a question for me. If you don't use lookup tables what do you use. I guess you do it in some form of SQL? I am the only user of my database so that helps. This would be the right time for me to look into an alternative. and Thanks again.

WELL DOC MAN, I BELIEVE YOU JUST SOLVED MY ISSUE & THANK YOU VERY MUCH! I will need to look into this foreign key issue. When I was creating the system, I would create a table and add a field and make it a number format. Name it fk_LandSales and in the relations window drag the primary key...

You raise a very good issue. I did not realize that the foreign key should not be changeable. I should look at other examples of 1 to many field relations and see how they work. Thanks, that might be the answer. A field that can not be accessed.

In layman terms, if I could get the update query to update only the foreign key field without deleting the other info in that record provided by query 2, that would be it. Life would be great again.

Thanks again, during the past several weeks I've tried multiple things and what I'm showing you is the closest I've gotten to what I'm looking for. At this time, my best solution is to eliminate the update query, look at the tblLandSales in order to see what the auto number field shows, and...

I want to add whatever I think might help? OK, I have a formal relationship set up in the relationships window whereas tblLandSales has a 1 to many relationship with the child table tblTransferData. Query 1 inserts (Saledate, Cashequiv) into tblLandSales from a third table called...

Thanks for the reply Doc Man Something else I can add is the way I launch the append queries and the update query with DoCmd.OpenQuery (Append 1) DoCmd.OpenQuery "qryAppendBuncoToLandSales", acViewNormal, acEdit (Append 2) DoCmd.OpenQuery "qryAppendBuncoDataToDeedRecords", acViewNormal...

Using Access 2013; Method: Insert Source Table: [TestData-AA] tblLandSales is the primary table in a one to many relationship (Primary key field LandSalesID) tblTransferData is secondary table (Primary key field fk_LandSalesID) Append Query 1 Append Query 2 Update Query

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. OK: Step 1 success with obtaining the Primary key # via @@identity from the (One-side) of the relationship identified as LandSalesID in tblLandSales. The (many-side) is identified as...