Microsoft Access forms not saving!!

Question

I'm trying to create a form from a Microsoft Access which I can use to print labels for individual records.  I also want to be able to import that form to other databases with the same fields. However, when I save the form or try to export it, there is no record of it on the computer. What can I do?

Answer 1

Just for what it's worth, an Access Form is optimized for onscreen display and interaction with data; though it can be printed, that's not its primary purpose. You would do better to create an REPORT for this purpose.

You can open the Form in design view and save it as a Report so you don't have to start from scratch. As George says, if you want to make the Report (or Form for that matter) available in a different .accdb or .mdb file, you will need to use External Data... Import (or Export depending on where you start) to transfer the Report to the other database.

Answer 2

I imagine what you learned is that you are "exporting", not "saving" the form, correct?

Answer 3

Never mind, I sorted it out.

Answer 4

Sorry about that, I'll try to be a bit more specific.  I have a large database of archaeological items with various information in a number of fields. I also have other access files with the same fields but fewer records. I wanted to put some of those fields onto a form and arrange it so that I can print out a cue-card size label with select information.  

First I selected the table I wanted to draw the fields from and then selected the form button.  In the form design I removed unwanted fields and reformatted the layout to fit on a small card (I also added a box for a title up top and a border using the draw rectangle tool).  When I click save from the top left corner, or from a right click menu, it asks me what I want to call the form and then there is a save option, no option of where to save the form (is that because I'm already in an access file).  However when I give it a name and hit save, I cannot find where it is so if I close the form window I cannot get it back.

Answer 5

Unfortunately, that's not enough information to propose a specific answer.

Do you already have another database into which you want to export it? Are you actually selecting another, existing database into which to export it?

Also, "how" are you trying save the form? Where?