Solved

Userform

Posted on 2000-04-17
8
800 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
  • 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
 
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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now