Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007
    Posts
    2

    Automatic Data Entry on a Specific Date

    Little background:
    The place I work at has 3 shifts with 2 crews on each shift that work in different areas of the building. Those two crews change areas every month and occasionally the crews are rearranged.

    Problem:
    I have been able to create tables, queries and such to reflect the above situation I have queries for each of the crews for each shift that go back to one main table. I have a field for the "New Crew Number" (1 or 2) and one for "Present Crew Number". When the crew are rearranged there is a posting stating the new assignment about two weeks prior the the switch. What I am trying to do is I want to be able to enter the number in the "New Crew Number" field and on a specified date have that data be automatically entered in the "Present Crew Number" field. Is this possible and if so how can it be done.

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109
    Do you have a form that you routinely open?

    I am not familiar with Access being able to run an action on a specified date. However, if you were to open a form, you could enter some code on your form's "On Open" event or by putting in a command button.

    The code might look something like this

    Dim str as String
    str = "UPDATE yourtablename SET [Present Crew Number] = Me![New Crew Number] WHERE ..."
    Docmd.runSQL str

    You could put in a IF Then statement to see if it would be time to run the update.

  3. #3
    Join Date
    Nov 2007
    Posts
    2

    Thanks

    Thank you the update cade works great now I just got to figure out how to get it to run on that specific date

    Oh and yes there is a form that is opened every day

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

Similar Threads

  1. Date Stamp On Entry of Record
    By tscholts in forum Forms
    Replies: 3
    Last Post: 04-01-2008, 07:08 PM
  2. Data Entry And Data Recalling
    By GeeDee in forum Access
    Replies: 0
    Last Post: 05-01-2007, 05:20 AM
  3. Automatic Syncronization
    By Katada in forum Programming
    Replies: 0
    Last Post: 04-25-2006, 03:36 AM
  4. Finding data between two date for any year
    By gemini2 in forum Access
    Replies: 4
    Last Post: 04-05-2006, 06:20 AM
  5. Run report or sub form during data entry
    By wasim_sono in forum Programming
    Replies: 0
    Last Post: 03-09-2006, 05:40 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