Perfect - everything is working as planned. I only had to make a small change to the code entered in the subform. It was easy to fix thanks to all your examples.
Private Sub Form_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Call Form_frmTimeCard.Form_KeyPress(13)
End If
End Sub...
Thanks for your help, this works great when the current focus is in the main form.
What I would like to happen is that even if the current focus is in the subform and I press enter, the next main form is selected. I tried to get the code you gave me to work in the subform, but to no avail...
I have a simple time entry form with a subform that I use to enter the number of hours spent on a project each day of the week. Each new record on the main form is a new work week. Currently, everytime I press the tab key it moves to the next field. The tab key is working as I would like...
I have three groupings each with a header and two footers. The footers and headers contain text boxes that will never be null. For example, the footers contain sumations. The problem is that I want the headers and footers to not print and shrink to zero for two of the three groupings. I've...
Is it possible to create a custom number format so that negative numbers will be displayed in parenthesis on reports? I basically would like the numbers on my reports to look as if the "Accounting" format found in Excel had been used. Currently, all my numbers are formatted as "Standard"...
Is there a way to have the text/control boxes in the header center horizontally on the report each time it is run. Depending on the month of the report, the text becomes longer or shorter (May being short, September being long). Thus, the text appears skewed when the month changes.
For...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.