Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-14-2004, 02:21 AM   #1
razim
Guest
 
Posts: n/a
Question Company Name In All Forms.

i have created a table for Company information details. ther eis a form related to htis by the name "frmCompany". What if Want is:

1. When the Database is first time loadted or installed this form frmCompany should be the first thing to appear.
2. After all the details are loaded in this form, next time when the database is closed and opened again this form should not open.
3. The company name mentioned in this form should appear in all my form and reports.

  Reply With Quote
Old 10-14-2004, 07:38 AM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,365
Thanks: 555
Thanked 948 Times in 897 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
How about this?
Attached Files
File Type: zip CompanyName.zip (32.6 KB, 81 views)
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 10-14-2004, 07:40 AM   #3
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,316
Thanks: 15
Thanked 1,600 Times in 1,520 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Create a table to store the company info.
Bind the table to the company form.
Make the company form the startup form.
In the form's current event check to see if there is a record displayed.
If there is a record, hide the form and open the application's switchboard.
If there is no record, leave the form visible.
Have a button on the form that lets the user save and continue. This button will hide the company form and open the application's switchboard.
All of your other forms should reference the hidden form's controls in their ControlSource.

=Forms!HiddenForm!CompanyName

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 08:20 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World