Company Name In All Forms. (1 Viewer)

R

razim

Guest
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.
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 17:28
Joined
Jul 9, 2003
Messages
16,244
How about this?
 

Attachments

  • CompanyName.zip
    32.6 KB · Views: 123

Pat Hartman

Super Moderator
Staff member
Local time
Today, 13:28
Joined
Feb 19, 2002
Messages
42,971
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
 

Users who are viewing this thread

Top Bottom