brunces
Registered User.
- Local time
- Today, 08:07
- Joined
- Sep 12, 2004
- Messages
- 45
Friends,
Hi, everyone.
Please, anybody can help me with these?...
-----
1) How to show the value of a variable inside a TextBox, in a form or report? I know how to show it in a MsgBox, but I want it to be shown in a TextBox, merged with some other texts of mine.
Example:
"It's been " & varNumberOfDays & " days, since I left my hometown."
-----
2) How to show the value of a field (which has no relation to the current form or report) inside a TextBox?
Example:
A form related to "tblClients" and not related to "tblSearchProduct".
"Client wants to buy a new " & [tblSearchProduct].[ProductName] & " in cash."
-----
3) How to delete the CurrentRecord after checking a criteria (updating of a field)?
Example:
Form has 2 fields. If field 2 is updated and field 1 is still Null, this record is deleted.
On AfterUpdate Event for the field 2, a code has to check if field 1 is already filled. If so, I do what I want. If not, a MsgBox appears ("This record can't be saved!") and then this current record is automatically deleted.
-----
Hope someone can help me.
Thank you very much for your attention, guys.
Hugz.
Bruno
Hi, everyone.
Please, anybody can help me with these?...
-----
1) How to show the value of a variable inside a TextBox, in a form or report? I know how to show it in a MsgBox, but I want it to be shown in a TextBox, merged with some other texts of mine.
Example:
"It's been " & varNumberOfDays & " days, since I left my hometown."
-----
2) How to show the value of a field (which has no relation to the current form or report) inside a TextBox?
Example:
A form related to "tblClients" and not related to "tblSearchProduct".
"Client wants to buy a new " & [tblSearchProduct].[ProductName] & " in cash."
-----
3) How to delete the CurrentRecord after checking a criteria (updating of a field)?
Example:
Form has 2 fields. If field 2 is updated and field 1 is still Null, this record is deleted.
On AfterUpdate Event for the field 2, a code has to check if field 1 is already filled. If so, I do what I want. If not, a MsgBox appears ("This record can't be saved!") and then this current record is automatically deleted.
-----
Hope someone can help me.
Thank you very much for your attention, guys.
Hugz.
Bruno