A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

can this be done



 
 
Thread Tools Display Modes
  #1  
Old June 14th, 2004, 09:56 PM
external usenet poster
 
Posts: n/a
Default can this be done

i am using asp and an access database and here's what i'm TRYING to do
i have 3 fields in the table (hrs_taken), (date), and (hrs_needed).
i also have an update form which updates hrs_taken and date, well anyway i want the value entered in the form that updates hrs_taken
to add to the value allready there. for example: if the value in hrs_taken = 9 and the person enters 2 in the form then i want the
value updated to = 11. i also want to make it so that when the value in hrs_taken is = to the value in hrs_needed(15) a new record
is inserted, having the initial value of whats entered in the form, and the record that = 15 is left alone. can this be done and
does anyone know of a good tutorial for this?
any help at all would be greatly appreciated!
thanks


  #2  
Old June 14th, 2004, 11:44 PM
Douglas J. Steele
external usenet poster
 
Posts: n/a
Default can this be done

No, it can't be done. It's not possible (nor desirable) to have values of
table fields be dependent on the values of other fields.

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


wrote in message
nk.net...
i am using asp and an access database and here's what i'm TRYING to do
i have 3 fields in the table (hrs_taken), (date), and (hrs_needed).
i also have an update form which updates hrs_taken and date, well anyway i

want the value entered in the form that updates hrs_taken
to add to the value allready there. for example: if the value in hrs_taken

= 9 and the person enters 2 in the form then i want the
value updated to = 11. i also want to make it so that when the value in

hrs_taken is = to the value in hrs_needed(15) a new record
is inserted, having the initial value of whats entered in the form, and

the record that = 15 is left alone. can this be done and
does anyone know of a good tutorial for this?
any help at all would be greatly appreciated!
thanks




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:19 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.