472,337 Members | 1,207 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,337 software developers and data experts.

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...

Apr 12 '07 #1
2 1659
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.
Apr 12 '07 #2
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
Apr 12 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Steve Strik | last post by:
My Problem: I have created a database here at work that is exhibiting some very strange behaviour. Essentially the database is structured in a...
by: matthewemiclea | last post by:
I have a subform, where in the "on current" event, I display code that is supposed to recognize which record I am pointing to, and then display...
by: Susan Bricker | last post by:
Greetings. I have a Mainform with a subform. The Mainform has single record format and subform has continuous form format. When the Mainform...
by: liquid | last post by:
Microsoft Access I am a newbee, so this may be a stupid question, but I will ask anyway. I have a form "Month1" and a linked subform...
by: roveagh1 | last post by:
Hi I've been using the 2 year old link below to repeat values from previous record field into current corresponding field. It's worked fine for...
by: zoeb | last post by:
Hi, I am a complete novice to Access VBA and looking for some help to select a record. I am looking to perform an operation on the previous record...
by: bkberg05 | last post by:
Hi -I have a form which contains a sub-form. The sub-form is tied to the main form by a shared field called Project_ID. The main form has one...
by: steve75043 | last post by:
Hello I hope someone can help with this. I need to subtract dates in current record from previous record for the current store. The key fields in...
by: DanicaDear | last post by:
I will search for on frmCustomers. When I find the customer, I click a button btnShowOrders and it opens frmOrders with subfrmOrderDetails2. (I'm...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.