Results 1 to 3 of 3
  1. #1
    DCR is offline Novice
    Windows 10 Office 365
    Join Date
    Jan 2021
    Posts
    1

    Variable Label Form Names

    Backstory: I'm building an Access DB at the moment refreshing myself on everything. I have 30 employees to go in the DB. Most employees will have the same data. However, some employees will have numbers going into a set field that will be eventually calculated. However, on the entry form I would like to be able to change the name of the individual Labels of the fields. For example, Adam will have a number entered for Registration in Indiana. However, Becky will have numbers being entered but the data will be for Counsel Expenses. So, one number field but two different labels depending on the employee. I would prefer to not use a drop-down but enter the information as I reach the form for both Adam and Becky.



    Is it possible for me to create a form allowing me to change the label depending on the employee?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    instead of a 'label', put the conversion in a table. This value is pulled in the query.

    tLabelTbl:
    C, Counsel
    A, Advisor

    tPersons
    Beck, c
    Adam, A

    join the 2 tables in the query and display the 'spelled' field.
    add this to the form ,or report to show as a label.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Can you describe (simple, plain English) the business this database is intended to support?
    And show us your proposed tables and relationships.

    As for your question re example Adam and Becky, relational database works very well with 1 field representing 1 fact (also called atomic data). Can you step back and abstract a field that represents some number valued field, and perhaps a second field (or lookup/reference table) that identifies what that number means in your context.

    Example: ExpenseAmt and ExpenseType

    Good luck

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

Similar Threads

  1. Replies: 1
    Last Post: 05-02-2019, 09:12 AM
  2. inserting a variable into a label
    By Jen0dorf in forum Access
    Replies: 4
    Last Post: 04-02-2016, 11:02 AM
  3. using dynamic label/variable name
    By Eef in forum Programming
    Replies: 4
    Last Post: 10-19-2014, 06:24 AM
  4. Can Access Column Have Label & Underlying Names?
    By Soule in forum Import/Export Data
    Replies: 1
    Last Post: 12-22-2011, 01:18 PM
  5. Refering to variable form names inside a variable
    By redpetfran in forum Programming
    Replies: 2
    Last Post: 05-21-2010, 01:39 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