Results 1 to 5 of 5
  1. #1
    DWEvans is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2015
    Posts
    9

    Input to a certain Field on a Particular Record?

    `Is there a way to address a particular Field entry on a particular Record?



    To explain a bit better:
    I have a table with say 4 buildings, Each is a Record with say 4 fields, Date, Attendant, Time Opened, Time Closed.
    From a form Text Box, I wish to Enter Data into say Building 3 Time Closed by addressing the exact cell that would contain the info?

    First, Is this Possible, then 2nd, how do I Address the Cell in the Time Closed Field with the Record ID of Building 3?

    If this is Doable and someone can help me with this, then it is a Major Step in moving ahead with my project!

    Any help and advice will be greatly appreciated!

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Read the material at this link to get an appreciation of Access, database, tables, fields etc.
    It appears you are coming from an Excel/spreadsheet background and that may make learning Access/database more difficult.

    Get comfortable with database terms.

    Perhaps you can describe to readers what exactly is your project -things involved, sample data....

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Orange,

    Your link no work.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Thanks for the heads up.
    I just redid the search and got this
    https://support.office.com/en-za/art...8-3c8c94a7c204

    This was my search string msaccess basics tables, queries, forms
    and the link was the first in the result list

  5. #5
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    OK, now I can start reading

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Autofill next record in input form.
    By TenOc in forum Forms
    Replies: 1
    Last Post: 02-13-2015, 10:22 AM
  2. Don't save record if no data is input
    By Thompyt in forum Programming
    Replies: 15
    Last Post: 11-26-2014, 09:58 PM
  3. populating field in form based on input field
    By BrandonFinn in forum Forms
    Replies: 7
    Last Post: 10-30-2014, 10:45 AM
  4. Replies: 5
    Last Post: 09-25-2014, 08:33 PM
  5. Replies: 5
    Last Post: 11-03-2011, 08:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums