No announcements
Found 1127431 threads
-
0 VotesButton to order a field on a subform
End With than referencing the same object multiple times ~ also, the name of the query or table is only required if the same field name is in the RecordSource multiple ...Answered | 3 Replies | 606 Views | Created by system243trd - Tuesday, November 10, 2015 7:18 PM | Last reply by Crystal (strive4peace) MVP - Tuesday, November 10, 2015 8:30 PM
-
0 Votes
how to check the fields in subform are null
It is very easy to create a subform by just using one of the GUI button from access in design tool tab.Answered | 3 Replies | 5661 Views | Created by jinzuya - Tuesday, April 27, 2010 7:42 PM | Last reply by Alex Feng (SQL) - Friday, April 30, 2010 2:43 AM -
3 Votes
How to populate fields in a form with fields in a subform?
How do you create the subform?Answered | 3 Replies | 3165 Views | Created by nickjohnson - Friday, July 13, 2012 3:45 PM | Last reply by Dwntrdr - Saturday, July 14, 2012 5:22 PM -
2 Votes
Subform Running Balance
If it is a datasheet form, the Totals button in the Records group on the Home tab of the ribbon will be enabled.Answered | 3 Replies | 3401 Views | Created by pjscott51 - Thursday, November 3, 2011 10:49 PM | Last reply by pjscott51 - Friday, November 4, 2011 12:33 AM -
3 Votes
Refering to a Command Button in a Subform
Hello, If you want to set focus on the command button, then the code provided by Gunter will do it for you.Answered | 8 Replies | 10034 Views | Created by KKbondo - Friday, July 16, 2010 8:40 AM | Last reply by KKbondo - Friday, July 23, 2010 10:24 AM -
0 Votes
Toggle Button to disable subforms and current form controls
Hello all, I currently have a toggle button on an access form that when clicked grays out the controls on the form.Answered | 2 Replies | 1449 Views | Created by Keith732 - Monday, December 23, 2013 8:39 PM | Last reply by Keith732 - Friday, December 27, 2013 9:01 PM -
1 Votes
Problem with refer to field on subform inside to subform which is stored on mainform.
OK, yes, that would be another use for subforms.Answered | 4 Replies | 955 Views | Created by DanielskiPL - Friday, March 7, 2014 10:23 AM | Last reply by Rich P123 - Friday, March 7, 2014 11:08 PM -
0 Votes
Control subform data from buttons in the container form
# Undo on a Form with SubFormsAnswered | 1 Replies | 550 Views | Created by Geek2020 - Monday, December 5, 2016 12:02 AM | Last reply by Edward8520 - Monday, December 5, 2016 6:30 AM -
3 Votes
When a calculated field is zero on a subform, it returns "#Erreur"
' ' 'End Sub Another approach I've used =NZ([APPRO subform].Answered | 14 Replies | 5289 Views | Created by Claude Larocque - Thursday, August 25, 2011 2:59 PM | Last reply by Phil Stedman - Friday, May 11, 2012 10:37 AM -
0 Votes
subform not retaining updated data
Hi folks- I've got a form, which includes a subform.Answered | 3 Replies | 791 Views | Created by Casey_M - Wednesday, December 16, 2015 10:00 PM | Last reply by Ken Sheridan - Thursday, December 17, 2015 3:53 PM -
3 Votes
Have #Erreur in a field because no record in a subform
You should be able to use Keri hardwick's nnz() function, posted here on The Access Web: ...Answered | 5 Replies | 801 Views | Created by Claude Larocque - Friday, May 8, 2015 6:03 AM | Last reply by Claude Larocque - Monday, May 11, 2015 5:45 AM -
0 Votes
AllowEdits on subform
If you want to turn AllowEdits On and Off, just use the Command Button you already use.Answered | 17 Replies | 2151 Views | Created by jshot - Thursday, May 31, 2018 7:17 PM | Last reply by Terry Xu - MSFT - Friday, June 1, 2018 5:20 AM -
0 Votes
SubForm
The people table to be primary with a unique primary key field - Autonumber works real well.Answered | 2 Replies | 709 Views | Created by Tee Tee1 - Sunday, April 12, 2015 3:11 AM | Last reply by Tee Tee1 - Monday, April 13, 2015 3:21 AM -
3 Votes
updateable subform how?
The conventional interface for this would be a vendors form in single form view, bound to a query which orders the records in whatever order you wish, e.g. by the ...Answered | 7 Replies | 653 Views | Created by PuzzledByWord - Thursday, October 8, 2015 11:19 AM | Last reply by PuzzledByWord - Monday, October 12, 2015 10:26 AM -
0 Votes
Strange problem with a subform
As stated before this worked perfectly well when there was only a form and subform.Answered | 4 Replies | 2934 Views | Created by CJ_London - Sunday, October 9, 2011 6:36 PM | Last reply by Geoff_G - Tuesday, October 18, 2011 11:19 PM -
0 Votes
Navigation Form - switching subforms
To TEMPORARILY change the Source Object of a subform you can use: Me.SubFormName.SourceObject="FormName" Me.Requery I would ...Answered | 3 Replies | 2704 Views | Created by zdrae - Wednesday, February 29, 2012 3:44 AM | Last reply by Lawrence Ellefson - Sunday, December 30, 2012 10:28 PM -
0 Votes
Call Exit event of a subform control in Navigation Subform
If you need to call a parameter from the subform the syntax is: Forms!Answered | 3 Replies | 1264 Views | Created by BlakWidow61 - Tuesday, January 14, 2014 12:49 AM | Last reply by ryguy72 - Sunday, January 19, 2014 8:35 PM -
0 Votes
Form with Subform
I'm trying to do a form with a subform.Answered | 1 Replies | 1060 Views | Created by Casey_M - Friday, March 21, 2014 6:35 PM | Last reply by Dirk Goldgar - Friday, March 21, 2014 6:51 PM -
0 Votes
Update subform with ID from parent form.
169 Note that if you are using an earlier version of Access you might find that the colour of some form objects such as buttons shows incorrectly and ...Answered | 2 Replies | 774 Views | Created by Gord0oo - Monday, February 8, 2016 10:29 AM | Last reply by Ken Sheridan - Monday, February 8, 2016 12:43 PM -
0 Votes
Referencing a Button in a navigation form with several subform from a form
Using the Main forms button On Click event: Me.Answered | 1 Replies | 1489 Views | Created by behzadgh - Sunday, October 7, 2012 9:34 AM | Last reply by Lawrence Ellefson - Sunday, October 7, 2012 3:38 PM - Items 1 to 20 of 1127431 Next ›
No announcements
