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).
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 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 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]
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.
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....
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!
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....
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
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.
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?
*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!!
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...
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.
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 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.
Basically I have a Customer Form, which I have a New party button on it,this button opens up the party form to a new party, what I would like it to do is open up a new party but make the new party for the customer I had selected in the previous form.I have tried the GoTo macro's but cannot seem to get it to work.
I am thinking on clicking the button it will need to get the Customer ID, and then open the party form, create new party, and paste in the Customer ID, which then updates the Name - Date - Address - Company Fields.
I have been tasked with creating a tool to analyse mobile phone bill data and present the analysis, and our recommendation, to a customers. Being new to Access (other than basic tuition) this has been a slow uphill task, which is finally nearing completion, however there is a problem which I have not yet been able to overcome.
The requirement is for the DB to open first on a splash screen (lets call it Form A) with fancy picture where our customer is selected from a combo box, the customer is then telephoned, a linked computer screen is established and our staff then click "Go" to proceed to a second form (Form B) showing an account overview and more details.
The problem I have is when "Go" is clicked, the second form loads via on click event, and even populates the correct customer in its combo box. Unfortunately that is as far as it gets - the combo does not look up the information. The customer needs to be selected again for the subforms and subreports to load with the customer overview. To clarify, form B just sits there blank until the customer is re-selcted from the combo box in form B.
On the form: User enters first name, then last name. Upon updating the last name field, I would like another form to pop-up and display all the people with that same first name and last name that the user just entered.
On the pop-up form: All of the matching first names/last names are listed with a button control beside each record that says 'Select'. The user clicks the select button beside the record he/she wants. This pop-up form closes and all of the data from this selected record is now showing on the original form.
So far, I have a query/form that pops up only showing the matching first/last names. I'm having a hard time getting my original form to auto-populate with that record that the user selects on the pop-up.
(Also my main form is actually a sub-sub form - so in my trials I could've been massacring my syntax trying to point to it.)
I am trying to create a user form with sub form using the form wizard. I have only 2 tables, Employee (main table) and Vacation (subform table). I pick the fields from Employee Table then fields fro Vacation, but the wizard treat the Vacation as main form and Employee as sub form.
I have a fault form which the user enters details of a fault. When the fault form is submitted the data is saved in the relevant table and the form is cleared so that the user can enter the next fault. On the fault form i have a subform which displays the faults previously entered by the user. I want the user to be able to click on an entry in the subform and open the orignal fault form and see the data that had been entered. How can i create this functionality??
how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to mimic their code however, it looks like they must be doing something different as there is no on resize code under the form properties and I was unable to find the code they do use.
I have a bound form which is from tblEmployee, I'd like to have a dataset below (like a splitform but not a split as they have limits) so when i search in the box it gives me say all the smiths - i select for example david smith and it displays his information in the form objects above so they can be edited?
I have one table containing name of restaurant with its address etc. Then i created another table to list out the restaurant workers names and details. Just as an example,
Table:Restaurant Restaurant name Address line 1 Address line 2 Restaurant # Website
Table:StaffContact Staff Role Name speciality email phone
I have the main form that has all the restaurant details only. And i have another form containing the Staff information. Please note the two table have a relation and it works well.
Now to make it user friendly(basically easier for the lazy ones), I dragged the staff contact form on to my main form and displayed it as a datasheet(basically a sub form).
Now, my boss does not want users to add/delete on this sub form(datasheet). So,he wants me to create buttons to open new record of staff for each restaurant(new form)
My issue is with opening a new record to enter a new person to the staff list and give them a role as well in form view.The new form has
So i ran a Macro, with open form with Where condition
