Senin, 27 Maret 2017

Re: [MS_AccessPros] String will not appear in a label

 

John,

After I submitted this the darn thing started working I have it declared in a modGlobals modual is declared as global. Anyway for whatever reason its working. What concating the string just to bring back any after the comma? 

With Warm Regards,
 
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."  







From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, March 27, 2017 12:32 PM
Subject: Re: [MS_AccessPros] String will not appear in a label

 
Art-

Where is gstrThisEmpName defined, and is it defined as Public or Global?  The fact that you're getting nothing except "Hello" tells me the variable isn't set or isn't Public or isn't in the public domain or hasn't been set yet when you set the Caption property.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Mar 27, 2017, at 7:56 PM, dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:




I have a variable which is gloablly defined as gstrThisEmpName as String. It is assigned a vale during the login process:
gstrThisEmpName = Me.cmbUserID.Column(1) which will assigne the name value as Doe, Jane.

WHen I pass this value to the next form in the the Form_Load statement:

  Me.lblLoginName.Caption = "Hello " + [gstrThisEmpName] the only thing that appears is the word Hello. I have tried it like   Me.lblLoginName.Caption = "Hello " & [gstrThisEmpName] and it does the same thing. 

Also I would like to concatenate the   [gstrThisEmpName] string to reflect just the first time basically all the characters after the comma. Any ideas?

Thank you,

Art Lorenzini
Sioux Falls, SD.





__._,_.___

Posted by: Art Lorenzini <dbalorenzini@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Posting Komentar