Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

macro If Then Else Problem

Status
Not open for further replies.

ApplePirate

Programmer
Dec 16, 2002
65
GB
Hi
I need a macro that is part of a bigger macro to look for a value. i.e. the username. so:-
If username="me" then openform1 else openform2

but i cant get it to do this. the actual function of the macro is to open a word document which is located on a shared drive, but i want to tweak the existing macro to check for a username and then open a copy of the word doc which will be located on the users personal drive space, the benefit is to enable them to use a custom word doc which will include the users scanned signature(basically so they dont have to sign hundreds of letters).
is this possible? Never ever, bloody anything, ever
 
Apple: Can you do your checking on an event in the form in code, IF this then that... etc.. and then after that is done, open up your macro?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top