Form Controls On Navigation Form
I have created a form with some controls on it
I use these controls (Buttons) to open report with specific record , and it is working fine on the form
but when I put this form on Navigation form , the Button is not opening the report and giving me ENTER PARAMETER VALUE to open the report.
I am using the following code on Navigation form:
[Forms]![Navigation Form]![NavigationSubform]![Main Query1]![Job No]=[INVOICE]![JOB] And [INVOICE]![AMOUNT]>0
and and before on the regular form my code was:
[Forms]![Main Query1]![Job No]=[INVOICE]![JOB] And [INVOICE]![AMOUNT]>0
and it was working fine
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I would like to be able to use the same query with every navigation form.
Currently, I am able to get the query to function using or statements using paths to the control on the form passing through each of the Navigation forms.
but I get prompted for data in the same field on the other navigation form before I can get to the report that is intended to be retrieved.
I can see the navigation buttons and the NavigationSubform but nothing else.
When you click on one of the navigation buttons (which are setup as a row of tabs at the top of frmNavigation), a form will be loaded into the navigation subform control.
I have a navigation button called btnDataEntry and when clicked, loads frmDataEntry into the navigation subform control.
This part all works as expected. The problem I am having is that when frmDataEntry is loaded into the navigation subform control, the .IsLoaded property of frmDataEntry remains False, whereas if I open frmDataEntry independently of the navigation form, the .IsLoaded property becomes True...
When the form opens all controls are displayed, without any data in it and locked.
When clicking on a button to enter a new client, all controls must be unlocked, and after entering the new client and hitting the button "Save",
all controls must be locked again, the new record displayed and the appropriate navigation buttons activated.
The same behaviour must be realised when hitting the button to "edit" a record . If for some reason the editing a record or the entering a new record must be canceled, all controls must be locked again and the appropriate navigation buttons activated. .
Is that a possible goal and are these requirements realistic for such a form
I have seen an example for one at TheUAIC.com that seems fairly simple and has some nice features I like:
It has everything for navigation controlled by one form.
It can be used to open/execute everything like – Reports, Forms, Queries, Macros, Code etc.
Once a selection has been made it has an area that explains in greater detail of what the Report, Form, Query, Macro, Code etc. is about.
Documentation can be easily accessed for the selection.
Due dates can be also viewed and edited quickly for the selection.
My question is has anybody used this before or know or other navigation systems for Access that may similar or better that they have used?
And so on for all controls. Form functioned well for months, however today went wild. Navigation order does not execute Event Procedure it follows exactly the order of TAB ORDER DIALOG BOX.
Private Sub Command10_Click()
'On Error GoTo Err_Calculate_Click
'MsgBox (Forms(Me.Parent.Name).Controls("RcptCRDistrict Subform1").Form!RcptNumber)
If IsNull(Forms(Me.Parent.Name).Controls("RcptCRDistr ict Subform1").Form!RcptNumber) = True Then
MsgBox ("Enter Last Name") 'Me.Text8 = 0
Me.Text8 = DSum("Charge", "RcptCRDistrict", "[RcptNumber] = " & Forms(Me.Parent.Name).Controls("RcptCRDistrict Subform1").Form!RcptNumber)
They work great, until I created a navigation form, and now none of the VB works. I assume that now the navigation form is the parent, the former parent is now the subform, and the subform is what? Should I create the forms on the navigation form first from now on to avoid having to change VB based objects
I tried to hide the navigation buttons of main form which contains continuous sub form but it hides for that sub form too.
So, I tried to make my sub form as Single form & then it does show the navigation buttons of sub form but I want to show right on the main form.
Alternatively, can I replace the default navigation buttons with custom navigation buttons?
Please guide me, I really need
When I click OK they disappear. they are there according to properties, although I can't see them because the form will not display while in debug mode.
When the program finishes, the controls that were created are gone. Too bad there isn't any documentation (or any than can be found) that describes how to do this.
Here is the code to create a form and controls (it works):
Then I try to add controls to the form with this (they disappear):
I have placed my own command buttons on a specific tab in the form that I want the users to use to navigate through the records.
However, the problem with the above method is that I really would like the current record out of total records information label/box that comes standard on the navigation form!
Is there anyway that I can easily slap a label or textbox onto the specific tab in question that would display the current record count out of the total records in the database?