Overlay Microsoft Access Data on a Map or Image in a Form or Report. Real Estate, Restaurant, Gaming

[@TomTalley]

Thanks, Richard. Lots of great tips. Tom

[@599CD]

Glad you enjoyed it

[@dagsgaz]

Hey, new to ms access and programming but I’ve found your videos so useful, thank you! My map shows an area at my work my place with 72 lots, each one of these lots can be one of 8 different types of machinery. I’ve set my code up to name each I’d and highlight them a colour depending on the machinery type. This all works good! My question is, is now possible to highlight which lots are in use, via a qry that looks for a date that is blank?

[@599CD]

599cd.com/IsNull should do it.

[@boerinbeton7052]

This would be great for gardening.

[@599CD]

Indeed! Or farming... Keep track of what's planted where.

[@MadGenious]

How can i use a Report or a Subform as a Map? My map is basically a Grid, and i want to be able to change Text/Cell Colour.

[@Darkvader401]

How do I update/change a person’s name on the assigned cubicle seating map?

[@599CD]

You change it in the table.

[@cambodeeritnews5629]

great video. my access pro 365 doesn't look like yours. i don't know why? do you use another version?

[@599CD]

I have the latest Access 365 (technically in the version info it shows up as 2016, but you have all of the features of 2019 if you have a subscription). Just did an update a few days ago in fact.

[@RobbieMcD]

Hi! Quick question, could the : Const MAXLOTS = 6 Be changed to a dmax to avoid changing the code in future? Also, how could this be adapted if lot numbers weren't all numeric? (Like lot 1a, lot 1b). Would you just lookup the lot id for x instead of the lot number? (Then for the text box overlay dlookup the lot number from the lot id?) Maybe I'm getting mixed up though... Thanks!

[@599CD]

Sure, you could DMAX it, but be careful. You have to make sure you have that many controls on your form too. So I figured if you're going to be adding lots of boxes, changing the MAXLOTS constant wouldn't be that much more to remember. I would stick with numeric lot numbers for the code, and if you want to assign them a "name" you could. Your lot name could be anything you want "1a, 3c, mom's lot, etc."

[@jeremyrangel8138]

I'd have to assume that there's a way to use either the Google Maps API and/or the Open Street Maps APIs to load the relevant mapped areas a background instead of having to cut/paste an image....

[@599CD]

I'm sure there is. This was just a simple example.

[@sherrylemon4404]

So, I'm trying to create an overlay (I think) to print on a pre-printed certificate form. When I copy/paste or import the form, the top 2 inches gets cut off and the rest of the image appears huge. I've spent three days trying to figure this out, and I'm kinda frazzled. I will not use the antique typewriter to make these certificates and they absolutely cannot be handwritten. I've followed how to build a blank template to make the tables and forms and entered the data. I think I can copy the customer data fields over to the image, paste them, and resize as necessary, but I can't figure out how. I'm an absolute beginner at Access and I need help, please. Thanks!

[@599CD]

If you're an absolute beginner, start here: 599cd.com/ACB1 This video might help too: 599cd.com/PrintDocuments

[@kjohnson19615068]

Do you teach multiple user routines, splitting the database etc

[@599CD]

Sure. Splitting is here: kzbin.info/www/bejne/pZ3NY5SFYtiYbqc As far as multi-user Access goes, that's my Security Seminar: 599cd.com/security

[@ehteshamshah]

Thanks for Sharing Knowledge It really help me. Sir I m ur old follower I have a problem and I ask twice earlier how can I get data from external device to our table e,g Weigh Bridge (Weight) and store in our table I shall be thankful if u help in this regard.

[@599CD]

I have no idea. I'd have to look at your setup. Once you do get the data into the computer in any format (Excel, CSV, TXT) then I can teach you how to get that into Access.

[@ehteshamshah]

@@599CD Sir electronic weight machine is connected to computer through computer com /serial port and it show weight by using windows hyperterminal program a software created in vb will show and store that value (Weight) in SQL Database. I tried but fail to do this using Access. Someone tells me that getting weight in table is using mscom. Ocx file and I don't know how to use this in vb.

[@599CD]

Yeah... you're WAY beyond me. I used to write VB software back in the 90s to interface with accelerometers and other machines. I would record the data from sensors and save it to a text file. Then I could load the text file into my program to perform analysis. I can't tell you how to interface with your equipment. If the data is stored in an SQL Server database, then I would suggest connect to that from Access and you should be able to find your data. In any case, this is WAY beyond what I can cover here on KZbin. Once you get the data into Access, then my lessons will help you. I do offer consulting help by the hour if you need further assistance: 599cd.com/Consulting

[@MrAimalsultani]

Well-Done

[@599CD]

Thanks

[@ellehcim8888]

Two questions: How can I add a photo to each lot? Can I list more than one name in each lot?

[@ellehcim8888]

I tried this for the photo but it says "Object doesn't support this property or method" Private Sub Form_Open(Cancel As Integer) Dim ContactID As Long Dim AgentName As String Dim AgentPhoto As Image Dim X As Integer Const MAXPARISHES = 64 For X = 1 To MAXPARISHES ContactID = Nz(DLookup("ContactID", "Agent Query", "ParishID=" & X), 0) If ContactID = 0 Then Controls("Parish" & X) = ("No Agent") Controls("Parish" & X & "_Photo") = ("No Photo") Else AgentName = Nz(DLookup("AgentName", "Agent Query", "ContactID=" & ContactID), "") Controls("Parish" & X) = AgentName Controls("Parish" & X & "_Photo") = AgentPhoto End If Next End Sub

[@599CD]

Images work completely different. I'm using text boxes. See 599cd.com/Images

[@AH-wi6jb]

Please we need QR code in access

[@599CD]

I'll be making a Barcode Seminar later this year that will cover this. In the mean time, there are a ton of 3rd-party apps available that let you display barcodes, including QR codes, in Access.

[@AH-wi6jb]

@@599CD thank you

[@jessemiller9443]

Not what I had in mind. Not useful for anything on a larger scale

[@599CD]

The scale is irrelevant. You could make your image a map of your neighborhood, the world, or the known universe. Size doesn't matter. What do you mean by "larger scale?" More plot points? I have it set to 10 for training, but you could easily replicate more and make 100+.

[@jessemiller9443]

@@599CD I have immensely enjoyed and learned a lot from your videos. I felt terrible about the way I worded my comment. I was referring to importing a list of dozens of addresses from a database and having Access plot them into Google maps automatically, then have that map dynamically change as the addresses change. For example, if I were delivering flowers to a different set of customers every day.

[@599CD]

Thank you. No offense taken. I see what you're trying to do. I did release a video a little while back on mapping a single location on Google Maps. kzbin.info/www/bejne/jIOYd6SJhM1lr8k - I'm pretty sure that could be expanded to include multiple locations. I'll look into it.

[@foxn4cubs-dyetrin8347]

@@599CD By chance, have you been able to explore the multiple locations on Google Maps?