I have a form, which lists all reports i have available in my dateabase.
But there is 1 report which i dont want visable to users, how do i restrict access to this 1 form, either by it not showing on the list or password protecting it.
users have to double click the report name to open it from the list.
TY in advance
Hi,
I am trying to display data from a table. One of the fields is entered via a combo box. When displaying that data on a form I need to be able to allow items not on the list(created by a select query) to be displayed for this field. The data was created some time ago and it seems that records have been deleted in certain places which has resulted in inconsistent data.
I am happy resticting data entry for new records, but need to allow items not on the list to be displayed for historical data. Data entre and displaying of historical data take place on seperate forms so this is no problem.
My problem is that I am only able to disable limit to list if I make the bounded column anything other than 1 and doing this displays the wrong data!
Am I attempting the imposible or if not, can anyone help?
I have 2 tables. One is Quotation and the other one is Contacts.
In Quotation Table i use a combo box to select a Customer from Customer Table.
Also in Quotation Table a have a combo box (TO) to select a name from Contacts Table.
The problem is that i want to select contacts only related to Customers and not view the
complete list.
For example Vodafone Company has several contacts.
When i press Vodafone in my quotation form then when i go to (To) combo box i would like to view only the
related contacts.
I tried the SELECT statement WHERE but i can to figure out how i will limit the list depending the Customer Name?
Please help.
I got 2 forms that are relatively similar. One of them works fine but the other does not. It still lets me enter data into the field even though Limit To List property is turned on. I believe this is a combo box and I gave this field a value list for the user to choose from.
View 2 Replies View RelatedIs it possible (without using VB) to limit the number of selections a user can make in a multiple value list?
My list is one a form and when in the form field it brings up a total of 15 names with checkboxes, allowing you to "check" each name you want. However, I want to be able to have as many names as I need in the list, but limit the user to selecting only two of them.
I have a list of customers. [ID] on (Form1)
I click_on their name [ID] that opens a dialogue (Form2 )specific to them.
I have a table of several dates with the relevant [ID]
I want a dropdown box on Form2 that only shows the dates for that specific customer[ID]
Ive tried [Form2].[ID] in the criteria of the ID field in the query for the dropdown data source.
I want to limit the results in a query to the selected items on a list box - how do I do this?
View 4 Replies View RelatedWe have a database with one main data entry which stores records in a seperate table. There are several thousand records keyed in using this form. Therefore, alongside the entry we have a search form which allow the user to search for a specific record and display it in the main if he/she needs to edit one.
We have received a request from users for a functionality which allows users to browse all records, using the main form layout, that they have keyed in. I guess what I am asking is: Is there a way to limit the records visible in a form using field on that same form as a limitation (ie. the users name - which is a required key-in)?
HI I am creating a booking system.
I would like to have a form that only shows 10 records for each event. As this is the max number of people that can attend at any one time. How would I go about this. do I use single form, continous for or what ? thanks for any help
paul
Hey Y'all.
I have built a query (Loading_query) that brings in the prefix, number and date_loaded (=null) for each rail car.
I now want to display the rail cars numbers in a drop-down but be limited by the prefix selected in another drop-down on the form.
For example:
If the prefix that was selected = GATX then
the next drop-down should use "Loading_query" to only show the rail cars that are empty (according to date_loaded) and have a prefix that = GATX.....
Still new at this and do not know how to use a value from the form to limit the query.
Hi,
I've attached a zip version of my database (which is still in the early stages of development) as I think it will be tricky to explain what I need. I've studied lots of other threads but can't find the answer I'm looking for.
Basically I have a form "Goods-in" which has a subform in continuous view that lets you pick from a product list. I'm trying to limit this combo to products that relate to this supplier only, but (it seems) because the subform is based on a query I can't update it.
I have tried several approaches but got nowehere. At this stage I don't know whether the problem is with
- how I'm linking the parent and child forms
- the SQL of the combo recordsource
- my relationships
- my overall design
- the weather!
- etc.
I would be eternally grateful if someone could take a look and advise me. The items shaded grey on the forms are just my shorthand for what will be invisible in the final version.
I'm going home now and even though I may read replies tonight, I wont be back in the office until 9am.
Thanks in advance!
"Microsoft Office Access can't create any more controls on this form or report.If you have deleted from this form or report in the past, you may be able to rename the form or report and then add more controls to it."
I tried:
- rename the form -- > same problem
- copy/paste the form --> for some reason it's not duplicating (don't know why)
Is there a limit to insert controls on a form?
I've built a function that open a form in Design mode, read records from a table about appointments and create a grid with textboxes representing one appointment each. On the left there are labels with hours and as column headers there are doctors names. Practically each column shows each doctor's daily appointments (it is a medical clinique).
Every time i change the date all controls are deleted and rebuilt.
But after three or four day I pass I get a message of memory limit.
The question is general : Why the memory finish if I close every variable I use during the creation with the instruction:
set frm = nothing
set newTxt = nothing
rst.close
set rst = nothing
I am having a problem restricting a user from a certain form.
I have a module that detects if a user or admin based on the roles entered in the employees table.
If their windows login is not listed in the employees table, they will not be able to view any of the forms.
Here's my problem, I want the users to access the switchboard, but they should not be able to get into the reporting button.
here's my code:
If LOAStatusbtn.Caption = "View Report" _
And Not admin _
Then
'useraccess denied because not an admin
error_text = "You do not have privileges to access this screen." & vbCr & "Please contact an administrator"
MsgBox error_text, , "No Privileges"
End If
If they click on LOAStatusbtn and their role is not admin, then a message should pop up.
I searched the forum and could not find anything similar to this.
Thank you,
I tried to word the title as accurately as possible.
What I'm trying to build is a Form where they can select data in different fields to limit (filter) the list. In my query criteria I want to read the form, if there's a value use THAT in the criteria (for that field) otherwise ignore it.
I've tried isnulls etc. If I put a value (like City) it properly returns all the records with that city, however if I put nothing the "ISNULL" returns a value that the criteria doesn't match i.e. I get nothing.
There must be a way to tell a query to NOT use any criteria if an object (form!field) is blank...?
I am new to Access and I am developing a form. I have already read and found useful resources on internet but there is something I am not able to sort out.I have seen that the limit of fields I can enter in Access is 255 and my survey is far below that number.So no issue at all when I created the fields in Data view.However, the issues started when I created a form.
I created a form by Create>Form.The last few fields, at the very bottom of the form, are squeezed onto each other as if there was not any space available. Is there a limit to the number of fields I can have in a form? There should not be if I am allowed to enter up to 255 fields. How can I go about it? Should I alternatively create 2 forms? I would rather not to though.
I've built a basic inventory management system that allows a business to add products and the ingredients (and labour etc.) that go into them so they can work out costs and profit.We've run into a bit of a usability problem in the sense that they have 700 different ingredients and so adding them to products has become a little unwieldy as the lists in the comboboxs are massive.
What they've asked me to do is to add a filter combobox to the Ingredients subform of their New Product page that allows them to constrain the Ingredients by type, to make the lists more manageable. So if you imagine they are entering a record for a new cake and need to add Eggs as an ingredient they could either...
a) Scroll through the list of 700 ingredients as they do currently and find "Size 3 chicken egg".
...or...
b) Use a combobox on the ingredient row to pick "Eggs" which would in turn filter the ingredients combobox on that row from 700 ingredients down to a handful e.g."Size 1 chicken egg", "Size 2 chicken egg", "Size 3 chicken egg", "Size 1 duck egg" etc.
the filter combobox applies to all rows in the subform! Is there a clever way of telling the Filter to only apply itself to the current row of the continuous form?My code is...
Code:
Private Sub FilterRMs()
Dim mySql As String
If Me.RMTypeFilter.Column(1) = "999" Then
Me.FilterOn = False
code]....
I have navigation form with 2 tabs I'd like to limit access to users with certain type of account.
There are 2 tables in database that contains user names and types of accounts (tblSecurityLevel and tblUser), and they are used to set user name, login and security level.
It works this way: when you open form, it checks if PC name corresponds to name in UserLogin field (tblUser), if it does it gives appropriate access level depending on set user security, if PC name is not on the list user will be logged as guest.
So far, I used this code and it works great for limiting access to 1 tab:
Code:
Private Sub Form_Load()
Dim UserLogin As String
Dim userLevel As Integer
UserLogin = Environ("Username")
Me.TxtLogin = UserLogin
[Code] ....
Is there a way to expand the code and add second tab (or even third) with this table structure (I'd like to be able to keep login which 1st checks for pc name).
I have a database that has transactions since year 2009. I want the users to only be able to view and edit transactions that were entered in the last 6 days. I was initially able to do this by putting a filter in the Property Sheet section of the form and choosing Yes for Filter on Load.
However, a user was able to discover that by clicking on Clear All Filters, the filter I set was also cleared, thus making them see all the transactions beginning year 2009.
what is the best way and good practice in limiting user's access in form or report.For example, i have 2 users in my UserTable, one is Administrator and the other is just ordinary user.In case i want the ordinary user to open the form in "Read Only" mode, and the Administrator in "Edit" mode.
Do I need to make a code for each form to be opened or there's another easy way to handle this? (I am thinking for additional fields in UserTable to store their individual rights, but after that i don't know what to do next)
Essentially I have a table for rooms around my school and what the rooms contain. Most of the details for the rooms are Boolean (e.g. If the room has a projector, Yes/No). So what im trying to do is have a form where i can select a checkbox(s) and if i tick one, a query that holds all the room details will only show rooms with projectors in them, which i can then display those results in another form.
My question is how do I get the check boxes in the form to narrow down the room results to only show the ones with the criteria i have selected in the form?
Is there a limit to the number of fucntions/suroutines in a Form's module. I got an overflowerror when compiling and I moved a fucntion from the Forms mdoule to another module and the error did not re-appear.
View 5 Replies View RelatedMy problem is the following: when I receive say 5 computers in a purchase form, I want to register the serial number of each of them in another form, bound to another table.If I receive 2 units in the purchase form, my user should only be able to input 2 records in the serial form (a continuous form), if we receive 3, then only 3 records,I cannot quite figure out how to build this second (serial number registration form), so that it refuses input after the correct number has been reached.
View 14 Replies View RelatedI am creating a training database and first I have tables in relationship to the courses:
tbl_Courses
Course ID (Primary Key)
Course Title
Objectives
Instructors (lookup field allowing multiple instructors to be selected, meaning they are skilled to teach the course)
tbl_Instructors
Instructor ID (Primary Key
Last Name
First Name
Full Name (Caluclated to put Last Name, First Name)
[code]....
What I am trying to do on a form to create a new event is once the user selects the Course from the Course ID combo box, then I need the Instructor combo box to only display the instructors who are skilled to teach the course which are selected in the tbl_Courses.
I can get all Instructor ID's, but not the names and the class that has multiple instructors show on one line.Should I have not put the Instructors field in the tbl_Courses? Do I need another table for instructor skills or something?
What I would like to do is create a list box that will only display the information from another form that is related to the current form.So I have a form call Equipment Catalog and that form is related to Equipment features 1 to M relationship and the Equipment Features is related to a Features form M to 1.
So what I want to do is display all the related equipment features in a listbox that is related to the current PK of that form.So if there is only one feature on one form the list box will only display that one item however is there is 6 features on another it will display all 6.I have been trying SQL and Queries but I still can't get it to work.
On a form I have a:
control called "FilterListBox"
list box called "lstCustomer"
option Box called "optCustomerType"
When the user selects an option in the option box, "FilterListBox" is updated to either "1", "2" or "1 or 2"..One of the fields in the query for "lstCustomer" is "CustomerType" and its criteria is set as follows:
[Forms]![frmPrintHowCustomersPaidInvoice]![FilterListBox]
if "FilterListBox" = 1 the query for "lstCustomer" returns the correct records
if "FilterListBox" = 2 the query for "lstCustomer" returns the correct records
But if "FilterListBox" = 1 or 2, no records are returned.