Results 1 to 5 of 5
  1. #1
    ismalee is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    2

    Post Employee info in Payroll form

    Dear All.

    I am Ismail , new in MS access,

    i have made a database for my company that include emplyee Information EmployeeName, ID number ,Salary basic , housing, telephone , in TBEmployee and etc,..

    my manager now need to add Payroll in same database. so i have made a table for payroll called TBpayroll with Name, ID number ,Salary basic , housing, telephone, OT, OTTravel, Leavepay, Airfair .

    I have made a Form FrmSalary that bounded to TBpayroll with all field.

    My Question : Can i get vallues in FrmSalary text field Salary basic , housing, telephone from table TBEmployee by selecting EmployeeName combo box.

    Please give me a solution,

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Welcome Ismail. Is this what you're after?

    http://www.baldyweb.com/Autofill.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    replicant00A52 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2012
    Posts
    9
    @pbaldy regarding the link you provided above (I am also new to access 2007). What if the customer table has thousands of names and a drop down is not practical. I have been trying to figure out how to build a customer order form that will function as follows:

    - search CustomerTable
    - auto fill form with details from CustomerTable
    - search ProductsTable
    - auto fill form with details from ProductsTable (price etc.)
    - do some basic accounting calculations (price X quantity etc.)
    - make a new record in the SalesTable (Customer A purchased product B for X amount on specified date)

    is this even practical / possible in access I have scoured the web and not found a good implementation of such an access form.

    Thanks

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Not sure why a combo wouldn't be practical, as the user can still type in values. You can also do this:

    http://allenbrowne.com/ser-32.html
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    replicant00A52 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2012
    Posts
    9
    good point on the combo box. The coding in your link is way over my head. John Galt is a character from an Ayn Rand Novel (Atlas Shrugged, I think)

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

Similar Threads

  1. Replies: 8
    Last Post: 06-06-2012, 12:28 PM
  2. Filtering employee id with query on a form
    By stylar in forum Queries
    Replies: 1
    Last Post: 04-23-2012, 06:01 PM
  3. Replies: 35
    Last Post: 12-21-2011, 02:16 PM
  4. Replies: 9
    Last Post: 02-15-2011, 03:05 PM
  5. Replies: 3
    Last Post: 01-31-2011, 11:47 AM

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