ACCESS FEED: Re: [MS_AccessPros] Customize the forms tab

Rabu, 26 Oktober 2011

Re: [MS_AccessPros] Customize the forms tab

Hi Art,

you're welcome

just so you understand... Load, what I suggested, happens once -- when the data is loaded

John assumed your vendor (and therefore, form caption) may change with each record and suggested the Current event, which happens each time the record changes.

Depending on what you want to do, just put the code in one of those places ;)

If the vendor is the same all the time and you know it before you open the form, you may want to consider using a TempVar or public variable or database property instead of referencing the control value in case there are no records for that vendor.

Warm Regards,
Crystal

*
   (: have an awesome day :)
*

________________________________
From: Art Lorenzini
Subject: 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]