Modules & VBA :: Main Form On Open Event To Show Tabbed Controls Only If There Is Data

Jul 24, 2013

I have a report that tracks scores for our employees. From the report, you can click a button to add a new score in a form or edit an existing score(frmscoretracker). On this form there are two subforms, in a tabbed control to track additional information about the score; what areas were marked down(Trends), and was it a failing score(AutoFail).

When this form opens I have it programmed to only show the subform if there is data in it. The goal being, if I am adding a new score and there is no existing trends or Autofails for this new record, neither subforms will show - I will add an after update even to show either trends or autofail depending on the score recorded. Also, if someone chooses to edit the score, whatever subform with data, will show as well.

When someone clicks to add a new score, opening this main form to a new record, both of the tabs show. However, if the form opens to an existing record, the appropriate tab shows. Here is the code

Code:

Private Sub Form_Open(Cancel As Integer)
'If the subform has a record, the tab is visible, if not, the tab is not visible
If Me.frmtrends.Form.Recordset.RecordCount > 0 Or IsNull(Me.Trends) Then
Me.Trends.Visible = True
Me.TabCtl33.Visible = True
Else
Me.Trends.Visible = False
End If

[code]...

Both tabs are set as not visible in the default settings. Is there something in this code that is triggering then to be visible when there is no record in the main form?

View Replies


ADVERTISEMENT

Modules & VBA :: 4 Unbound Controls Require Data - Validation Event Triggers Without Command Button

Aug 13, 2015

There are 4 unbound dropdown list box that will have a default value of empty string. All 4 must have values entered (data is required).Once all 4 are required - the bottom 5 text box will become enabled (optional data).Forcing the user to click on a Validation Button

Some users type then use the mouse to select the next.Other users type to select then tab.The trick is: After filling in the 4th listbox and validating all 4 have values, the event must trigger code to enable the 5 optional text boxes below.This provides a seamless data entry environment.

I have been doing this in other places, but the transisition after the last required field is complete gets ugly.If Trim(cmbBoxname1 & "") = vbNullString ' check all 4..If it is the 4th one, the event seems not to happen quick enough for the bottom 5 text boxes to be enabled so the user can continue with data entry.

View 9 Replies View Related

Forms :: Locking Main Form Controls Causes Data In Subform To Disappear?

Dec 12, 2014

So I am creating a Complaint Tracking Database with Access 2013. In my 'complaint entry form' I have added to ability to "Open" and "Close" the complaint. While the complaint is open the user is able to enter/edit data in the complaint (new or old). When the complaint is "Closed" (done so with a button on the form that prompts the user to enter a date of their choice) the user should not be able to enter/edit data in the given complaint. In my original thinking, I placed checks on various events (on load, after update, on click) that checked to see if the current complaint had a date in the "Close date" field.

If the close date field was null then that meant that the complaint was open and the the controls would NOT be locked. If the close date field was NOT null (i.e. a date was present) then the complaint was closed and the main form fields were locked but the data was still viewable and unless they "re-opened" the complaint they could not change the data.

Now, in the complaint entry form, I have a subform that acts as a action tracker that is used by the user to keep track of the actions taken on the complaint (i.e. they requested documentation from such and such on this date..etc). My problem through all of this is upon closing the complaint and locking the main form controls, my subforms data just vanishes! At first I figured the problem might be with the linking of master and child fields, so I made sure that I left the ID in the main form unlocked when I loop through my controls during the locking process. This did not solve my problem. Code below:

Private Sub Form_Load()
Dim ctl As Control
If Not IsNull(Me.close_date) Then
Me.FormHeader.Visible = True
Me.btnClosed.Enabled = False
Me.btnOpen.Enabled = True
For Each ctl In Me.Controls

[Code] .....

View 3 Replies View Related

Forms :: Unbound Form With Tabbed Controls?

May 31, 2015

I have an unbound form with 2 tabbed Controls on it.On the first Tabbed Control my command button code works but not for the 2nd tabbed control. Although the command buttons themselves work as far as going to the appropriate record.

What I mean by this is that I use code to enable/disable the command buttons depending on what record you are on.

Example: If there is only 2 record, the other command buttons will be disabled, Do I have to refer to the Tab Control ?

View 1 Replies View Related

Modules & VBA :: Main Form Load Event Firing On Application Quit?

Aug 6, 2013

I'm developing in Access 2007 and created a runtime version.

When the user clicks the X to close the runtime application, the main form's Load event fires. Any clues as to why this might be? Some of the code is based on other forms that do close, so of course errors start flying. Note, this is only in the runtime version; the accdb file works just fine.

My current workaround is to put the offending code into the forms On Current event, which I'm able to do in this context.

Is it wrong to think that a forms On_Load event shouldn't be firing when the application is closing?

View 1 Replies View Related

Why Is Main Form Update Event Triggered When Subform Dirties Main Form?

Dec 1, 2005

I have a subform which makes a change to a field on the main form. When focus is returned to the main form, the BeforeUpdate and AfterUpdate events fire. Why? I thought from the form's perspective, the subform is just another control.

BTW, I get the same behavior if I modify the field from within the Exit event of the subform control.

In either case, the main form's Dirty event is NOT triggered.

View 2 Replies View Related

Modules & VBA :: Return A Value From A Separate Query / Have To Show Up In A Field On Main Form

Jun 28, 2013

I want to return a value from a separate query and have that show up in a field on my main form. The field name from the query is "Six Month Date" and the query name is "DT6Monthqry". I want to return the value displayed in the"Six Month Date" from the query, matching the CustomerID in the query result to the CustomerID that is being displayed on the main form. The CustomerID is a text field.This is the code I placed in the Control Source property for the field I want to be displayed on the main form:

=DLookUp("[Six Month Date]","DT6Monthqry","CustomerID=" & [CustomerID])

The result of this displays a flashing "Error" in the field, even when I go to a Customer that I know has a result in the "DT6Monthqry".

View 8 Replies View Related

Forms :: Adding Subform To Main Form As Another Tabbed Page

Jun 25, 2013

I am modifying an existing form that has some tabbed pages(subforms) in it and I am wanting to know how to add another page. I have created another subform that I am wanting to add to this main form as another tabbed page.

View 1 Replies View Related

Modules & VBA :: Open In Main Form The Oldest Case Taken From Query

Jul 7, 2015

I need to make a query that will show the oldest cases and then open this one in the main form. It will be possible that there could be several cases with the same date. For example the query runs and the results are 7, how could I get one of those cases in the main form.

The idea is that a person will click on a button called "next case", the query will run and then it will open the case in the main form.

How to get this started?

View 7 Replies View Related

Forms :: Applying Quick Filter In Main Form Causes Data To Not Show In Subform?

Sep 3, 2013

I have a pretty simple form that includes subform. Subform's table is linked to main form's table with parent/child relation. Connecting fields are main table's ID field and corresponding field in child table. Subform is in datasheet view. This is pretty basic stuff so there should not be any problems, but every time I apply a quick filter in main form it causes data in subform become invisible. There is single row in subform, but all it's fields are empty.

View 5 Replies View Related

Forms :: Requerying Subreport On Tabbed Control - Show Related Data

Jul 4, 2014

I have a form with a tabbed control on it. The tabbed control has 4 tabs that each have a report on them. When I select a company name on the main form, I requery these 4 reports to show data related to that company.

For some strange reason, 2 of my reports requery with no problem, and 2 of them give me a message that the report can't be found. Here is the code:

Code:
Private Sub cboCompanyName_AfterUpdate()
On Error GoTo cboCompanyName_AfterUpdate_Err
' DoCmd.SearchForRecord , "", acFirst, "[CompanyID] = " & str(Nz(Screen.ActiveControl, 0))

' After selecting a company, requery the subreports to display the appropriate data

' These 2 work

Forms!frmCompanyHistory!RptCompany_Projects_Brief.Requery
Forms!frmCompanyHistory!RptEmployeesSpecificCompany.Requery
'These 2 Fail
Forms!frmCompanyHistory!SubRptCompany_Payback.Requery
Forms!frmCompanyHistory!SubRptCompany_Revenue.Requery

'Other things I've tried

'Forms!frmCompanyHistory!TabCtl66!SubRptCompany_Payback.Requery
'Me.TabCtl66!SubRptCompany_Revenue.Requery

As a side note, if I chose the company, say "ok" to the error, and then go run the queries that these reports are based on, I get the correct records. Also, if I chose the company and run the 2 failing reports standalone, they work fine, so I know the problem isn't the reports or the queries themselves.

I have also checked and rechecked for any spelling mistakes and have found none. I should mention that the error message is "Programs cannot find the field 'SubrptCompany_Payback' referred to in your expression".

View 8 Replies View Related

Modules & VBA :: Set Event Handlers On Multiple Controls

Aug 7, 2013

I am trying to set event handlers on multiple controls in code. This works:

Code:
Me.Controls("txtPosition" & Right(CStr(iLoop + 100), 2)).OnClick = "=UpdateTaskList(" & CStr(iLoop) & ")"

This doesn't:

Code:
Me.Controls("txtPostIt" & Right(CStr(iLoop + 100), 2)).OnGotFocus = "=PostItGotFocusHandler2()"

The second gives an error: "The expression you entered has a function that <databasename> can't find.

I suspect it may be a parameter mismatch, but the normal GotFocus event handler does not take any parameters.

View 2 Replies View Related

Modules & VBA :: MouseMove Event On Disabled Controls

Nov 29, 2013

I'm using a mousemove event to display help text for controls in my form.This works well, but I'd like to display help text when the control is disabled as well (to explain to the user why it's disabled).is there any way to fire a mousemove event when hovering over a disabled control?

View 1 Replies View Related

Modules & VBA :: Click Event To Open A Form And Select Record Corresponding To Value In Unbound Text Box

Oct 29, 2013

I have some code for a button on click event to open a form and select the record which corresponds to a value in an unbound text box. The code is:

Private Sub Command25_Click()
On Error GoTo Err_Command25_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmOpenPatientRecord"

[Code] ....

This works fine when I put in a 10 digit NHS number but opens a blank record when I enter a four digit or six character/digit PatientNumber. Both patient number and NHS number are text fields in the underlying table.

View 14 Replies View Related

Modules & VBA :: Class Event For Multiple Controls On Userform

Mar 5, 2014

Basically I have a class event that works for all controls on any userform.

Its all working fine but I can't add an event to trap the click or mouse move of the userform itself.

Basically so when the cursor moves away from a control the label clears.

User Form Code

Code:
Option Compare Database
Option Explicit
'Define a collection and initialise the commandbutton event class
Private col As New Collection
Private newCmd As New clsEvents

[Code] .....

And here is the class Module

Code:
Option Compare Database
Option Explicit
'catch the event of Commandbuttons
Private WithEvents C0 As SubForm
'Private WithEvents C1 As CheckBox

[Code] ....

View 11 Replies View Related

Forms :: Open Form And Show Specific Data To Display

Apr 1, 2013

I have a form and this form shows some values from one table. One of the fields named as Key. I want to open another form and show the record that has the same value as Key.

I am able to make this with filter but the form opens and when the user navigates the record, it creates a duplicate value in related table.

I want to open form and find specific data to display and then stop at this record.

View 1 Replies View Related

General :: Open Tabbed Form To A Specific Page?

Jan 21, 2014

Can I open a tabed form to a specific page?

If I'm in the form I can move focus by using

Me.[Page 12].SetFocus

but when opening using that code produces and error Page not available?

View 3 Replies View Related

Lining Up Controls On Main Form And Subform

Oct 1, 2015

I have some controls that I want to line up. Some are on the main form and some are on a subform. My questions is how do I do it? I normally

Select all of the controls then click on align and align top and left. Will that work here?

Again some controls on main and rest on subform.

View 3 Replies View Related

Forms :: How To Make Navigation Controls On Main Form

Oct 18, 2013

how do you make the navigation controls on the main form control the subform i.e. navigating through the records or creating a new record???

View 2 Replies View Related

Controls For Entering Information In Tabbed Forms.

Aug 5, 2007

I'm not a complete Access beginner, but I'm also far from an expert and not much of a programmer. So I feel that there's a chance this might be a relatively simple issue I'm merely making more complicated than it should be. But hopefully someone can at least point me in the right direction. (For the record, I'm using Access 2007.)

I've created a form to which I've added three tabbed pages. Each of these pages contains a subform the user can use to enter data into three different tables. The tables' relationships look to be set up properly, and there doesn't seem to be a problem with typing the information into the subforms. However, I want a single button press to update the information across all the tables and clear all the fields in the subforms so that the user can then go about entering the next person. I can't seem to figure out how to do this.

I downloaded a number of template databases from Microsoft, and some of them have exactly the kind of functionality I'm looking for: a "Save and New" button that inputs all the data across the tabbed pages and then lets the user start over from scratch with blank forms. I've spent a fair amount of time studying the various forms in the Student template, but I'm having absolutely no luck replicating that functionality. I basically want everything to work almost exactly the same as that, except with different field and table names (of course).

Can someone please explain what I'm doing wrong and how I might fix things, or at the very least how to look at the Students template database to get the information I need on how to do this myself? I'd be very grateful for any help on this matter. Thanks.

View 1 Replies View Related

Modules & VBA :: How To Get Data From Subform To Text Boxes Of Main Form

Oct 14, 2014

I have an unbound mainform and an unbound subform(datasheet). The source of the subform is a query which is dynamic(I have many queries with diffrent columns). the subform source is change using a combo box selection. I have text boxes in my mainform..how do I get the data from subform to the text boxes of the mainform?

View 2 Replies View Related

Calling A Subform Event From The Main Form.

Sep 27, 2006

I have a main form with a subform. I need to update values in the subform when a field on the main form is updated using afterupdate on that control.

Example:
main form name: mainform
control name: gst (on main form)

subform name: subform
records displayed as datasheet.
records field to update: retail

In main form gst control afterupdate event:
Me.[subform].[Form].retail_afterUpdate

Hoping to call the afterUpdate procedure on the retail field.

Error message:
Method or data member not found.

View 2 Replies View Related

Database With A Main Menu Form Containing A Button That Loads Main Data Entry Form

Jun 24, 2015

I have a database with a Main Menu Form, containing a Button that loads my main data entry form. When the Button is Clicked portions of the data entry form that is loading shows through the Main Form Background (e.g. portions of the navigation bars, and portions of the boarder on the form that is loading.)

View 5 Replies View Related

Sending Click Event On Subform To Main Form

Oct 24, 2004

This may be a really simple problem but it has me stumped. Working in Access 2002, I have a form with a subform (continuous). When the user clicks on a textbox in the subform, I need to capture the value and pass it to the main form so that it can be used to create a filter for yet another subform (not nested) on the main form. How could I accomplish this? Thank you in advance!

View 3 Replies View Related

Modules & VBA :: How To Use Treeview Click Event To Show Pictures In Folders

Dec 10, 2014

I have been looking into populating a tree-view with folders and files, and have found some great examples for doing this, How ever...I cannot seem to work out how to show files/pictures in a form based on the click event of the tree-view.

I have managed to do an onclick event for the files in the tree-view, but I cannot seem to get the onclick event for folders in a tree-view.

Here is an example which I am working on at the moment, but get the error Object variable Or with block variable not set.

Code:
Private Sub tvw_Click()
Dim tClient As String
Dim tParent As Scripting.folder
Dim fd As Scripting.folder
Dim fNode As MSComctlLib.Node

[Code] .....

View 14 Replies View Related

Listing Controls On Open Form

Apr 15, 2006

Dear Friends

How do I list al the controls on an open form including mutiple subforms

Please advice

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved