Displaying Menus In Forms
Feb 4, 2006
I have written a DB for work that collects information on a range of events (eg safety incidents, improvement suggestions, etc) and reports on them. I am now trying to improve the security & integrity of the data by restricting user access to menus.
I can use the start up options to turn off menus, etc but want to allow users to use the default right click menu in forms to sort & filter the forms. But I don;t want users to have access to the other default menus (eg the one containg form deisgn). Is there a way to just select this particular menu to pop up on a right click?
Because I have not been able to find an answer to this I tried designing my own toolbar containig the sort & filter commands I needed. I created a custom tool bar using the menu/customisze options and called it "tbarSortFilt".
As soon as I place it in the menu bar it goes "dim" and I cannot select the options. When I over ride the start up options ("shift" key) and then right click in teh form both the default menu come up (as expected) and the "tbarSortFilt" menu lights up -- but is not active.
I have also tried
DoCmd.ShowToolbar "tbarSortFilt", acToolbarYes
to no avail.
Clearly there is something pretty basic I am not doing. How can I use the strat up options to turn off toolbars and then show AND activate my customized toolbar?
Regards Stephen :confused:
View Replies
ADVERTISEMENT
Sep 9, 2005
Hi
with the help of this site, i have made big advances in learning and adapting code, in building my access FE on an SQL BE.
however, i have a problem, i cant find any information on in how to resolve.
i am using menus to navigate between forms, but i cannot synchronise the critical value between the forms.
so i am on a form with critical value, say hullID
i use a menu command to open another form, but i need the form to open with the same hullID as the critical value as the previous form which is about to close.
because i can go to the new form from any form, using the menu command, i cannot directly link the critical value,
is there a way to use the critical value from the current focus form, to the new opening form
many thanks in advance
View 8 Replies
View Related
Jul 24, 2014
I have made a database. I have gotten to the point where I use a form to get the information. I am trying to get the information to auto populate fields after using 3 drop menus. They are department name, shop and shift. All of the information comes out of tbl department name, tbl shop and tbl shift.
I also have a table with department name, shop, shift, line, employee total, shift leader total, ratio of shift leaders per line and total employees off. I am trying to figure out once use the 3 drop down how can I Auto populate the remaining fields. Also I am trying to figure out where and how to put in the code.
View 1 Replies
View Related
Sep 24, 2013
I recently completed a db for a client and they have since asked that the access window be hidden for certain types of users.This I did using
Code:
ShowWindowAsync Application.hWndAccessApp(), SW_HIDE
if a relevant user opened the db. All well and good, except they then wanted to be able to see the Access link in the taskbar (which SW_HIDE doesn't do) - so I changed it to SW_MINIMISE and they were happy again until..They then realised (and it was a surprise to me as well) that the right click context menus used to filter and sort continuous or datasheet forms were no longer available to these users - nor was the context menu for datasheet columns to freeze or hide columns - see attached.
I've experimented with a number of options and these context menus are available if ShowWindowAsync is not called or if called with SW_HIDE, but not for SW_MINIMISED, SW_SHOWMINIMISED, SW_SHOWMINNOACTIVE, SW_SHOWNOACTIVE.
Why the shortcut menus are not available when the Access window is minimised? The requirement being that the context menus are available to all users the Access link appears on the task bar for all users the access window is hidden for some users.I should say that due to hiding/minimising the access window all forms are popup and modal.
View 1 Replies
View Related
Oct 1, 2014
I have a table that holds the ID to another table where I pick up the name to display instead of the ID. If a name is added or changed then the ID needs to be added/updated.
The name (and other details) are displayed on a form from 1 to ,many rows.The field that holds the name is a combo box and I can change that field by selecting the bane from the combo box or typing the name in. What I want to be able to do is type in the ID (I'm actually scanning it in from a bar code) but display the name. How do I do this.
As I say this currently works if name is typed (Or scanned in)and the ID is written to the table.On the data tab for the field I have as the control source the ID itself. In the Row Source I have select 5 fields from the second table which includes the ID and name (both from 2nd table). The Bound Column is set to 1. In the Format tab Column count is 5 and column widths is set to 0cm;3cm;0cm;0cm;0cm. This allows the name (2nd column) to be displayed. But the 1st column to be stored on table 1. However I can't scan in the ID which I want.
View 3 Replies
View Related
Jun 7, 2013
I have a DVD movie table and a lookup table for the movie genre. One selects the movie genre by opening a combo box which has the values. (Movie typeID which is a number and MovieType which is a text.The records are being displayed in a Access 2010 split form with the datasheet on the left. Any editing can be done on the right or the single record side.I would like to only display the genre for that movie as opposed to the combo box which can be edited and next to it have a command button to open a form in order to change or select the genre for the existing or new DVD.So, I guess what I'm asking is how do I display the genre fo that particular movie?
View 6 Replies
View Related
Oct 18, 2005
Database description
I have one to many relationships between tables related with PersonID. From the entry forms I enter data and there is another form to search data. The data search form displays some 5 fields from different tables: first name, last name, phone, email...
Problem description
When I enter new data in all the above named fields, then the search engine can find and display the new record. However, when I leave blank some of the fields, let's say, the phone field, then the search does not display the entire row, although the first and last name, for example, exist in the appropriate table.
I would appreciate, if anyone could help me to solve the problem.
Thanks
View 1 Replies
View Related
Dec 5, 2013
I have a database which creates hyperlinks to a network folder full of images (too many to attach to the database) but I can't figure out an easy way to show those images in forms and reports. I think I'm 90% there, looking online I figured out that if i create a text field (not a hyperlink) in the original table and copy over the hyperlink text, I can use this as the control source of an image control (with the picture type set to 'linked').
That works fine, but I would still have to manually copy over the URL every time I link to a new picture - so is there a way i can get this to feed through automatically?I've tried a couple of ways already (calculated fields, 'set value' macros) but the problem is anytime I try to get clever, Access doubles the link address, making it utterly useless as a control source.
So for example, i ran a macro to set the text field value to equal the hyperlink value of c:mydocspicture.jpg,
and the result looked like this c:mydocspicture.jpg#c:mydocspicture.jpg#Or maybe there are functions similar to excel (like 'left' and 'len') which i can use to extract the right part of the hyperlink.
View 6 Replies
View Related
Aug 28, 2013
I have been given a form that you pass a parameter into and on the basis of this it performs certain amendments to the particular data AND also runs 2 stored procedures on this data. I need to get the data to display on the form so that the user can visually verify if it is the correct data and then they will on click to execute the amendments and stored procedures.
I cannot get the data to display on the screen? I have tried to create a variable in the VBA code to store the data in and then used a message box to try to display it but to no avail?
View 3 Replies
View Related
Mar 26, 2013
I've created a form with a combo box to allow users to set the Manager of an employee. I've set the control source for the combo box to the Managers table that contains a primary key and the manager's name.
I've set the bound column to 1, the column count to 2, the column widths to 1;2 (I want to show both columns in the drop down because users can identify managers by either their name or Manager ID).After updating the combo box, the Manager ID shows rather than the Manager Name. Is there a way to have the Manager name show instead of the Manager ID without setting the column widths to 0;2?
View 5 Replies
View Related
Aug 20, 2013
I have a form where users can look through different records as well as add a new record through a control button. When a new record is added, all the relevant data should end up in the corresponding back end tables.
The problem I am having is that some of the new records I am adding work perfectly (sync with the tables, etc). Other records, however, are showing up in the tables but not in the actual form. For example, when I attempt to search in the form for the record name, nothing comes up.
The Datasheet View is set to No, so it's definitely not that. I'm not really sure where else to look - the new records appear in tables and the report I have linked to the form, they just don't all show up in the actual form!
View 3 Replies
View Related
Jun 5, 2014
how to make a text box on a form display the record number so it can be seen along side record selector buttons.
I'd rather have my own then use the record selector option that displays at the bottom of the form when enabled.
View 4 Replies
View Related
May 30, 2013
I am building a form and part of the code is:
Code:
Private Sub Form_Load()
lblSalary.Caption = "Enter Salary"
txtSalary.Value = "5000.00"
cmdIncrease.Caption = "Increase Salary"
End Sub
The problem I am having is that I dont understand why the cmdIncrease button does not display "Increase Salary" when the form loads. The button is there but it is blank. The lblSalary button displays "Enter Salary" with no issues.... and I do not have "Enter Salary" in the caption property window... only in the coding window but it still works.
View 6 Replies
View Related
Jul 3, 2015
I have a situation where I use the output of a combobox in a query. When I run it everything is fine.Now I want to make a summary of 9 of these text fields in the query. However, when I do this only the bound columns show up in the summary field. I can't get a summary of the second columns of the combo in the query.
I have been using the following successfully with regular text fields:
Summary: [Comodity] & "," & [Comodity1] & "," & [Comodity2] & "," & [Comodity3] & "," & [Comodity4] & "," & [Comodity5] & "," & [Comodity6] & "," & [Comodity7] & "," & [Comodity8] & "," & [Comodity9]
View 9 Replies
View Related
May 7, 2013
I have two synchronised combo boxes that are working brilliantly except for 1 thing.
The two boxes are Site and Building. I find a site from the Site box dropdown and only the buildings for that site are shown in the Buildings box dropdown. Perfect!
However, I have got 3 fields showing in my Buildings dropdown.
Private Sub cboSite_AfterUpdate()
Me.cboBuilding.RowSource = "SELECT BuildingName, BuildingCode, Status FROM " & _
"BuildingT WHERE SiteID = " & _
Me.cboSite & _
" ORDER BY BuildingName"
Me.cboBuilding = Me.cboBuilding.ItemData(0)
End Sub
that is BuildingName, BuildingCode and Status.
All three show in the dropdown
BUT
only BuildingName shows in the actual Building Box and I would like all 3 to be visible once I have decided on the building name I need!!
Can this be done by changing
Me.cboBuilding = Me.cboBuilding.ItemData(0) (as above)
to
Me.cboBuilding = Me.cboBuilding.ItemData(0), Me.cboBuilding.ItemData(1), Me.cboBuilding.ItemData(2)
or something similar??
Or do I need to create 2 new boxes to return the other values?? I am so close to achieving what I want with this form!!
View 3 Replies
View Related
May 15, 2013
I have a form with some tabbed subforms. Master/Child links are set, everything is bound. When I open the form to display records (based on search criteria on the switchboard form), let's say it returns 6 records for someone, they are sorted by date and so the newest would display first.
But when it opens, the main form shows all the appropriate data, but the subforms don't show at all. Just a blank box where the subform control should be. If I click next record (and any thereafter) they all display correctly immediately. Now if I go to the 2nd record, then back to my 1st record, it displays correctly.
I'm guessing it must have something to do with the onLoad event of either the main form or subforms, but I don't have anything in there for OnLoad....no code at all.
View 8 Replies
View Related
Apr 13, 2015
I have 3 tables:
tblAnagrafica
TabellaPIP
TabellaJoinPIP
By wizard I have build a form that collect data from a query: "QueryPIP2Tabelle"
The main Form :" frmtblAnagraficatest"
display correct data from tblAnagrafica,
BUT the subform: "frmTabellaPIP Sottomascheratest" does not display data from TabellaPIP.
Relations are many -to-many but, because it's my first building database, can be incorrect.
Database1.accdb
View 2 Replies
View Related
Aug 5, 2014
I have six textboxes in my form. First 5 textboxes have dates ( MMDDYYYYY). In the sixth textbox I need to display the minimum date among these five dates.
View 10 Replies
View Related
Oct 7, 2013
I'm trying to place a picture on my forms using a browse button code i found on the net. After picking a picture, the image won't display automatically during run time, i still need to select design view and finally form view just to display the image. Im using the events form current, and the text box afterupdate.
View 1 Replies
View Related
May 9, 2013
So i have a combo box that has a criteria set for the query. I have a search button that runs the query that users click.
What i need to happened is i want the results displayed in the sub form the when query is ran.
View 7 Replies
View Related
Jul 30, 2013
I am designing a book collection database where each book can contain multiple authors. I used three tables; tblBooks, tblAuthors, tblBookAuthorJOIN. The tblBookAuthorJOIN allows me to create a subform with drop down combo boxes in the Books form linking multiple authors to each books indexed field. The Author table contains the usual FirstName, LastName, MiddleName fields. I would to be able to display the names of each author in the forms header but I am having difficulty.
For example a book may have two authors such as:
Authors table would contain values such as
Last Name: Grisham
First Name: John
Last Name: Twain
First Name: Mark
Textbox in header would display: John Grisham; Mark Twain
The authors would be displayed in the following format in the same order as listed in the subform datasheet.
Attached is a graphic of the form.
View 3 Replies
View Related
Jul 10, 2013
Access 2013 People,where the command buttons are not displaying properly?Notice the words and images are nice and centered in the buttons. The buttons are all the same size.Now look at the same DB in Access 2013:
See how the buttons look bloated and the images and wording are not centered anymore. And working on it in design view is a nightmare! When you try to move the command button part of it is left behind every time to try to move it.You can turn the themes property to "Off" but I like the themes.
View 11 Replies
View Related
Jun 27, 2013
I have a number field in my subform that's autoupdated but I'd like it to display "weeks" beside the number without trying to store it, is this possible?
View 2 Replies
View Related
Oct 15, 2013
I am trying to create a form where I store the literacy and numeracy results of a group of students. So far I have designed a form which gives me a tick box as to whether the test they took was literacy or numeracy, then a box where I enter the score. Literacy tests are scored out of 72 and numeracy out of 50.
what I would like to do is write something that shows the literacy numeracy levels of each student after each test. So for literacy, the score ranges are as follows:
0 - 13 Below Entry 1
14 - 32 Entry 1
33 - 52 Entry 2
53 - 65 Entry 3
66 - 7 Level 1
What I would like to be able to do is tick whether or not they sat a literacy or numeracy test, enter the score and the db to come up with their level and display it on the form.
View 1 Replies
View Related
May 21, 2013
On my form I would like the user to be able to select a company, and once the company has been selected I would like a box to display all the contact information for the specific company. I would also like this box to record the contact information onto my database along with the other information that will be gathered on the same form.The Contacts and Companies are linked with the COSYSNO and CoSysNo fields.
View 1 Replies
View Related
Jun 25, 2013
I am on code want to display records on the form by order_number, but i am unable to do it.
Private Sub Combo63_AfterUpdate()
Dim rs As DAO.Recordset
Dim intcount As Integer
On Error GoTo ErrorHandler
Set rs = CurrentDb.OpenRecordset("SELECT * FROM Master_Log WHERE Order_number = " & Combo63.Value & "", dbOpenSnapshot)
[Code] ....
View 6 Replies
View Related
