Need Microsoft Access help with opening/saving forms?

Question

This is probably really easy but for the life of me I can't figure it out.

I'm new to Microsoft Access and I am trying to create a very simple database with one table and one form. On the table, I would like to be able to click a link ("Open") that will open my form so I can view or edit the data. I would also like a link that will let me fill in a blank form ("New").

Within my form I'd like to have buttons at the top that will allow me to save the current form and open a new blank one ("Save and New") and save and close the current form ("Save and Close").

For an example: Microsoft's "Student Database" template has a form called Student Details that allows you to do all of this. I'm just not sure how to translate it over to my database.

Thanks!

Answer 1

All those things are made with macros.



You can't have buttons in tables.



You got to create a form based on the table and, within the form, you'll create that will perform defined tasks (Save document, Close form, Go to a specific record, whatsoever). These tasks are set in macros.



Within the form, you'll assign a task to each button you've created.



After the button was created, open the Properties Window and go to the On Click line. Choose the appropriate macro you've already created, with the task you want it to perform.



Or you could just send me your database and your requests to [e-mail] and I'll fix it for you

Answer 2

In Access, there is a sample database called Northwind Traders (or the like). Pull it up & test how the forms work. You'll see there can be several tables used by a form. You can have a table of customers linked to a table containing their orders, for example. The "link" is the customer name or number that appears in both tables. You need a common field in order to link the tables together. If you set up your tables properly, (and if I understand the question properly) you should be able to do what you describe. The form itself, is secondary to setting up the tables and the links between tables. Hope this helps!

Answer 3

press alt + F4