?
Solved

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

Posted on 2012-04-08
6
Medium Priority
?
281 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
  • 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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
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 Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

839 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