updating (using a unbound box on a diff form)

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

(Access 2000)


I ultimately have a unbound text box that gives me # of hours
[retroHRS](i.e. 720), on my switchboard form. It is set as a general number.


Can I use this to do the following:

[2003Frozen].[YR1increaseZERO]-[BasePay]*[retroHRS]


ultimately want to use a update query so based the hours (tied to a
DatePicker) on the switchboard form it will run the calculation and update a
field [2003Frozen].[YR1increaseWPR1]

any ideas,
_Bigred
 
Sorry, but you'll need to rephrase the question.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
I guess the easiest way is how can I use a value in a unbound textbox in a
query that will update my main table.

eg. i want to calculate the # of weeks * 40 then use this value in a update
query. (but right now I am trying to get the datediff from a datepicker
control on my switchboard form, that the user will select.

hope this makes sense.

Bigred



[MVP] S.Clark said:
Sorry, but you'll need to rephrase the question.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

_Bigred said:
(Access 2000)


I ultimately have a unbound text box that gives me # of hours
[retroHRS](i.e. 720), on my switchboard form. It is set as a general number.


Can I use this to do the following:

[2003Frozen].[YR1increaseZERO]-[BasePay]*[retroHRS]


ultimately want to use a update query so based the hours (tied to a
DatePicker) on the switchboard form it will run the calculation and
Click to expand...
update
a
field [2003Frozen].[YR1increaseWPR1]

any ideas,
_Bigred
Click to expand...
Click to expand...
 
_Bigred said:
I guess the easiest way is how can I use a value in a unbound textbox in a
query that will update my main table.

eg. i want to calculate the # of weeks * 40 then use this value in a update
query. (but right now I am trying to get the datediff from a datepicker
control on my switchboard form, that the user will select.
Click to expand...

You can use a form field in a query by using its reference, something like

forms!yourform!yourcontrolname

(the first part is fixed, substitute actual names for the other two)
 
Back
Top