Results 1 to 8 of 8
  1. #1
    sarah.s is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2017
    Posts
    17

    form to find and ammend existing records in table

    I am trying to create 2 forms. The first for adding an assessment an employee has not completed before to the database, and the second for updating the date which the employee last completed an assessment they have done before (so is already on the system) I seem to have accomplished the 1st form but I can't seem to crack the second.

    Below is my table:
    Staff Member Assessment X Completed Last Completed Due
    John Doe Assessment A 1 23/09/2015 22/09/2016
    John Doe Assessment B 2 09/03/2016 09/03/2017
    John Doe Assessment C 3 30/03/2016 30/03/2017
    Jane Doe Assessment D 2 11/11/2015 10/11/2016
    Jane Doe Assessment E 2 21/04/2016 21/04/2017
    Jane Doe Assessment F 2 08/06/2016 08/06/2017


  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    select the table,
    click on toolbar icons, forms, FORM.
    this will instantly make a form for this table,
    simply edit the Last completed date field as needed. (or add new records too)

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    You should really try and stick with one thread, or mark the old thread solved so no one wastes their time responding to the old thread..... I'm just sayin...........

  4. #4
    sarah.s is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2017
    Posts
    17
    Sorry ssanfu, I'm new to all this and still don't know the proper 'etiquette'

    I want to use the 'find a record on my form based on the value I selected on my combo box' twice really as I want to find the employee, then the assessment, then it show me the 'x completed' to edit and the 'date last completed' to edit. If I include both the assessment and employee in one 'find a record on my form based on the value I selected on my combo box' it just gives my numbers instead of text

  5. #5
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    No problems..

    OK, combo box 101... you might know this but I don't know what you know.... you know??

    Lets say you have a combo box. The ROW SOURCE property is a SQL string:
    Code:
    SELECT EmpID, FullName FROM tblEmployees"
    So two fields are available..

    In design view, selecting the combo box:
    On the DATA tab:
    The BOUND COLUMN =1 (EmpID - an Autonumber type)

    On the FORMAT tab:
    The COLUMN COUNT = 2
    The COLUMN WIDTHS = 0

    If you leave the COLUMN WIDTHS empty/nothing/NULL, the first column will be displayed after a selection is made.
    If you DON"T want to see the EmpID, set the COLUMN WIDTHS to 0 (zero). This hides the first column and displays the 2nd column (the width is not specified).
    If you change the COLUMN WIDTHS property to 0, 1.75, the first column (EmpID) will be hidden (width set to zero) and the second column width will be set to 1.75".



    If I include both the assessment and employee in one 'find a record on my form based on the value I selected on my combo box' it just gives my numbers instead of text
    Not sure what you mean by this. Do you have 2 combo boxes?


    it just gives my numbers instead of text
    Are we talking combo boxes or after a search (on a form)?

  6. #6
    sarah.s is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2017
    Posts
    17
    sorry I have no idea what you're talking about!
    Do you know of any sort of telephone service where I can talk to someone to resolve these issues! I don't seem to be able to explain myself very well through here

    Complete novice is an understatement!

  7. #7
    sarah.s is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2017
    Posts
    17
    okay so I have changed the data and format tab as you said above but its still displaying numbers instead of the text

  8. #8
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I think it will be easier and faster to see your dB.

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

Similar Threads

  1. Replies: 4
    Last Post: 09-08-2016, 06:35 AM
  2. Importing records into an existing table
    By Jamescdawson in forum Import/Export Data
    Replies: 8
    Last Post: 05-18-2015, 04:05 PM
  3. Replies: 5
    Last Post: 03-03-2015, 09:08 PM
  4. Replies: 2
    Last Post: 03-30-2014, 04:57 PM
  5. Adding records to existing table
    By Mclaren in forum Programming
    Replies: 5
    Last Post: 05-18-2011, 12:44 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