Search results

I tried flipping the if statements. That fixed the problem when an admin put in the wrong password, but now regular users get nothing. Somehow those two statements need to be more like: If(xxxx is true) AND (yyyy is true) then....

So I had everything working and then realized I had another issue. The only thing that doesn't work now is when a user enters the wrong password and clicks "Submit", nothing happens. I'm almost positive it's an issue with how I have the If statements coded. Here's the code for the button...

What should I set the input mask to if I want to create an unbound text box to only accept exactly 8 alphanumeric characters.?

This is what finally works: SQL = "UPDATE tblEmployee SET [PassChange] = 0 WHERE [Employee] = '" & Text0 & "';" CurrentDb.Execute SQL I needed the single and double quotes around Text0. Can someone explain what the quotes signify, because I'm not exactly sure? Thanks for all the help.

DAW It doesn't seem to be working. I now have it like this: SQL = "UPDATE tblEmployee SET [Pchange] = 0 WHERE [Employee] = 'Text2';" CurrentDb.Execute SQL Should the Text2 be Me.Text2.Value?

Does this look like it would work: SQL = "UPDATE tblEmployee SET [Pchange] = '" & 0 & "' WHERE [Employee] = 'Text0';" CurrentDb.Execute SQL tblEmployee contains fields: [Pchange] - Yes or No value determining if user needs to change password [Employee] - stores the username...

Excellent, it works now. One thing I forgot to ask about is how the syntax to change that field to a 0 would look.

I have a table that has a field, [Pchange], with a "Yes/No" value. If this field is "Yes", then when a user tries to log into the DB, they are prompted to change their password. If it's "No", then the main form opens. What is the VBA syntax to reference this field? The first "If" statement...

I figured out how to create a sequence of if/else statements. Now I have another question, but first an explanation. On my login form, if a user puts in the default first time password, which is "password", a form opens(frmPassChange) with fields for the username, new password, and new...

In the code above, is it possible to add an "if" after the "else" to add additional conditions? In this instance, I'll be assigning temporary passwords for new users which will be the same default. I'd like to add another condition so that if a new user attempts to log in with the default...

Ray That works!! This is off topic, but can anyone recommend a good book for a beginner to learn VBA? Thanks

I have a table, tblEmp, which holds fields [USERNAME], and [PASSWORD]. I also have a form, frmAuthenticate, with 2 unbound text boxes...one for the username and one for password. What I want to happen is that when I input a username and associated password, the name entered will be matched up...

As I'm sure many of you know, Access '07 no longer supports user level security. My question to you all is, how do you secure your DB's in '07? I just built a DB that stores patient data, and it needs to have some type of user authentication to gain access to it. I know I can assign a general...

I have a table in my DB, tblWeightUpdate, which stores patient weight history. When a patient comes in for a treatment, their current weight[Weight] is taken and input through my main form along with the date[CurrDate] it was taken. These entries are linked to patients in my main table...

DrSnuggles That's correct.

1. The form that is being opened does use the field [MEDRECNO] 2. While in design view of the form, I click on the subform and highlight the entire subform. When I do this there is only a Source Object listed under the data tab. That object is the name of my subform, in this case...

I corrected the code and it compiled. Thanks

I get a runtime error 424, "Object required" which is for line: strLinkCriteria = "[MEDRECNO]= " & OncListingSub![MEDRECNO]

Can anyone else see anything wrong with the code above?

I was able to split the database successfully, but when I go to 'Database Tools' and click "Make ACCDE" I get an error saying "Microsoft Office Access was unable to create the .accde, .mde, or .ade file." Then, in the help section on that error, it says: This error is usually associated with...