|
|
Inserting value of an unbound Textbox
hi,
i got a form in which a integer value (Number) is being calculated based on
the unput the user is giving in the different fields, now i want to insert
this data in a field in my table, when the input is saved
any bright ideas?
|
|
0
|
|
|
|
Reply
|
 Utf
|
3/10/2010 6:46:07 PM |
|
See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Addy" <Addy@discussions.microsoft.com> wrote in message
news:494340EE-F995-4C6D-97E4-46AE1795AD8A@microsoft.com...
> hi,
>
> i got a form in which a integer value (Number) is being calculated based
> on
> the unput the user is giving in the different fields, now i want to insert
> this data in a field in my table, when the input is saved
>
> any bright ideas?
|
|
|
0
|
|
|
|
Reply
|
Allen
|
3/11/2010 12:20:30 AM
|
|
DON'T save it to the table. Queries are great for calculations, and you can
do calculation in forms and in reports too. However, everything is done on
the fly, as you go. I used to think it was a good idea to save the results
of calculations back to a table. After I tried to do what you are trying to
trying to do, and even put up a few posts here, I realized there really is no
reason to do such a thing.
Good luck.
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"Allen Browne" wrote:
> See:
> Calculated fields
> at:
> http://allenbrowne.com/casu-14.html
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
>
> "Addy" <Addy@discussions.microsoft.com> wrote in message
> news:494340EE-F995-4C6D-97E4-46AE1795AD8A@microsoft.com...
> > hi,
> >
> > i got a form in which a integer value (Number) is being calculated based
> > on
> > the unput the user is giving in the different fields, now i want to insert
> > this data in a field in my table, when the input is saved
> >
> > any bright ideas?
>
> .
>
|
|
|
0
|
|
|
|
Reply
|
Utf
|
3/12/2010 4:02:01 AM
|
|
|
2 Replies
506 Views
(page loaded in 4.35 seconds)
Similiar Articles: Inserting value of an unbound Textbox - microsoft.public.access ...hi, i got a form in which a integer value (Number) is being calculated based on the unput the user is giving in the different fields, now i want to insert this ... 12/30/1899 saved in table instead of user input - microsoft.public ...... value (null). and i have an unbound textbox on my form for use input formatted as above. the end value saved in the table is 12/30/1899 i checked it using an "Insert ... display the value of an unbound textbox in a field within a table ...unbound textbox value into a table - PC Review - Computer News and ... display the value of an unbound textbox in a field within a table: fibi: Microsoft Access: 3: 4th ... unbound textbox value derived from subform - microsoft.public ...... values - microsoft.public ... unbound textbox value derived from subform - microsoft.public ... Refresh unbound textbox - microsoft.public.access... could try adding in ... Refresh unbound textbox - microsoft.public.access... values - microsoft.public ... unbound textbox value derived from subform - microsoft.public ... Refresh unbound textbox - microsoft.public.access... could try adding in ... Change textbox color based on matching value in different textbox ...They are currently >> unbound, but will eventually be bound, I think, depending on ... Changing textbox value from dropdown list using Ajax and PHP Yesterday Tarquin macey ... Calculated Textbox using Invisible values - microsoft.public ...unbound textbox value derived from subform - microsoft.public ... Refresh unbound textbox - microsoft.public.access... could try adding in something like the following ... Total Textbox Values on a form - microsoft.public.access.reports ...Adding two textbox Values - microsoft.public.access.forms ..... Me.TxtTotal = Me ... Value From Unbound TextBox Save Value From Unbound TextBox Hi I have a unbound ... Adding two textbox Values - microsoft.public.access.forms ...Change textbox color based on matching value in different textbox ... ... Adding two textbox Values - microsoft ... value,2 - microsoft ... Set the value of a textbox ... Problem: textbox default value = Date() - microsoft.public.access ...I want an unbound textbox on my form to default to current date. In the default value property of the textbox, I put "=Date()". Instead of today's ... Inserting value of an unbound Textbox DataBasehi, i got a form in which a integer value (Number) is being calculated based on the unput the user is giving in the different fields, now i want to insert this data ... Inserting value of an unbound Textbox - microsoft.public.access ...hi, i got a form in which a integer value (Number) is being calculated based on the unput the user is giving in the different fields, now i want to insert this ... Add a text box control to a form or report - Access - Office.comYou can also add a bound text box to a form or report by first adding an unbound ... If the value in Control Source is blank, the text box is unbound. If the value in Control ... Refresh unbound textbox DataBase - DataBase Discussion List ...Refresh unbound textbox Hello, Using Access =9203=85 I have ... Try inserting DoEvents after changing the value of the text box, before running the next query. Inserting an Unbound Textbox to Count RecordsInserting an Unbound Textbox to Count Records ... Rather than use the Default Value to calculate an initial value for the 7/21/2012 4:51:41 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
5 followers. 