Home Posts Topics Members FAQ
Parasyke
Can anyone coach me in a custom log-in screen? I have a table set up
with users and a password. I don't need high-level security, just the
ability to recognize the stored user without API calls and genuine
MS-Access security (just don't want to implement workgroups at this
time). So basically the user sign in form would authenticate the user
and password (IF - Then) and store that value in a hidden form that
would remain open but invisible. Then I could reference the
Forms!Logon!Tex tbox value stored (but if I have multiple users that's a
problem (?)). What I ultimately want the stored value to do is allow me
to pass it into some queries for filtering reports and displays.
Any ideas? Thanks in advance!
Aug 26 '06 #1
Subscribe Reply
Rick Brandt
Parasyke wrote:
Can anyone coach me in a custom log-in screen? I have a table set up
with users and a password. I don't need high-level security, just the
ability to recognize the stored user without API calls and genuine
MS-Access security (just don't want to implement workgroups at this
time). So basically the user sign in form would authenticate the user
and password (IF - Then) and store that value in a hidden form that
would remain open but invisible. Then I could reference the
Forms!Logon!Tex tbox value stored (but if I have multiple users that's
a problem (?)). What I ultimately want the stored value to do is
allow me to pass it into some queries for filtering reports and
displays.
Any ideas? Thanks in advance!
You've pretty much described the whole thing and no, multple users would not be
a problem. What part of what you've outlined above are you having problems
with?
Use DLookup() to test the UserName and Password entered.
Use Me.Visible = False to hide the form.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Aug 26 '06 #2
Bob Quintal
"Parasyke" <kr************ @yahoo.comwrote in
news:11******** **************@ b28g2000cwb.goo glegroups.com:
Can anyone coach me in a custom log-in screen? I have a table
set up with users and a password. I don't need high-level
security, just the ability to recognize the stored user
without API calls and genuine MS-Access security (just don't
want to implement workgroups at this time). So basically the
user sign in form would authenticate the user and password (IF
- Then) and store that value in a hidden form that would
remain open but invisible. Then I could reference the
Forms!Logon!Tex tbox value stored (but if I have multiple users
that's a problem (?)).
that's not a problem. since the form is not bound to a table,
the value in one instance of access is invisible to the other
instances of access.
What I ultimately want the stored value
to do is allow me to pass it into some queries for filtering
reports and displays. Any ideas? Thanks in advance!
I create an unbound form that contains several labels and one
button. The form is on a timer that opens the main menu form and
makes the welcome form invisible, then sets the timer interval
to 0. The button just executes the On timer event.
I load several pieces of data into the labels' caption
properties in the startup code, such as the machine ID and User
name. The welcome form will show "Good morning, Parasyke" and "
Welcome to the Whatchemecallit database"
Just use the login form and make it invisible after the user has
passed the login password test you create.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com
Aug 26 '06 #3
Parasyke
Any code snippet on how to use the DLookup() (I'm assuming stored in
the form's SQL rather than a separate query?).... Thanks!
Rick Brandt wrote:
Parasyke wrote:Can anyone coach me in a custom log-in screen? I have a table set up
with users and a password. I don't need high-level security, just the
ability to recognize the stored user without API calls and genuine
MS-Access security (just don't want to implement workgroups at this
time). So basically the user sign in form would authenticate the user
and password (IF - Then) and store that value in a hidden form that
would remain open but invisible. Then I could reference the
Forms!Logon!Tex tbox value stored (but if I have multiple users that's
a problem (?)). What I ultimately want the stored value to do is
allow me to pass it into some queries for filtering reports and
displays.
Any ideas? Thanks in advance!
You've pretty much described the whole thing and no, multple users would not be
a problem. What part of what you've outlined above are you having problems
with?Use DLookup() to test the UserName and Password entered.
Use Me.Visible = False to hide the form.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Aug 29 '06 #4
This thread has been closed and replies have been disabled. Please start a new discussion.
Similar topics
1 3038 Setting a Custom Error Log by: Randy Jackson |last post by: I'm trying to set up a simple redirect for errors and log them to a custom file. I'm doing this for work on remote servers where I may not have access to their error.log. Anyway, the code I've written does not seem to be working. Errors are still being logged to the Apache logs, and I'm having a difficult time figuring out why. Here's... PHP |
4 1936 Custom 404 and logging by: Paul Woods |last post by: I'm developing an application that uses a custom 404 page to deliver all of my site's content. However, doing things this way renders IIS's regular log files pretty much useless. Are there any established "best practices" for creating your own logging system? I know that others use this technique and I'm hoping someone has some ideas they... ASP / Active Server Pages |
6 1400 Custom 404 Page by: Matt |last post by: I notice that when you have the defualt setup of 404 error pages the IIS 5.0 log tracks the page the user was trying to get to and the page they where at when they tryed to get to the now missing page. I recently wrote my own 404 error page to make it match my site but when I set IIS to use my custom page it no longer traks the page that the... ASP / Active Server Pages |
1 1374 Problem with custom event log by: Victor |last post by: I am developing a windows service application that uses a custom event. the problem is that the service installer associates the service with application log during the installation process. Therefore, the custom log does not recieve messages from the event source. Below is code snipet ' check if log exists on this machine If Not... .NET Framework |
894 Custom Listener InitialiseData path "Program Files" query by: Cuperman |last post by: Does anyone know of an issue where a Configuration Exception is thrown when "Program Files" is used as part of the initialiseData value within a custom listener? eg: <system.diagnostics> <trace autoflush="false" indentsize="4"> <listeners> <add name="myListener" type="System.Diagnostics.TextWriterTraceListener"... .NET Framework |
2 1428 Q : Error While Writing to CUSTOM EventLog by: Marauderz |last post by: OK this just seems to be a common question being asked around here, I've tried Google Grouping the question but I still haven't came up with a solution yet. So here goes... I'm getting the Security Exception about being Unable to Access a Registry Key when trying to write to my custom event log. the Eventlog I'm trying to write to, has... ASP.NET |
782 problem with custom log by: |last post by: Hi I am having problem with the custom log I have created. When I open the properies page of the log, all the following information were shown "not available" Size Created Modified Accessed ASP.NET |
1046 Events are being logged to the "Application" log instead of custom log by: yousefomar |last post by: Hi Pros, I have a weird problem here. I am logging from my .NET app to a custom log, but unfortunately, the events are redirected to the Application log. I am sure that I am specifying the log name and the source name accurately. I am using some code like the following: EventLog ev = new EventLog(myLog); if... .NET Framework |
3 1586 Where to store custom error log by: |last post by: I want to write some custom error messages to a log so that I can read them on the next run of the application and as the user to send them to me. Where the right place to store this log file? Which directory path is the right one - so that it's always writable regardless of the user's permissions. I guess it's more of an application-level... C# / C Sharp |
2147 Custom install action does not register event log sources by: =?Utf-8?B?QWxoYW1icmEgRWlkb3MgS2lxdWVuZXQ=?= |last post by: Hi all, Can somebody give me a hint why my custom install action does not register event log sources, when I run the MSI package generated by VS2005. The same install action DLL executed via installutil.exe registers evrything just fine! Here's the installer class that I have created: C# / C Sharp |
7479
What is ONU? 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, well explore What is ONU, What Is Router, ONU & Routers main... General |
7669
Problem With Comparison Operator <=> in G++ 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. ... C / C++ |
7926
Maximizing Business Potential: The Nexus of Website Design and Digital Marketing by: jinu1996 |last post by: In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that... Online Marketing |
7773
Discussion: How does Zigbee compare with other wireless protocols in smart home applications? by: tracyyun |last post by: Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the... General |
4962 Couldnt get equations in html when convert word .docx file to html file in C#. 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... C# / C Sharp |
3468 Trying to create a lan-to-lan vpn between two differents networks 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... Networking - Hardware / Configuration |
3450 Windows Forms - .Net 8.0 by: adsilva |last post by: A Windows Forms form does not have the event Unload, like VB6. What one acts like? Visual Basic .NET |
1 1901 transfer the data from one system to another through ip address 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 C# / C Sharp |
722
Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy 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... General |
By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.
To disable or enable advertisem*nts and analytics tracking please visit the page.