Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2006
    Location
    Manila, Philippnes
    Posts
    17

    Unanswered: Help with updating records

    we are an HR outsourcing company. we deploy contractual employees to
    different companies. we are now developing an employee database. now, i have
    an employee form which includes all employee information including their
    contracts. what i did was, i created a subform that looks like this:

    http://i114.photobucket.com/albums/n...rmemployee.jpg

    the subforms works absolutely fine, but when i ran a query that involved the
    contract dates, only the contract dates for a certain employee that were
    entered first were returned by the query, and the contract dates that were
    entered last, did not appear on the query.. for example, John Smith's first
    contract was on March 22, 2005 to September 9, 2005 and his second contract
    was on September 10, 2005 to December 17, 2005, the only contract that
    appears in the query is March 22, 2005 to September 9, 2005, while September
    10, 2005 to December 17, 2005 does not appear on the query. is it possible
    that when i enter another contract date on the subform, it will automatically
    update the contract date field? i need this function because my boss needs a
    report in the database that will generate all the expiring contracts, so that
    we can immediately renew the employees' contracts.

    thanks a lot and sorry for the inconvenience. just message me if you have
    some clarifications.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Let's see the query ... Also how is your subform setup? Is it set to Continuous?
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Jul 2006
    Location
    Manila, Philippnes
    Posts
    17
    thanks for the reply. attached is the actual ms access file.. the name of the form with the subform is frmEmployee. and the name of the query is qryExpired. thank you so much.
    Attached Files Attached Files

  4. #4
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I tried looking at your attachment and it wouldn't open. It's possible something is wrong with my system but I just wanted to let you know in case you don't get a response.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  5. #5
    Join Date
    Jul 2006
    Location
    Manila, Philippnes
    Posts
    17
    ok, thanks.. i tried to click on the link, but it did open...

    you can also access the ms access file thru this link: http://www.gigafiles.co.uk/files/636...ch_backup3.zip
    thanks.
    Last edited by lushh; 10-27-06 at 04:45.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •