Search results

@jdraw - the problem was that the way the comparison was working. Without the Nz wrap, the test of the checkbox would always equate to true, which would force a password change even if the password was not in need of change. I had it return the (0) in the first statement so that it had an...

Okay, this time I actually think I fixed it. Even with testing it, it appears to be working all the way through the way it is supposed to. I needed to wrap the dlookups in "Nz" and have it return a value for comparison in the logVar statement. Since it was returning a null value with an...

Here is the testDB...Thanks again for looking at it. I had to remove quite a bit of info, so it is very stripped down.

Also, the password reset isn't working...not as close as I had hoped. I will get a testDB up in a bit.

I think I fixed it. I love when that happens, assuming it is correct! haha...(edit: it wasn't fixed.) Okay the old line looked like this: logVar = DLookup("LoginID", "lutWSCStaff", "txtLogin = '" & Me.txtLogin & "'") The "fixed" version looks like this: logVar = DLookup("LoginID"...

Okay, changed the names completely (LoginID and UserPass), moved the dlookups inside their respective if statements, and it still is not processing past the first lookup. Private Sub btnLogin_Click() Dim logVar As Variant Dim passVar As Variant Dim pwdVar As Variant 'Checks that Username...

Okay it is not working with those changes, but I did add the msgbox. It returned the very first person in the staff list, with the generic password and a -1, Which all are set to by default. I went into the table and removed the checkmark in the password reset box, and the msgbox returned the...

From the examples I saw, it appeared to hold the value from the txtboxes. However, removing them or adding does nothing to fix the problem and in debugging, it does not throw an error.

Hi folks, I have been trying to figure this out for hours and I cannot seem to find my error. It is a basic login vba that I have put together from looking at examples here and other places. I used the dlookup to find the UserName, Password, and Password Checkbox values in the lutWSCStaff...

Haha, yes, we tend to bang our heads while working through problems, but typically we are banging them in the same direction so that helps. Yes it is a navigation form.

Honestly, I look up how to do it online, beat my head against it until I understand it, and then make it work. I haven't come across a reason to do this yet, so I haven't learned the "how" to do it, though I understand the concept.

1. Yes, almost all the labels are attached to the controls. We have a few unbound boxes, but better than 99% of them are attached. 2. Not anywhere near as well as I should.

"WE" really appreciate the help! :)

The name of the control: ContractNo It is the same all the way through.

No, we are not currently using the tag property for anything. I am open to any suggestions if it makes life easier! To differentiate between what is "required", what can be "used, but not required", and "not used for this report" is what I had in mind with changing the colors of the labels. Red...

We - would be myself and another individual. We work very well as a team and have no issues there. Here is the attached screenshot of what we were talking about. Sorry for the delay. The bottom row under the Demographic Reports is where the corresponding buttons are for the reports. Once...

We thought about that, but we have several reports (close to 20) that potentially can be run from the same search controls. We thought it would be easier on the user base to just put the search parameters in the text boxes/combo boxes at the top (once), then browse through the tabs and select...

I actually figured it out! Yay for learning and more researching! If (NavButton Is Me.ActiveControl) Then Me.Parent.Label.ForeColor = RGB(0,0,0) I dont know how to get the boxes to not be selectable, but this is a good start!

I am not quite sure, so let me tell you how it works. I have a top level tab that says "People", for example. When I click on that tab, 3 links(they were named navbutton by default) come up under the tab, that when clicked, display the reports in the navigation page subform frame.

Good morning, We have a navigation page with 5 tabs and several navigation buttons underneath their respective tabs linking to reports. In the main part of the navigation page we have 17 search parameters (text boxes and combo boxes)that the user can use to sort through all the reports we have...