A
Afrosheen via AccessMonster.com
Thanks for reading this.
What I'd like to do if it can be done is to declare all my variables in a
module public function and be able to use them in other programs. For example.
Option Compare Database
Option Explicit
Public head1, strdocname, stLinkCriteria, stwhere, stwhere1, stwhere2,
stwhere3, stwhere4, shft, strUser, Text8, strcnt As String
Public head2, head3, head4, stDocname1, stdocname2, stdocname3 As String
Public userpermission As Integer
One example is the head1 sting. It is used as an openargs statement, but in
different programs.
These variables are used within 3-4 programs. Do you see any problem using
them like this?
What I'm trying to do is cut back in code programming and make the programs
smaller.
Thanks.
I hope I've explained my self .
What I'd like to do if it can be done is to declare all my variables in a
module public function and be able to use them in other programs. For example.
Option Compare Database
Option Explicit
Public head1, strdocname, stLinkCriteria, stwhere, stwhere1, stwhere2,
stwhere3, stwhere4, shft, strUser, Text8, strcnt As String
Public head2, head3, head4, stDocname1, stdocname2, stdocname3 As String
Public userpermission As Integer
One example is the head1 sting. It is used as an openargs statement, but in
different programs.
These variables are used within 3-4 programs. Do you see any problem using
them like this?
What I'm trying to do is cut back in code programming and make the programs
smaller.
Thanks.
I hope I've explained my self .