Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Having multiple forms open at the same time.....
- Thread starter rpbenito
- Start date
Pat,
If you check out the Access Developer's Handbook they have code for resizing forms. You'll need that to do what you're talking about. You'll have to find the size of the screen and divide that up. It will be rather complex.
A much easier solution might be to make one form with four subforms on it.
On the other hand, my guess is that if you explain what you're trying to do here (what the data on the four forms will represent), you'll get some good suggestions for alternate solutions.
Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995
Take a look at the Developer's section of the site for some helpful fundamentals.
Remember to reward helpful tips with the stars they deserve.
If you check out the Access Developer's Handbook they have code for resizing forms. You'll need that to do what you're talking about. You'll have to find the size of the screen and divide that up. It will be rather complex.
A much easier solution might be to make one form with four subforms on it.
On the other hand, my guess is that if you explain what you're trying to do here (what the data on the four forms will represent), you'll get some good suggestions for alternate solutions.
Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995
Take a look at the Developer's section of the site for some helpful fundamentals.
Remember to reward helpful tips with the stars they deserve.
- Thread starter
- #3
Ok, here's what I want to do.....I want to have 4 forms...It is for a firm that gets business for their clients.
-I want one form to be a list of the businesses the company is trying to get work for...
-The second form will display all the information regarding the business when it is highlighted in the first form.
-The third form will be all the clients the business
-Fourth form will be all the money the businesses client owes the business
....hope I didn't confuse anyone but any suggestions will help a lot.
-I want one form to be a list of the businesses the company is trying to get work for...
-The second form will display all the information regarding the business when it is highlighted in the first form.
-The third form will be all the clients the business
-Fourth form will be all the money the businesses client owes the business
....hope I didn't confuse anyone but any suggestions will help a lot.
or you cold just have the main form - maximized,
and then the 3 forms that are linked to the main form - will be made as subforms...
Make sure to explore form's properties, for the subforms, get rid of scroll bars, record selectors, navigation buttons, dividing lines, make sure you have none or thin border line
REGARDS, KUZZ
LIFE IS GREAT WHEN THERE IS SOMEONE TO HELP YOU.
DESIGNING DATABASES SINCE 2002
and then the 3 forms that are linked to the main form - will be made as subforms...
Make sure to explore form's properties, for the subforms, get rid of scroll bars, record selectors, navigation buttons, dividing lines, make sure you have none or thin border line
REGARDS, KUZZ
LIFE IS GREAT WHEN THERE IS SOMEONE TO HELP YOU.
DESIGNING DATABASES SINCE 2002
Pat,
Yeah, this is a classic form with subforms situation. You should have a main form for the company and subforms for all of the other things. If you don't ahve room for all of them at once, then listen to KUZZ and put the subforms on tabs.
Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995
Take a look at the Developer's section of the site for some helpful fundamentals.
Remember to reward helpful tips with the stars they deserve.
Yeah, this is a classic form with subforms situation. You should have a main form for the company and subforms for all of the other things. If you don't ahve room for all of them at once, then listen to KUZZ and put the subforms on tabs.
Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995
Take a look at the Developer's section of the site for some helpful fundamentals.
Remember to reward helpful tips with the stars they deserve.
- Status
Similar threads
