Search results for query: *

Thanks very much for your help. Tina.

One last quick question. I've created a user login form where the user inputs their user ID and password, after the user inputs their login information though and the form opens another form, the login form does not disappear and the Main Menu opens up behind the login form. How do I make the...

Thanks so much for your help guys. You two have both saved me several times. One more question though, after the user inputs their login information how do I close the form. What's happening now is that the form stays on the screen on top of my Main Menu form. I've never seen this happen...

Hi, I'm trying to set up my database so that when the user logs into my database if their user name and password is in my table it will then open up a certain form; however, if their user name and password is not in my table it will then open up another form. My code doesn't seem to be working...

I still really really need help with this. Is there anyone else out there that could give me a hand with this problem? Tina.

Muttley, I have a thought why this might not be working. I hav set my 'Record Source' for the 'Login' form to tblUser, but the 'Control Source' for each text box (txtUserName' and 'txtPassword' is currently unbound. Should I set the 'Control Sources' to the table respectively. Tina.

Muttley, Thanks for all your help and I'm sorry this is coming to me a bit more clearly. Anyways ... I've modified the code as is below and now I'm getting a 'Run-time error '3061':' that says 'Too few parameters. Expected 2.' and it highlights the 'Set myRs = CurrentDb.OpenRecordset(myQry)'...

Actually Muttley ... here's the code I'm using. maybe this will be easier for you to actually see it. Private Sub Command5_Click() Dim myQry As String Dim myRs As Recordset myQry = "SELECT User, Password FROM tblUser WHERE User = me.txtUserName AND Password = txtPassword" Set...

Thanks so very much for your help Muttley !! I just put the 'End If' statement after the 'DoCmd.OpenForm "frmFormB',acNormal' statement and now when I try to run the code, I get an 'Compile error' that says 'Else without If' which highlights the 'Else' above the 'DoCmd.OpenForm...

OK ... this is the scoop. I am a beginner Access programmer and I have no idea whatsoever how to do what I need to do. I have never learned in school either, so I need you to help me and be as simple as possible. Here's my problem ... I have created Table1 with 'User ID', 'Password' and...

How do I creat a runtime version of a database I've created in Access 97? Tina

How do I link forms so that if on my first form I set up a 'Find Record' button and on the two other forms connected to Form 1, it shows data that corresponds with a relationship that I've set up with data on my first form. Let me explain this again ... I have Form1, Form2, and Form3. On...

Thanks for your help Mike. I appreciate it. Tina TT

How and where do I set code to reset my form so all the entry boxes are blank when the form is opened for the first time? Tina TT

I'm trying to set my criteria in my query to print a report for my highest entered auto number only. Because this is continually changing, how do I set my criteria to print my report for only the highest numbered row?