Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Automatically transfering records from one table to another

Discussion in 'Information Technology' started by tanhus, Jul 28, 2006.

  1. tanhus

    tanhus
    Expand Collapse
    Guest

    Hopefully someone can help me out. Im making a time card database for my
    employees. Every time I add an employee to my database an automatic number is
    given to that employee, then i have to go into my time card table and add
    that number (employee), so that the individual can fill out there time sheet.
    Now im trying to figure how i can automaticaly have a record filled out in
    the time card table everytime i add a new employee.
    Thanks for those who can help.
     
  2. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    I'd question your design.

    There should be no need to add the row to your Time Card table until you're
    actually filling in a time sheet.

    What do your tables look like?

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "tanhus" <tanhus@discussions.microsoft.com> wrote in message
    news:D27A8CF9-F4CE-4705-92A5-95EC0DBB42F5@microsoft.com...
    > Hopefully someone can help me out. Im making a time card database for my
    > employees. Every time I add an employee to my database an automatic number

    is
    > given to that employee, then i have to go into my time card table and add
    > that number (employee), so that the individual can fill out there time

    sheet.
    > Now im trying to figure how i can automaticaly have a record filled out in
    > the time card table everytime i add a new employee.
    > Thanks for those who can help.
     
  3. tanhus

    tanhus
    Expand Collapse
    Guest

    Well one table holds the employees so it has
    Field Name Data Type
    Team Member ID AutoNumber
    First Name Text
    Last Name Text
    Position Text

    The Time Card table holds:
    Team Member ID Number


    "Douglas J Steele" wrote:

    > I'd question your design.
    >
    > There should be no need to add the row to your Time Card table until you're
    > actually filling in a time sheet.
    >
    > What do your tables look like?
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "tanhus" <tanhus@discussions.microsoft.com> wrote in message
    > news:D27A8CF9-F4CE-4705-92A5-95EC0DBB42F5@microsoft.com...
    > > Hopefully someone can help me out. Im making a time card database for my
    > > employees. Every time I add an employee to my database an automatic number

    > is
    > > given to that employee, then i have to go into my time card table and add
    > > that number (employee), so that the individual can fill out there time

    > sheet.
    > > Now im trying to figure how i can automaticaly have a record filled out in
    > > the time card table everytime i add a new employee.
    > > Thanks for those who can help.

    >
    >
    >
     
  4. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    What else is in Time Card?

    Hopefully you haven't done something like have fields for StartMonday,
    EndMonday, StartTuesday, EndTuesday and so on.

    Simply create a form that's based on Time Card. For the Team Member ID
    field, rather than a text box put a combo box that's bound to the field, but
    gets its rowsource from the Employee table. That way, you select which
    employee, and get the Team Member ID value to insert into the Time Card
    table when you need it.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "tanhus" <tanhus@discussions.microsoft.com> wrote in message
    news:452F1F08-8E0B-4376-A928-E0C8918664A8@microsoft.com...
    > Well one table holds the employees so it has
    > Field Name Data Type
    > Team Member ID AutoNumber
    > First Name Text
    > Last Name Text
    > Position Text
    >
    > The Time Card table holds:
    > Team Member ID Number
    >
    >
    > "Douglas J Steele" wrote:
    >
    > > I'd question your design.
    > >
    > > There should be no need to add the row to your Time Card table until

    you're
    > > actually filling in a time sheet.
    > >
    > > What do your tables look like?
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "tanhus" <tanhus@discussions.microsoft.com> wrote in message
    > > news:D27A8CF9-F4CE-4705-92A5-95EC0DBB42F5@microsoft.com...
    > > > Hopefully someone can help me out. Im making a time card database for

    my
    > > > employees. Every time I add an employee to my database an automatic

    number
    > > is
    > > > given to that employee, then i have to go into my time card table and

    add
    > > > that number (employee), so that the individual can fill out there time

    > > sheet.
    > > > Now im trying to figure how i can automaticaly have a record filled

    out in
    > > > the time card table everytime i add a new employee.
    > > > Thanks for those who can help.

    > >
    > >
    > >
     
  5. tanhus

    tanhus
    Expand Collapse
    Guest

    Yeah I have done that, but I wanted to know if there was a way that the Team
    Member ID can be automatically inserted into the Time Card table when someone
    adds a new Employee.

    "Douglas J Steele" wrote:

    > What else is in Time Card?
    >
    > Hopefully you haven't done something like have fields for StartMonday,
    > EndMonday, StartTuesday, EndTuesday and so on.
    >
    > Simply create a form that's based on Time Card. For the Team Member ID
    > field, rather than a text box put a combo box that's bound to the field, but
    > gets its rowsource from the Employee table. That way, you select which
    > employee, and get the Team Member ID value to insert into the Time Card
    > table when you need it.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "tanhus" <tanhus@discussions.microsoft.com> wrote in message
    > news:452F1F08-8E0B-4376-A928-E0C8918664A8@microsoft.com...
    > > Well one table holds the employees so it has
    > > Field Name Data Type
    > > Team Member ID AutoNumber
    > > First Name Text
    > > Last Name Text
    > > Position Text
    > >
    > > The Time Card table holds:
    > > Team Member ID Number
    > >
    > >
    > > "Douglas J Steele" wrote:
    > >
    > > > I'd question your design.
    > > >
    > > > There should be no need to add the row to your Time Card table until

    > you're
    > > > actually filling in a time sheet.
    > > >
    > > > What do your tables look like?
    > > >
    > > > --
    > > > Doug Steele, Microsoft Access MVP
    > > > http://I.Am/DougSteele
    > > > (no e-mails, please!)
    > > >
    > > >
    > > > "tanhus" <tanhus@discussions.microsoft.com> wrote in message
    > > > news:D27A8CF9-F4CE-4705-92A5-95EC0DBB42F5@microsoft.com...
    > > > > Hopefully someone can help me out. Im making a time card database for

    > my
    > > > > employees. Every time I add an employee to my database an automatic

    > number
    > > > is
    > > > > given to that employee, then i have to go into my time card table and

    > add
    > > > > that number (employee), so that the individual can fill out there time
    > > > sheet.
    > > > > Now im trying to figure how i can automaticaly have a record filled

    > out in
    > > > > the time card table everytime i add a new employee.
    > > > > Thanks for those who can help.
    > > >
    > > >
    > > >

    >
    >
    >
     
  6. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    But why? In my opinion, it's a mistake to insert "place holders" in tables.
    Add a record for the person when you need it, not just because the person's
    been added.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "tanhus" <tanhus@discussions.microsoft.com> wrote in message
    news:DB6A8017-6F73-4E0B-A3FC-9ECF0159212A@microsoft.com...
    > Yeah I have done that, but I wanted to know if there was a way that the

    Team
    > Member ID can be automatically inserted into the Time Card table when

    someone
    > adds a new Employee.
    >
    > "Douglas J Steele" wrote:
    >
    > > What else is in Time Card?
    > >
    > > Hopefully you haven't done something like have fields for StartMonday,
    > > EndMonday, StartTuesday, EndTuesday and so on.
    > >
    > > Simply create a form that's based on Time Card. For the Team Member ID
    > > field, rather than a text box put a combo box that's bound to the field,

    but
    > > gets its rowsource from the Employee table. That way, you select which
    > > employee, and get the Team Member ID value to insert into the Time Card
    > > table when you need it.
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "tanhus" <tanhus@discussions.microsoft.com> wrote in message
    > > news:452F1F08-8E0B-4376-A928-E0C8918664A8@microsoft.com...
    > > > Well one table holds the employees so it has
    > > > Field Name Data Type
    > > > Team Member ID AutoNumber
    > > > First Name Text
    > > > Last Name Text
    > > > Position Text
    > > >
    > > > The Time Card table holds:
    > > > Team Member ID Number
    > > >
    > > >
    > > > "Douglas J Steele" wrote:
    > > >
    > > > > I'd question your design.
    > > > >
    > > > > There should be no need to add the row to your Time Card table until

    > > you're
    > > > > actually filling in a time sheet.
    > > > >
    > > > > What do your tables look like?
    > > > >
    > > > > --
    > > > > Doug Steele, Microsoft Access MVP
    > > > > http://I.Am/DougSteele
    > > > > (no e-mails, please!)
    > > > >
    > > > >
    > > > > "tanhus" <tanhus@discussions.microsoft.com> wrote in message
    > > > > news:D27A8CF9-F4CE-4705-92A5-95EC0DBB42F5@microsoft.com...
    > > > > > Hopefully someone can help me out. Im making a time card database

    for
    > > my
    > > > > > employees. Every time I add an employee to my database an

    automatic
    > > number
    > > > > is
    > > > > > given to that employee, then i have to go into my time card table

    and
    > > add
    > > > > > that number (employee), so that the individual can fill out there

    time
    > > > > sheet.
    > > > > > Now im trying to figure how i can automaticaly have a record

    filled
    > > out in
    > > > > > the time card table everytime i add a new employee.
    > > > > > Thanks for those who can help.
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >
     
  7. tanhus

    tanhus
    Expand Collapse
    Guest

    I wanna figure this out, so that the team members do not need to insert there
    own time cards and that no one forgets to put a new record into the time card

    "Douglas J Steele" wrote:

    > But why? In my opinion, it's a mistake to insert "place holders" in tables.
    > Add a record for the person when you need it, not just because the person's
    > been added.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "tanhus" <tanhus@discussions.microsoft.com> wrote in message
    > news:DB6A8017-6F73-4E0B-A3FC-9ECF0159212A@microsoft.com...
    > > Yeah I have done that, but I wanted to know if there was a way that the

    > Team
    > > Member ID can be automatically inserted into the Time Card table when

    > someone
    > > adds a new Employee.
    > >
    > > "Douglas J Steele" wrote:
    > >
    > > > What else is in Time Card?
    > > >
    > > > Hopefully you haven't done something like have fields for StartMonday,
    > > > EndMonday, StartTuesday, EndTuesday and so on.
    > > >
    > > > Simply create a form that's based on Time Card. For the Team Member ID
    > > > field, rather than a text box put a combo box that's bound to the field,

    > but
    > > > gets its rowsource from the Employee table. That way, you select which
    > > > employee, and get the Team Member ID value to insert into the Time Card
    > > > table when you need it.
    > > >
    > > > --
    > > > Doug Steele, Microsoft Access MVP
    > > > http://I.Am/DougSteele
    > > > (no e-mails, please!)
    > > >
    > > >
    > > > "tanhus" <tanhus@discussions.microsoft.com> wrote in message
    > > > news:452F1F08-8E0B-4376-A928-E0C8918664A8@microsoft.com...
    > > > > Well one table holds the employees so it has
    > > > > Field Name Data Type
    > > > > Team Member ID AutoNumber
    > > > > First Name Text
    > > > > Last Name Text
    > > > > Position Text
    > > > >
    > > > > The Time Card table holds:
    > > > > Team Member ID Number
    > > > >
    > > > >
    > > > > "Douglas J Steele" wrote:
    > > > >
    > > > > > I'd question your design.
    > > > > >
    > > > > > There should be no need to add the row to your Time Card table until
    > > > you're
    > > > > > actually filling in a time sheet.
    > > > > >
    > > > > > What do your tables look like?
    > > > > >
    > > > > > --
    > > > > > Doug Steele, Microsoft Access MVP
    > > > > > http://I.Am/DougSteele
    > > > > > (no e-mails, please!)
    > > > > >
    > > > > >
    > > > > > "tanhus" <tanhus@discussions.microsoft.com> wrote in message
    > > > > > news:D27A8CF9-F4CE-4705-92A5-95EC0DBB42F5@microsoft.com...
    > > > > > > Hopefully someone can help me out. Im making a time card database

    > for
    > > > my
    > > > > > > employees. Every time I add an employee to my database an

    > automatic
    > > > number
    > > > > > is
    > > > > > > given to that employee, then i have to go into my time card table

    > and
    > > > add
    > > > > > > that number (employee), so that the individual can fill out there

    > time
    > > > > > sheet.
    > > > > > > Now im trying to figure how i can automaticaly have a record

    > filled
    > > > out in
    > > > > > > the time card table everytime i add a new employee.
    > > > > > > Thanks for those who can help.
    > > > > >
    > > > > >
    > > > > >
    > > >
    > > >
    > > >

    >
    >
    >
     

Share This Page