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?
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
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 tried the old version and all of the subforms work fine and I even converted the old version again and all of the subforms are working -- but I've done a lot of work on first conversion so would like to not need to start over, if possible.
This is not an issue with joins or read-only queries because some of the forms being used as a subform that are read-only are linked directly to a table. Also if a form is placed as a subform on another form, but is not linked to the master form at all, editing works. I checked the obvious (allow edits, enabled, locked, etc.)
Is there a new option in 2007 that affects subforms -- like is there an option somewhere that sets all subforms to read-only? Forms/subforms that were working no longer do so