1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

#name error access

Discussion in 'Business Applications' started by desertrose152, Nov 8, 2019.

  1. desertrose152

    desertrose152 Thread Starter

    Joined:
    Nov 8, 2019
    Messages:
    1
    Hi
    I am new to access and I was trying to create data base to calculate mileage based on start and end location and their distance in a table. I have created a form to enter the destinations and I want the form to display the distance from the table I have written a code in control source for form but it gives #name error
    tbl1 Dot start end mileage
    frmmileage dot start end mileage 1.png 2.png 3.png
     
  2. Chawbacon

    Chawbacon

    Joined:
    Jul 9, 2018
    Messages:
    493
    First Name:
    Jack
    Hello DesertRose,

    Are you performing a mathematical function to obtain the "Distance" field value within the "tbl1" table?

    If not, simply change the source of the "Distance" field on the "Mileage" form to equal "Distance".

    If you are using a calculation for the "Distance" field within the "tbl1" table, I highly recommend removing the "Distance" field within the "tbl1" table, and performing the calculation on your forms, or reports, as needed. Using calculations within fields on tables can lead to ugly data corruption issues. ;)

    Simply make a query with the required fields, and make one of the query fields an Expression to calculate the mileage. Then change the source of the "Mileage" form to the new Query and update the field sources accordingly.

    Good Luck
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Tags:

Short URL to this thread: https://techguy.org/1235433

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice