I have a database where all users need access to all tables, forms, etc. However, I am trying to make it so users can only see a subset of the data (teachers need to see data for their students). I created a select query which prompts for the teacher name and then password. Is there a way to mask the password as they type it?
Here is the query:
SELECT tblStudent.Stud entStateID, tblStudent.Stud entName, tblStudent.Stat us, tblStudent.Grad e
FROM tblTeachers LEFT JOIN tblStudent ON tblTeachers.Tea cherID = tblStudent.Teac herID
WHERE (((tblStudent.S tatus)=Yes) AND ((tblStudent.Te acher) Like "*" & [Type teacher last name] & "*") AND ((tblTeachers.p assword) Like [Please enter your password]))
ORDER BY tblStudent.Stud entName;
thanks!
7 2414 Rabbit 12,516
Recognized Expert Moderator MVP
No, but how about using an intermediary form that opens the query? You can mask passwords on the form.
So I create a form that uses the teacher name and password, how do I pass this on to the query... by using a control that launches the query?
Rabbit 12,516
Recognized Expert Moderator MVP
Yes, and you can refer to controls on forms using Forms!FormName!ControlName
okay, I am definitely doing something wrong. My query has prompts for teacher name and password. Should I remove these prompts? If I don't, when I launch the form the prompts come up.
But when I remove the prompts, it returns all records, not just the ones for this teacher.
So let me start at the beginning... I created the form in design view using the select query. I pulled in the teacher name and password from the query field list. Is this correct?
Thanks so much for your help - this is driving me crazy!
I got it - using your query by form works better than what I was trying to do!
Thanks so much... Now I can sleep tonight!
Rabbit 12,516
Recognized Expert Moderator MVP
I got it - using your query by form works better than what I was trying to do!
Thanks so much... Now I can sleep tonight!
Not a problem, good luck.
Using the query by form worked great for masking the password, however it doesn't limit someone to just that subset of data. Is there a way I can make this subset all they have access to?
This database is used by multiple schools. I want to have them use this query to log in and then only have access to the students that this query returns. I tried query to table, however that locks all other users out. I have record locking set to "Edited Record" and Open database using record level locking - because several teachers need to assign grades to the same students - though no two teachers should ever be trying to access the exact same field for a student. Should I not have these set?
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Hendry Taylor |
last post by:
I have a problem where if I issue a select * from against a database it
returns no data,
but if I select column from it returns the data.
Why would the * not be working as a wildcard?
|
by: Pradeep Kumar |
last post by:
Hi Everyone,
Well Im trying to open a mdb which is password protected and when Im
using the below code it was running perfectly for the mdb's created by
me., but an mdb send by others to me is also giving out the password
using the below program but it is in some ascii code characters or to
put more clear the password is encrypted ., well I...
|
by: Francis Debrabandere |
last post by:
Hi all,
I'm a beginner in ms access, and I'm working on my first real
application. But to finish it up I'm facing a problem. I'm not able to
solve and maybe someone can help me.
I have made a database that can be divided in two major parts:
1. entering data
2. reading the entered data.
Everybody who uses the database has access to the...
|
by: social_engin33r |
last post by:
Hello, I've been asked to help someone set up a database. One of the
fields in the database is a text field that holds data imported in this
format:
11-A-11-11
The users prefer to see the information in the hyphenated format
because it is easier for them to read/visualize/whatever. (Of course,
it doesn't have to be stored in that...
|
by: Yang |
last post by:
Hi
Is it possible to mask console input in a c# console application?
What I mean is: if I entered string "test" in the console, it'll echo
"****"(or nothing) instead of the string "test".
I've tried setting the foregroud color of the console the same as the
backgroud color through native API, but it doesn't really hide the password,...
| |
by: Vincent van Beveren |
last post by:
Hi everyone,
I have a page with a login box. Because of lack of space, instead of
labels I put the descriptive text in the input fields (so username input
says 'username', and password input says 'password').
The password field however, once it does have the focus, it should mask
its input. Now what I've done, and works in firefox, is...
|
by: julianmoors |
last post by:
Hey,
Currently I'm writing a VB.NET/1.1 app and I need to mask the input for
the password field. Does anyone know how to do this in VB? I've seen a
C# example, but wouldn't know how to convert it myself. Here's the URL:
http://www.codeproject.com/dotnet/ConsolePasswordInput.asp
|
by: Ian |
last post by:
I have an Access 97 form with a text box bound to a field in a table, I
have set the Input Mask to Password.
When I select the box by clicking on it or dragging the mouse over it,
all the characters are selected except the last one on the right hand
side. It seems the only way to select all the characters is to Tab to
it. Does anyone have a...
|
by: Smokey Grindle |
last post by:
I have a text box on my form which I want masked as a password field, but I
can't figure out what the standard mask character is in windows XP and up...
anyone know what makes those round circles for the mask? thanks!
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |