Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Access 2007 trying to insert a subform gives me an error.

Posted on 2012-04-08
6
Medium Priority
?
280 Views
Last Modified: 2012-04-10
I have two completed Forms that are working. One is the header and the other is the detail form. I went to the subform/subreport button and selected the area I wanted the subform placed and then as I clicked the area to place I got the following error.

We are using ACCDB as the file type. can anyone tell me why I cannot insert the subform which has to be done....? I am lost and a beginner in this kind of work. Thank you.
AccessError.png
0
Comment
Question by:ruavol2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 1500 total points
ID: 37821930
Is the database shared / currently open by other users?

(everyone else needs to be out of the database for you to make design changes)

If you are sure that everyone else is out, close your own copy of the database, and verify that there are no laccdb (lock files) present - delete any that remain after all users are out of the database.
0
 

Author Comment

by:ruavol2
ID: 37821938
I got the  to drop in by simply dragging over the form from the "All Access Objects" section. However there is one other thing I do not understand how to do and that is how to connect the two tables behind the two seperate forms. One is like the Orders Header and the other the Orders Detail..... This is very important and I do not know how to do it. can you advise..,?
0
 
LVL 61

Accepted Solution

by:
mbizup earned 1500 total points
ID: 37821949
In the form's design view, right- click the very edge of your subform control  - the "frame" of it - and select Properties.

Under the Data tab, look for Master and Child links.

That is how you link the forms.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 1500 total points
ID: 37821954
Btw - another way to do this (as opposed to dragging dropping the subform) is to choose a subform control from the form design toolbox, and place/size it on your main form.

That should invoke a wizard which will step you through selecting the subform and linking it to the main table.

Both methods work.

The wizard does some hand-holding, but your method will ultimately teach you more :-)
0
 
LVL 31

Assisted Solution

by:hnasr
hnasr earned 500 total points
ID: 37822259
This comment was submitted in another thread.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27666131.html#a37822249

Find Msaccess.exe
Right click the icon  and select Run as administrator.
Open database. Check and comment.
0
 

Author Closing Comment

by:ruavol2
ID: 37831159
Thank you
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

618 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