Rabu, 26 Oktober 2011

Re: [MS_AccessPros] Customize the forms tab

 

That worked great!

With warm regards,

Arthur Lorenzini
Sioux Falls, South Dakota

________________________________
From: Crystal <strive4peace2008@yahoo.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, October 26, 2011 2:40 PM
Subject: Re: [MS_AccessPros] Customize the forms tab

 
Hi Art,

try this on the form Loaded event:

'~~~~~~~~~~~~~~~~~~

if not me.newrecord then
    me.caption = nz(me.VendorName,"No Vendor Listed")
end if
'~~~~~~~~~~~~~~~~~~

Warm Regards,
Crystal

 *
   (: have an awesome day :)
 *

________________________________
From: Art Lorenzini

I tried something like =[VendorName] and it set it to =[VendorName]
 

With warm regards,

Arthur Lorenzini
Sioux Falls, South Dakota

________________________________
From: John Viescas
 
Art-

Set the form's Caption property.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From:Art

I have a database that is set to display in tab mode. I have a form called
frmVendor and want to know if I can adjust the form caption to display the name
of the vendor? [VEndorName].

Thanks,

Art Lorenzini
Sioux Falls, SD

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar