Add a Subform in Access 2007
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Then I edited the table bound to the subform simply to make one of its text fields longer; that's all!
Now, data from the subform table does not show up in the subform at all.
I can still add a new record via the subform, but I will only be able to see it briefly (while initially entering it). if I go to a different mainform record and then return to the one that should have the new subtable record, again, it doesn't show.
However, looking directly at the table for the subform shows that the new record (and the old ones) are indeed still allproperly there in their table.
Question: How do I restrict the subform to show only one row in Datasheet View?
One of the applications our business uses, is tied to Access Runtime 2007.
In the Application when you go to view a report it doesn't load correctly. I have isolated it to the Com Add-in. All of our computers running Office 2007 Professional, I loaded the Microsoft Office Access 2007 and turned the Com Add-in to inactive. This fixed all those computers.
However, on my own computer with the above stated software. I turned the Add-in to inactive in office 2010 and the Com Add-in still loads in Access 2007 Runtime when I load it.
So my question is how do you Inactive/Disable a Com Add-in in Access 2007 with only Runtime installed?
There are NO add-ins when I open it in Safe mode, nothing. I've spent over 5 hours trying to get it to work, and after all these years of working in MS Access with only a few hiccups...
Keep in mind I am the IT department, I am very, very green when it comes to this stuff, just lay it on me easy.
You can use Access 2007 support for managed add-ins to create cross-application tools, as many software vendors will. But, that is not the most likely scenario: Most likely, you will use add-ins to supplement your VBA code, and to gain access to the rich .NET Framework environment. If there are tasks you want to accomplish that are easier in managed code, Access support for managed add-ins is a perfect solution: You get the unmatched Access form and report designers, and the power of Visual Studio and the .NET Framework when writing code. You can extend Access 2007 in ways that were previously difficult (if not impossible) by creating and incorporating managed add-ins into your applications.
What I want to do is add a record in subform 1, and then be able to immediately view that record in subform 2. However, whenever I add a record in subform 1, I do not see it when I click over to subform 2.
I would like a different subform inside the navigation window when a button is click, basically embed the respective subform. For example, the subform to contain the when and what part and the complete to have a button to submit or add additional subjects.
When I right click the subform area and select "build" I am able to add a subform. However, after doing so it disappears as soon as I change from design view.