Hide / Unhide

Aug 31, 2005

I created an app., for tracking changes, where once the user is logged in , the login form is hidden.
When a user modify the status of a change, i cretaed an event procedure in the update before. In that event procedure i am opening a new form to ask to continue or not and then i hide it. When the program comes back to the form where the event procedure is, it closes the hidden form, which asked to continue or not. The problem is that it closes the login form as well.
To sum up:
-Login form is hidden
- Edit form calls Confirm form
- when user comfirm, teh comfirm form is hidden.
- Edit form, close Comfirm form and also login form. (i dont want to close login).

Here is the code to close comfirm form in edit form....

DoCmd.Close acForm, "comfirm"

thank you, max.

View Replies


ADVERTISEMENT

Hide/unhide Menu Bar

Dec 21, 2005

I did hide the menu bar,

Tools->customize....

but how can I unhide the menu bar, because hide/unhide option is on the menu bar. If I hide it, then I cannot unhide it.

View 4 Replies View Related

Hide/unhide Txt Fields

Oct 16, 2004

This is complicated!
I need to be able to have user run 5 different queries,
I think, and have the results from those queries show
up one under the other on one form footer.
Ex. fld 1 fld 2 fld 3 Date Range
fld 1 fld 2 fld 3 Date Range
fld 1 fld 2 fld 3 Date Range

Each of the rows would be based on a different query.
Also,
part of the query has a date range, and I would like
to have the Date Range from query show up next
to each row.

Thanks

View 1 Replies View Related

Hide/Unhide Database Window With VBA Code

Oct 6, 2006

Hello,

I woul like to programatically (with VBA code) hide and unhide the database window.

In Access 97, this can be done with Tools > Startup > Display database window box (check/uncheck).

But I would like my program does that himself : when the user launches the application, the database window should be hidden and when he leaves, the database window should be shown again.

Thanks.

View 9 Replies View Related

Using Buttons To Hide / Unhide Navigation Pane

Jul 22, 2014

I would like to hide/unhide the navigation pane completely by using two buttons (pop the hood & close the hood) in a form. At this moment I used the following code:

Private Sub Command77_Click()
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
End Sub
Private Sub Command78_Click()
DoCmd.SelectObject acTable, , True
End Sub

This however makes my form shut down and not my navigation pane.

View 6 Replies View Related

How Do I Unhide My Database? :(

Jan 15, 2005

Yes...I am a newbie. In an attempt to secure my database, I accidently hid my entire datebase from everyone, including myself. How do I "unhide" it if I can't see it? I know that there is a really simply answer to this problem but I haven't found it yet. Please HELP!

View 6 Replies View Related

How To Unhide A Form

Mar 25, 2015

In what I believe is called the Navigation Bar - the bar at the left of the Access screen, one can see the various tables, queries, forms and modules associated with a project. As an experiment, I right-clicked on a form, and clicked the option "Hide in this Group". Now it doesn't show up in the group. But I can't figure how to get it back. I assumed there was some sort of unhide command like in Excel. If there is such a command in Access I can't find it. How do I make it so I can once again select this form so I can open it in design mode. (I assume that the form still exists in the project, because I didn't delete it).

View 2 Replies View Related

How Unhide Database Window

Sep 13, 2006

Dear Friends I made my a stupid mistake and I don't know how to rectify it.

There is a inventory software built in access xp. In order to protect database I've cleared all the options from that is

a) Display Startup form
b) Display status bar
c) Allow Full menus(Changed with Custome Menu)
d) Allow Default shortcut keys
e) and foolish thing cleared Use special key also

I've given a task to modify program where I may have to add New form. I don't know how to unhide database window. pls suggest me what to do....

View 2 Replies View Related

Unhide Query Field

Apr 24, 2008

Ive set a formula within a query field to hidden, and i cant seem to get it to display again, i have gone to tools>options>view and checked view hidden objects but still nothing

any advice?

View 2 Replies View Related

Disable Window Unhide

Apr 8, 2008

I have a Access database that is used as the user interface for general users but the data is stored in SQL. My client has asked that general users be able to see only selected fields in the table. This means that they must only use the form to view records and not be able to get to the table.

How do I disable the the Window Unhide in the MDE?

View 2 Replies View Related

Unhide Based On Previous Value

Aug 18, 2004

*Disclaimer-I am a self-taught Access developer, so please bear with me*

I have been handed the task of developing a database to keep track of active and terminated security badges. I have a form that displays certain data for each employee. I have a check box on the form that signifies if the employee is active or terminated. The 'Term Date' box is on the form, but is currently disabled. I have been trying to find a way to have the 'Term Date' field enabled if the 'Active' checkbox is unchecked so that a termination date can be entered. Any suggestions? Please help!!

I don't know enough about Access to determine if this is possible, but I also was wondering if it was possible to reverse the action if needed (re-check the 'Active' checkbox and re-disable the 'Term Date' field)

I'd greatly appreciate any help that anyone can provide!!

View 6 Replies View Related

Hidden Menus On Startup - How To Unhide

Jul 23, 2007

Hello,

I have hidden most of the menu bars for my database (from the tools.. startup.. menu) and I dont have a backup of my latest database (yes, I know, stupid.) The only menus I have are File, Edit, Insert, Records, Window and Help. The database window is also not displayed.

How do I get them back..? My database is set to load a form on startup, all data is accessed via a set of forms linked from the first. I cant access the tables, design view, anything. I feel like such a muppet...

Help!!

View 8 Replies View Related

Menus Hidden On Database Load - How To Unhide

Jul 23, 2007

Hello,

I have hidden most of the menu bars for my database (from the tools.. startup.. menu) and I dont have a backup of my latest database (yes, I know, stupid.) The only menus I have are File, Edit, Insert, Records, Window and Help. The database window is also not displayed.

How do I get them back..? My database is set to load a form on startup, all data is accessed via a set of forms linked from the first. I cant access the tables, design view, anything.

Help!!

View 2 Replies View Related

Queries :: Access 2010 - How To Unhide A Query

May 7, 2013

I hid a query and now need to modify the fields, how can I unhide the Query in 2010?

View 1 Replies View Related

Modules & VBA :: Open Form And Unhide Labels?

Mar 5, 2014

I want to be able to open a form and unhide some fields on that form that have been set to hidden, basically if the file paths are wrong it ponts them back to my form where they fill them in , normally these are hidden

Code:
'checks to see if the file paths in the admin screen are ok before allowing to go foward to avoid errors from dowloading data
'get the file path to import data
Dim ImportLoc As String
ImportLoc = DMax("[Path]", "TblsysTransImport")
'Gets the file path to export data
Dim ExportLoc As String
ExportLoc = DMax("[Path]", "TblsysTransExport")

' checks to see if the file path is valid to stop people going further if incorrect or first time use If Dir(ImportLoc, vbDirectory) = "" Or Dir(ExportLoc, vbDirectory) = "" Then MsgBox "sorry but your Import / Export locations dont exsist " & vbNewLine & "These are required so you can download your scan data. " & vbNewLine & "You will now be redirected to enter valid paths"

'open form where they update the paths
DoCmd.OpenForm "Frmadmin", acNormal
'normally hidden
Frmadmin!Line111.Visible = True

i tried to use Frmadmin!Line111.Visible = True

but it says object required (line111 does exist?)

View 3 Replies View Related

Forms :: Unhide - Always Show Form From Template

Jan 11, 2014

I downloaded a time clock template the other day and Ive been tweaking it for a while now. There is one thing I can't figure out:

There is a form called frmClockOut, which is a subform on frmClockIn.

This subform appears after the ClockIn button is clicked. The problem is, if I close the database for any reason, and leave someone clocked in, the ClockOut button does not appear until after you re-click ClockIn.

The developer has put in a safety so that it does not "double-punch" someone in or out so its ok there. Id just rather keep this subform open or always showing and cannot figure out where its done on here.

I will upload the blank template that I tweaked.

View 3 Replies View Related

Unhide / Unlock Normal Access Table View And Menus

Oct 11, 2007

Hi..

I got a access file from a friend of mine, but when i open it in access, i don't see any tables or the standard menu buttons.

The only menu i see, is a docked menu with a couple of submenus, wich in turn open forms, where you can enter data..

How can i see the tables and bva script behind this access file?

I tried F11 and Alt-F11, but is does nothing.

He won't tell me how he did it, because he doesnt like to share what he knows...

Can anyone help me??

Thanx !

View 6 Replies View Related

Forms :: Unhide Form Tab Controls Based On Drop Down Selection

Sep 15, 2013

I have tab control form with (5) tabs. For this discussion - Tabs 1 through 5. For a blank (new) form sheet tabs 4 & 5 need to be hidden. Based on what is selected via the drop down box (on tab 1) then tabs 4 & 5 may remain hidden or needed to be un-hidden. Example: [DropDown1]

Selection 1: stay hidden
Selection 2: unhide
Selection 3: unhide
Selection 4: stay hidden
Selection 5: unhide
Selection 6: stay hidden
Selection 7: unhide
Selection 8: stay hidden
Selection 9: stay hidden

I think one I figure this out then I can use the 'OnCurrent' event to check the drop down selection as a user selects the a record or scrolls through records.

View 2 Replies View Related

Is There Any Way To Hide A Form...?

Oct 2, 2006

Hi.

I was just wondering if you can hide a form in the windows status bar?

View 3 Replies View Related

How To Hide All The Bars

Jul 28, 2007

How can I remove all the bars specially the menu bar:
File, Edit, View, Insert,...

View 3 Replies View Related

Hide Duplicates

Apr 4, 2006

Goal - Show how many policies (dbo_Policy22.Policy.Number) were cancelled during a certain time period (Invoice Date).

Problem - a policy can be cancelled more than once and I don't want to count it after the initial cancel status (885).

Question - Below is my query. I'm thinking I type "Distinct" somewhere, but I have no idea where.

Please help :) Thank you.

SELECT dbo_Producer22.Number, dbo_Producer22.Name, dbo_Invoice22.Invoice_Date, dbo_Policy22.POLICY_STATUS, dbo_Policy22.Policy_Number
FROM dbo_Producer22 INNER JOIN ((dbo_Insured22 INNER JOIN dbo_Invoice22 ON dbo_Insured22.Insured_Key = dbo_Invoice22.Insured_Key) INNER JOIN dbo_Policy22 ON dbo_Insured22.Insured_Key = dbo_Policy22.Insured_Key) ON dbo_Producer22.Producer_Key = dbo_Policy22.Producer_Key
GROUP BY dbo_Producer22.Number, dbo_Producer22.Name, dbo_Invoice22.Invoice_Date, dbo_Policy22.POLICY_STATUS, dbo_Policy22.Policy_Number
HAVING (((dbo_Invoice22.Invoice_Date) Between [Forms]![PfrmYearToDate]![txtStartDate] And [Forms]![PfrmYearToDate]![txtEndDate]) AND ((dbo_Policy22.POLICY_STATUS)=885));

View 2 Replies View Related

Hide 1 Record

Apr 10, 2007

I was wondering if there is a way to hide 1 record from a query

say I have 3 user accounts and on a form I only want to display 2 of them form the query,so the other record is still present but cant be deleted by accident or viewed

View 2 Replies View Related

Hide Field Value

Mar 22, 2005

I have a form with various fields, two of these fields are "Date Purchased" and "Lease End Date". When there is no value entered originally, I have made a default value of 12/30/9999.

The problem is that when you open the form and these two fields are next to each other, the user says it confuses them seeing a date even though it is a dummy date.

Is there a way for me to create a expression that will be something like:

IIf(DateField = 12/30/9999, Me.Datefield.Visible = False, Me.Datefield.Visible = True)

or VBA

Private Sub Form_AfterUpdate()
If Me.DateField.Value = "12/30/9999" Then
Me.DateField.Visible = False
Else
Me.DateField.Visible = True
End If
End Sub

If have tried both ways and neither works.

View 1 Replies View Related

Hide Record

Jun 8, 2005

Is it possible to just hide a record? My form is based on a query so I know I could remove the record that way but I also have a box that calculates a average time, so the data that is produced by that record still needs to be taken into account. I want to hide some records pureley so the user dosent have to keep scrolling thriugh loads of records. Is it possible to do this?

View 9 Replies View Related

Hide New Record Row

Jun 28, 2005

I have a continuous form "components" where the data is added by a query. There is no need to manually add records to the form, I just want to edit certain fields.

Is it possible to hide/disable the blank "new record" row at the bottom of the form?

I tried setting the form's "Allow Additions" property to no, but the line still appears.

Thanks for your help!

Frank

View 3 Replies View Related

Hide Buttons

Nov 23, 2005

Hi,
I can hide buttons on a form but what I want is to hide/ show it when one of the fields has a specific value.

Cheers

Gordon

View 4 Replies View Related







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