Adding new record using previous record information... help!!

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Maximus
    #1

    Adding new record using previous record information... help!!

    I need some help. I have an .asp page that interfaces with an Access
    table (wjs_SuperInput ). The .asp page looks to the table and pulls a
    recordset based on a job number, 12345, and a weekending date, mm/dd/
    yyyy. If there is no record for that job number with that particular
    weekending date a record is created, and the page refreshes, with form
    fields to allow the user to edit the record and then update it.

    Fields in the table are:

    jobNumber - number
    weekEndingDate - date
    currentHoursA - text
    currentHoursB - text
    reportRequired_ 01 - yes/no
    reportRequired_ 01b - yes/no


    The weekending date changes every Friday. Currently, today, the
    weekending date would be for 4/5/2007, tomorrow morning the weekending
    date moves to 4/12/2007. If a user goes brings up the page looking
    for job number 12222 today the code looks to see if there is record
    for that job with that weekending date. If no, record exists one is
    created and then the user can edit that record. Problem is, tomorrow
    is a new weekending date and there will be no record for job 12222,
    which is ok, but I need to grab the yes/no data from weekending
    4/5/2007 so they carry to the new record. Make sense?? Thanks for
    any help in advance...

    Tags: None
    • Bob Barrows [MVP]
      #2
      Re: Adding new record using previous record information... help!!

      Maximus wrote:
      I need some help. I have an .asp page that interfaces with an Access
      table (wjs_SuperInput ). The .asp page looks to the table and pulls a
      What was wrong with my previous reply in the "COPY field values?? Need
      Ideas!" thread? Please don't start new threads for the same topic.
      And make up your mind what the name of your table is ... ;-)
      --
      Microsoft MVP -- ASP/ASP.NET
      Please reply to the newsgroup. The email account listed in my From
      header is my spam trap, so I don't check it very often. You will get a
      quicker response by posting to the newsgroup.


        Comment

        • Bob Barrows [MVP]
          #3
          Re: Adding new record using previous record information... help!!

          Maximus wrote:
          I need some help. I have an .asp page that interfaces with an Access
          table (wjs_SuperInput ). The .asp page looks to the table and pulls a
          I guess you don't want help after all ...
          --
          Microsoft MVP - ASP/ASP.NET
          Please reply to the newsgroup. This email account is my spam trap so I
          don't check it very often. If you must reply off-line, then remove the
          "NO SPAM"


            Comment

            Previous template Next
            Working...