Forms

Posted on Saturday, December 15, 2007 - 19:32 | by admin |

When you create a form, create a form of communication between you and the data stored in Access. While you can create simple forms that look very much like the familiar paper forms, you can also improve the appearance of them with interesting visuals - such as color and shading to define different sections, pictures or graphics - and a wide variety of controls. The Access forms can contain buttons, selection lists, radio buttons and embedded subforms that provide greater functionality than typical paper.

An example of a form

Creating a form with the help of a Wizard
The Wizard asks questions about the form you want to create and then create a form based on your answers.

To create a form with the help of an assistant
1. In the Database window, click on the Forms and then choose the New button.

You will see the New Form dialog box in which you choose which way of creating the form you want. See illustration.
2. To use the wizard select Form Wizard.
3. In the box that appears at the bottom, click on the arrow to choose the table or source query form.
4. Click OK.

If the Wizard does not create the form the way you want, you can manually change the form in Design view, or you can use the wizard again and choose different options as they answer the questions.

RSS feed | Trackback URI

12 Comments »

Comment by Roberto Alves
2009-01-21 13:19:29

Hello josé
I'm here again with a question, I'm creating a protection for my application, based on an example that needs the control where I need to first copy and register the control nslock 15vb5.ocx:

did the research and in my PC system and not found, then saw that this control refers to SP3
SP2 and my system is, as you sugereria me to do in this case

Comment by Administrator
2009-01-22 00:55:56

Hello Roberto,

Never used the nslock, but I've been experimenting and found that it is a good tool. As to your question just follow these steps:

1 - Download the component here nslock15vb5.zip

2 - Install the component nslock15vb5.ocx on your computer and make the registry in Windows

First nslock15vb5.ocx must copy the file to the \ windows \ system (Windows 98) or \ windows \ system32 (XP)

After the program has to use regsvr32.exe to register the ocx typing the command regsvr32 \ windows \ system32 \ nslock15vb5.ocx at the command prompt or run. You should get a message indicating that the registration was successful.

Then just use as you wish.

Comment by Roberto Alves
2009-01-24 13:59:02

Thank you for your tip was great use, helped me very much
that's why I found this blog on tips from the best access!

(Maximum Level of progress.)
Comment by Roberto Alves
2009-02-10 12:51:20

how do I get regs32.exe because the system I use is Windows XP SP2 and in System and System32 folder is not

(Maximum Level of progress.)
Comment by carlos cristiano
2009-01-27 21:54:58

very good indeed!

Comment by Salito
2009-02-05 22:53:59

really like database and want to gain experience with you. dem me wonderful tips on the matter.

Comment by Ricardo Sá
2009-08-07 13:50:30

I found this site unintentionally and inadvertently found one thing that came to very geito.

Thanks to the author.
And to help agraceder gave a "helping hand" ......................

Comment by Elijah
2009-08-12 07:32:32

HOW DO I PUT IN A FIELD TOTAL FORM, JA TRIED, BUT NO VALUE APPEARS IN TABLE APPEARS ...

Comment by ELIAS
2009-10-28 20:00:05

how do I put buttons on the form??
Thank you.

Comment by CARLOS
2009-10-29 02:13:46

I would create a form based on a data table. It is very specific.

Comment by Marcelo Balbino
2010-05-26 14:57:31

I made a form and with a control sample RE 01 and so on, when he arrived at 72 RE, the forms went out of order, now when I go to the last appears in the form 48. How do I put in ascending order?

Comment by messiah
2011-12-12 11:29:55

I want to learn more about the creation of forms and queries

Name (required)
Email (required - not published)
Website
Your comment ( Decrease | Increase )
You can use <a href="" title=""> <abbr title=""> <acronym title=""> <blockquote cite=""> <b> <cite> <code> <del datetime=""> <em> <i> <Q cite=""> <strike> <strong> in the comments.

Presentation

Avatar

Thank you for visiting.
Subscribe to feed not to miss any messages.

Here in blog I will provide examples of working with Microsoft Access and also ask questions to those who ask. More

Want to subscribe?

Subscribe or subscribe by email:
Enter your email:


Ads