By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

textbox: counting & editing

P: n/a

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 ?
Feb 26 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.

Feb 26 '06 #2

P: n/a

"salad" <oi*@vinegar.com> je napisao u poruci interesnoj
grupi:%K****************@newsread3.news.atl.earthl ink.net...
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.
Feb 27 '06 #3

P: n/a
Dado wrote:
"salad" <oi*@vinegar.com> je napisao u poruci interesnoj
grupi:%K****************@newsread3.news.atl.earthl ink.net...
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.

Feb 27 '06 #4

P: n/a

"salad" <oi*@vinegar.com> je napisao u poruci interesnoj
grupi:go*****************@newsread1.news.atl.earth link.net...
Dado wrote:
"salad" <oi*@vinegar.com> je napisao u poruci interesnoj
grupi:%K****************@newsread3.news.atl.earthl ink.net...
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(),.
Feb 28 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.