Anyone here any good with MS access? - Jemsite
Off-topic / Miscellaneous Talk about miscellaneous stuff off-topic and not related to music, guitars or bands. No music, gear or anything guitar related here please.

LinkBack Thread Tools Display Modes
post #1 of 2 (permalink) Old 07-19-2007, 10:25 AM Thread Starter
Join Date: Nov 2001
Posts: 551
Anyone here any good with MS access?

I'm currently trying to create a database in MS access. I have all the tables and forms working correctly but simply. My problem is one field on the form I have created requires a number of kilometres, but the data collected is in miles (there's no way around this that's just how it is). I want to be able to input the miles on to this form and access to do the conversion automatically. However, I have no idea how to achieve this. Anyone got any ideas?


Al M is offline  
Sponsored Links
post #2 of 2 (permalink) Old 07-19-2007, 07:04 PM
Join Date: Mar 2001
Location: UK
Posts: 149
Re: Anyone here any good with MS access?

I never use Access directly... whenever I need to use .mdb databases I write my own front-end (in good ol' VB6 hehe). That way, it's easy to code conversions and simple to write to the db with SQL statements, but those who like using Access can still get to all the data.
If that's a possibility I could PM you some code but will have to wait until after the weekend as I'm ultra busy.

Alternatively, the way I'd do it within Access is to have both Miles and Kilometers fields on the form and have Access convert whatever you put into the Miles field into Kilometers and auto enter it into the correct field when you press enter:
1) Open the form
2) Click the View button to open the Property Sheet
3) Click on the Kilometers field
4) Under the Data tab choose the Control Source box and hit the ... button
5) In the code box enter [Miles]*1.60934
N.B. replace [Miles] for the name of your Miles field (with the square brackets).

Now when you enter a value in the Miles field and hit enter, the correct Kilometers value will show in the Kilometers field.

Hope that helps.

Last edited by Spagbol; 07-20-2007 at 02:07 PM.
Spagbol is offline  

Quick Reply

Register Now

In order to be able to post messages on the Jemsite forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Please enter a password for your user account. Note that passwords are case-sensitive.


Confirm Password:
Email Address

IMPORTANT: You will be required to activate your account so please ensure that your email address is correct.

If you do not receive your activation check your spam folder before using the CONTACT US form (at the bottom right of each page).

Email Address:


Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode

Similar Threads
Thread Thread Starter Forum Replies Last Post
good songs to illustate the concept of 'pocket' kennydoe Players & Bands, Music & Sounds, Tours & Jams, Lessons & Theory! 16 04-10-2007 08:30 PM
Setup problems with my DBK...good price for a quality setup? Guitarlos2 Tech: Setup, Repairs and Mods 7 07-10-2003 03:39 PM
Nickel Platers, anybody know a good one? Jamie Tech: Setup, Repairs and Mods 11 05-31-2003 11:47 PM
Peavy Amps - any good? kylemac Gear, Equipment, Recording & Off Topic 8 08-02-2001 09:42 PM
Line6 Flextone II XL - A good buy? armindo__dias Gear, Equipment, Recording & Off Topic 2 06-26-2001 05:51 AM

Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

For the best viewing experience please update your browser to Google Chrome