Solved

Userform

Posted on 2000-04-17
8
787 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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

762 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

17 Experts available now in Live!

Get 1:1 Help Now