Solved

Userform

Posted on 2000-04-17
8
827 Views
Last Modified: 2012-05-04
Can create a userform in MS Access 97 and if so how?

I found references to it in the help but not how to create it.

Thanx

Shri
0
Comment
Question by:ShriramS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 14

Expert Comment

by:mgrattan
ID: 2723726
The easiest way to create a new form is to use the Form Wizard.  First, click the Forms tab, then click the New button and select Form Wizard.  Select a Table or Query on which to base the Form and follow the prompts to select other options such as the appearance and layout of the fields.
0
 
LVL 4

Expert Comment

by:berg1375
ID: 2723727
This is how to create a form in Access97 using the Wizard:


1      In the Database window, click the Forms tab.
2      Click New.
3      In the New Form dialog box, click the wizard that you want to use. A description of the wizard appears in the left side of the dialog box.
4      Click the name of the table or query that includes the data you want to base your form on.

Note   You don't need to do this step if you click the Form Wizard option—
you can specify the record source for the form in the wizard.

5      Click OK.
6      If you clicked Form Wizard, Chart Wizard, or PivotTable Wizard in step 3, follow the directions in the wizard dialog boxes. If you clicked AutoForm: Columnar, AutoForm: Tabular, or AutoForm: Datasheet, Microsoft Access automatically creates your form.

If the resulting form doesn't look the way you want, you can change it in Design view.  
      How?

Note   If you click one of the AutoForm options, Microsoft Access uses the autoformat you last specified, either in the Form Wizard or using the AutoFormat command on the Format menu in Design view.
0
 
LVL 14

Expert Comment

by:mgrattan
ID: 2723734
The Form Wizard I mentioned above will give you a basic user data-entry form.  Is that what you want?  

You can also use forms to create switchboard-like menu systems with buttons and other navigational controls (TreeView, Tab, etc.).  Just click the New button on the Forms tab and start adding controls to the form.  You will, of course, need to understand how the controls are used and how to use Event Procedures (Access is Event-driven) to make full use of this feature.  Another option is to use the Switchboard Manager to have Access create the Switchboard for you.  You will find it in the menu under Tools, Add-Ins.
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 1

Author Comment

by:ShriramS
ID: 2724052
Yeah! I am aware of the forms but they are slightly different from VB forms which you find in Word, Excel and VB.

The forms are bound whereas a userform won't be bound and if a userform is maximised, all the windows don't maximise like with forms.

A userform is not an MDI child whereas all the forms seems to be.
0
 
LVL 14

Expert Comment

by:mgrattan
ID: 2724084
An Access form can be unbound....just don't select a RecordSource.  Also, you can use the Popup and Modal properties of the form to keep the form one size without affecting the other forms in the database.  In addition, judicious use of the Maximize and Restore commands (methods of the DoCmd action) will help in keeping your forms looking the way you want.  Each form's OnOpen and OnClose events can be utilized to make sure that particular form is opened in the correct size using:

Docmd.Maximize

or

Docmd.Restore
0
 
LVL 9

Expert Comment

by:BrianWren
ID: 2724901
What is it that you are trying to do?
0
 
LVL 1

Author Comment

by:ShriramS
ID: 2728010
What I am trying to do is simply display a list of cities. It all works fine - but for some reason, every time I load up the form, it duplicates the current record.

I made the form unbound but that prevented access to the list contents and when I made the form snapshot, it just didn't show any of the controls.

I figured if I could use a simple visual basic form, it might solve the problem.

Thanx

Shri
0
 
LVL 9

Accepted Solution

by:
BrianWren earned 50 total points
ID: 2728356
To display a list of items in a table, use a list box with no control source, and set the RowSource to the table with the values.

This does not depend on the _form_ having any data—or not having it either.

Brian
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question