Re: textbox: counting & editing


"salad" <oil@xxxxxxxxxxx> je napisao u poruci interesnoj
grupi:goIMf.4358$S25.1670@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Dado wrote:
"salad" <oil@xxxxxxxxxxx> je napisao u poruci interesnoj
grupi:%KfMf.3482$F56.937@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Dado wrote:


I have a next situation with the textbox field:
A - B = C

1. How to fill the A fill with the data from my previous recordset ?
Can I do it with the expression builder ?
2. I want that every field I can edit or count, depends on what fileds I
input the value ?



I really don't understand your question. If the textbox is a
calculation, you could enter something like
=[Text0] - [Text1]
or if you want to write a function then
=GetValue([ID])
or create a variable to store it in the declarations section of the code
module
Dim lngVal As Long
and when you save a record, store the value to lngVal. You can do stuff
in the OnCurrent event to stuff that value to the text field.



I was thinking that it was be a nice that access counts me the fiield
(A+B=C),which I didn't insert. So if I insert A and C text field, that
access counts B field. I got counting C field but than i can't insert
value in it.

I wish your English were better. I have a difficult time understanding
your problem. I don't know what A, B, C is representing...I don't know if
each are separate fields...I don't know what you mean by counting or
inserting. Do you have a friend that can write English that can describe
your problem for us? If yes, I'd start another post and see what answers
you get.

In the mean time, look at DCount(), Dlookup(), DSum(), etc. They may meet
some of your requirements.


A, B & C represents separate texbox fields which I tried to edit according
to a next formula:
A+B=C. But never mind and sorry about my English, I figure out that I must
put code in some event, not in a control source.
Thank you on DCount(), Dlookup(), DSum(),.


.

Relevant Pages

  • Re: textbox: counting & editing
    ... How to fill the A fill with the data from my previous recordset? ... I got counting C field but than i can't insert value in it. ... I have a difficult time understanding your problem. ... Do you have a friend that can write English that can describe your problem for us? ...
    (comp.databases.ms-access)
  • Re: getrows and progress bar
    ... Your English is completely understandable. ... > I've to load a recordset in an array with getrows. ...
    (microsoft.public.vb.database.ado)
  • Re: saving information into a tables
    ... Well I have a form that ask the user for Language selection (french or ... English) ... Open a recordset based on the Table and add a new record, ... Dim rs As DAO.Recordset ...
    (microsoft.public.access.formscoding)
  • Re: ADO - Edit changes multiple records
    ... Why use a recordset for a simple update? ... execute this sql without using a recordset? ... Please correct me so I may improve my English! ...
    (microsoft.public.vc.database)