How do I use the expression builder in the private module?

[Frank Martin]

I can use the expression builder in the properties fields to give an
expression such as
"=[Forms]![FrmCustPayments]![FrmCustPaySUB].[Form]![PaymentAmount]"
which is a great help.
But how can I do this in the private module window when I an writing VBA
code?
Please help, Frank

 

[Brendan Reynolds]

If you're using Access 2000 or Access 2002, you can use the TSI Expression
add in at the following URL. I don't know whether it will work with Access
2003.

http://www.trigeminal.com/lang/1033/utility.asp?ItemID=1#1

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Frank Martin]

Very many thanks. I'll investigate this (and the others).
I have Access2000.
Regards,Frank

If you're using Access 2000 or Access 2002, you can use the TSI Expression
add in at the following URL. I don't know whether it will work with Access
2003.

http://www.trigeminal.com/lang/1033/utility.asp?ItemID=1#1

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

I can use the expression builder in the properties fields to give an
expression such as
"=[Forms]![FrmCustPayments]![FrmCustPaySUB].[Form]![PaymentAmount]"
which is a great help.
But how can I do this in the private module window when I an writing VBA
code?
Please help, Frank

 

[Frank Martin]

Thanks, I downloaded this but I can't get it going.
I tried the Access 'addin' too without success.
Please advise how to apply it.
Thanks, Frank

If you're using Access 2000 or Access 2002, you can use the TSI Expression
add in at the following URL. I don't know whether it will work with Access
2003.

http://www.trigeminal.com/lang/1033/utility.asp?ItemID=1#1

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

I can use the expression builder in the properties fields to give an
expression such as
"=[Forms]![FrmCustPayments]![FrmCustPaySUB].[Form]![PaymentAmount]"
which is a great help.
But how can I do this in the private module window when I an writing VBA
code?
Please help, Frank

 

[Brendan Reynolds]

Sorry, Frank, I can't advise as I don't use it myself.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

Thanks, I downloaded this but I can't get it going.
I tried the Access 'addin' too without success.
Please advise how to apply it.
Thanks, Frank

If you're using Access 2000 or Access 2002, you can use the TSI
Expression
add in at the following URL. I don't know whether it will work with
Access
2003.

http://www.trigeminal.com/lang/1033/utility.asp?ItemID=1#1

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible
for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

I can use the expression builder in the properties fields to give an
expression such as
"=[Forms]![FrmCustPayments]![FrmCustPaySUB].[Form]![PaymentAmount]"
which is a great help.
But how can I do this in the private module window when I an writing
VBA
code?
Please help, Frank