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.
I have a form and the technician need to use a subform in this form to add items on the order, and for each items there is a given delivery date. What I want is for a textbox on the form(not the subform) to get the Highest date from the subform
My subform is called : SF_Materiaux and the field in the subform is called : Livraison_Prevu
Sorry for those french name lol
I had a textbox whose source is =[SF_Materiaux].[Formulaire]![Livraison_Prevu]
and it gives me the first date from the subform and If I had Max() before it it gives me #error anyone can help ?
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?
MUSICAL-PUBLICATION Table (including musical titles)
JUNCTION Table subordinate to both the other tables
The form displays the rows in a subform. I need the subform rows to include musical titles from. The users would not be permitted to perform updates in the subform. Hopefully this is possible in MS Access 2007.
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 have a subform (based on a query) which displays four columns of figures. I need to add a total to the bottom. How do I do this? My data appears as follows:
I've read that it can be done with VBA but I can't find any further information on how it is done