Topics Search

Show/Hide Form

Show/Hide Form
Views: 7
I am trying to setup a customized Time Entry system. Anything advanced that I've figured out how to do in Access over the last 10 or so years is self taught so I wonder at times if there's an easier/better way. Like now. I'll apologize in advance if I'm confusing or not giving the right info.

I have two different time entry forms. One or the other of these forms should be visible or hidden on the main form (frmHRDB) depending on the value stored in the "TSType" field. I have code to set the 'visible' property of the two forms.

My problem is that I've attached this code to several different controls on the form so that whenever a control is clicked or whatnot the form's visible property is correct regardless of which employee is showing. But as I add more controls I'm going to have to add this code again and again. I know this can't possibly be the correct/best way to do this.
Sponsored Links:

Similar posts...


Hide Access and show only my forms

Hide Access and show only my forms Icon
How can I hide the main access window and have only my projects form show up, looking like a standalone app.? I'm using office 2010 x64 on a windows 7 system

Hide/Show Columns based on DropDown Selection in Form

Hide/Show Columns based on DropDown Selection in Form Icon
I have few fields that show up in datasheet view on a form. My first field has dropdown boxes with selections that user can choose. Based on the selection, I'd like some columns to hide or show.
For example, if user chooses "Work Type A" from my first column, Columns H thru J will hide and therefore, only allow user to fill information in the the showing columns.
I want to do this becaues there are a lot of work types users can be working on that each have their own set of fields to fill out so I only want the ones that apply to that work type to show.

Show/Hide Combo box

Show/Hide Combo box Icon
Does anyone know the syntax to hide a combo box on a form if it is opened in edit mode? I am not sure if I should hide the combo by default and make visible in 'Add' mode or to leave it visible and hide in 'edit' mode.

I am using the MS switchboard to control form access, I am assuming it will be on the forms 'onLoad' event ?

hide checkbox in a form

hide checkbox in a form Icon
I am trying to hide some labels and checkboxes in a split form through onClick, it works fine but when I tried to do the exact same thing in onCurrent, it made the checkboxes unclickable, but didn't hide them

Hide or Unhide Fields in Query using VB

Hide or Unhide Fields in Query using VB Icon
Is it possible, using VB, to create a show/hide control for a query similar to its show box?. This query will be exported to Excel, so, a Form control is not a solution

Hide Navigation buttons of Main Form

Hide Navigation buttons of Main Form Icon
Is there any way to replace the navigation buttons of main form (frmMain) with the navigation buttons of the continuously sub form (fsubStudents).
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

Show / Hide Datasheet Columns in a Subform

Show / Hide Datasheet Columns in a Subform Icon
I've got a main form with two lists boxes. I want to show the visible columns in my subform (which is a datasheet) in one listbox and show the hidden columns in the other. Also I want to allow the user to hide / show columns using right or left arrow buttons between the list boxes. My subform is bound to a stored procedure using ADO.

Show/Hide Columns in a Query

Show/Hide Columns in a Query Icon
How can I show/hide a column in a query?. I mean i.e., I need a form with a check box for column X in a way that if I check or not the box, my query come up with column X show/hide after a click button

should i hide a form or make it modal

should i hide a form or make it modal Icon
I develop apps for a company and up until now I have been using modal forms to keep the most resent form open on top I have recently learnt how to hide the access window and keep the forms visible using popup quite neat to be honest.

My reasoning behind this is staff here use many apps but when I present them with an app that is built using ms access they think they cannot use it as for some reason in their heads it is harder to click a button using a ms access app than to click a button using a non ms access app. (PS if you hadn’t caught on my staff are incompetent and need to be shot several times in the back of the head.) So hiding the ms access window and using the popup property allows me to trick them in to believing it is just as easy I.e. I don’t tell them it is a ms access app.

In doing this now that there is no container to hold the forms that open one another depending on their function and I am wondering which would be a better practice in using Multiple.

1. Would the better practice be to show and hide forms as they open and close? I.e. the switchboard opens another form then I hide the switchboard and when that form closes I show the switchboard again.
2. Or would the better practice be not to hide any forms and just use modal property as I have been doing up until now?

Show or hide text

Show or hide text Icon
I have a access database. Sometimes I don't have any data to show in a column is there a way that is can hide that columm en show if there is data for it?