Results 1 to 7 of 7
  1. #1
    todobfl is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    4

    Deadline Monday, Search Form answer MUST be easy...

    Hello all, I am (obviously) a rookie to Access. Creating a database to store information about contract employees. Plan on splitting the database so everything will be run through forms (too many cooks to spoil the hard work).
    Have four tables matching the four types of data we store:
    tblInfo_ID - "main table" stores names, address, email etc.
    tblCertDates - info on 3 certifications we require and dates tests taken
    tblOverUnder - Over/Under as per follow-up reviews
    tblQAScores - Customer Service Scores

    All but the tblInfo_ID will have many entries for each employee

    My problem as silly as it sounds is I need a header that is a search on a last, first name on multiple forms as the data is updated monthly and I plan on turning off the ability to move between records, so as not to allow editing of ANYTHING, only inputting new data.

    Process works like this: Office support person searches on a person by name (they are stored in two separate fields, have querry that combines to last,first) and then either through tabs or separate forms is able to enter the new months data for that person. The ID for each employee is an autonumber.

    I keep getting close but no cigar. I feel helpless. Thanks for any and all help.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    So you want to be able to select a person and have your form go to a new data entry record for that client? That's all?

    I'm assuming your have a form with subforms that are all linked appropriately? If so you could have a list box and/or a search text field where you select the client then just have your form based on a query that is looking up the specific ID for that client and forcing the form to go to a new record

    you would just have to use the REFRESH command once you select a person to re-populate the form with your currently selected person.

  3. #3
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536
    If rpeare's assumption is correct, then here is a tutorial to help you get what you need.

    http://www.datapigtechnologies.com/f...tomfilter.html

    Alan

  4. #4
    todobfl is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    4

    Thank you, almost there..

    Thas a TON for your response, the video was a great help. Filter works great now, only issue remaining is one of ease of use for date inputters...

    Choosing the employee have setup just like your companies, with the EmpID along with the Name, EmpID does or does not show in drop down list (doesn't matter). However, I need the EmpID to populate in the form below so when the form is updtated that data is attached to that employee. I can have them copy it now, but that seems silly since it shows in the line above.

    Thanks again and sorry for being so new!

  5. #5
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536
    In the field for the Employee ID on the form, in the properties for the field in the default value, type =comboxname.column(0). This should populate the field with the employee ID. I am assuming that the employee Id is your PK and is located in the first column in your query.

    Alan

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,622
    My experience has been that referencing Column index doesn't work in Access controls. However, it should not be necessary. Simply referring to the combobox will retrieve the Value property (Value is default). It is also my experience that the Default property setting of a control doesn't work for bound controls. Whatever is in the table overrides the default and if the table has Null or empty string, that is what will populate the box. You would have to set the default property in the TABLE itself. Alternative is to use code (I use VBA) to populate the ID field of the new record.

    If this were a form/subform(s) arrangement this would be simplified. Main form bound to tblInfo_ID, subform bound to other table. Master/child link properties of the subform container would synchronize the related records. New record in child table would automatically populate the FK ID field as soon as other data is entered in the record.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    todobfl is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    4
    I cannot thank you enough. Still work to do making it "pretty", but deadline will be met.

    Thank you, thank you!!

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

Similar Threads

  1. Replies: 0
    Last Post: 03-29-2011, 09:37 AM
  2. There should be an easy answer, Please Help.
    By tucker1003 in forum Database Design
    Replies: 3
    Last Post: 03-03-2011, 01:03 PM
  3. Review/new answer to a question sub-form
    By vt800c in forum Forms
    Replies: 0
    Last Post: 10-18-2010, 12:04 PM
  4. Replies: 0
    Last Post: 12-01-2008, 03:01 PM
  5. Replies: 2
    Last Post: 11-17-2006, 01:07 PM

Tags for this Thread

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