Access MS Access vba AfterUpdate coding question (hopefully a simple fix!)

A

Allen Sundholm

Joined
May 23, 2017
Messages
1
Reaction score
0
Hi all, this is my first post, and please be warned, I am no wiz on coding! I have an MS Access dbase. Three fields in one of the tables are for 'LATITUDE' (sample data in this field is -29 27 36.00), LONGITUDE' (sample data in this field is 115 00 57.90) and 'LATLONGWITHDEGMINSEC' (which is blank). I would like a bit of vba code to place in the AfterUpdate property for each of the LATITUDE and LONGITUDE fields so that as each of those two fields are updated, the LATLONGWITHDEGMINSEC field is automatically filled to exactly show 29°27'36.00"S 115° 0'57.90"E.
Any and all help would be very much appreciated, many kind thanks!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Text Files Into Access 1
Access Import MS Outlook messages into MS Access - The Email Body Loses Formatting 0
Access MS Access - Forms and Autogrow 0
Input Mask - quick question 6
Problems exporting database access 2000 file to dbIII format 1
populate 5 other fields when one is filled out 1
Can't create a report from my query in Access 1
Access MS Access Data Entry Issue -> Please help! 0

Top