Code:
If txtpassword.Value = DLookup("[pswrd]", "tbllogin", "[cbousername] ='" & Me.Cbousername.Value & "'") Then
RuralGuy
Last Activity: Nov 2 '20, 04:08 PM
Joined: Oct 8 '06
Location:
-
RuralGuy replied to when using the dlookup command, only the first password situated on the top of the tain AccessMy guess is your password is a string value so it needs to be enclosed within single quotes inn this case: -
Thank you very much for that update!Leave a comment:
-
Welcome. Glad we could help.Leave a comment:
-
Put the ComboBox on a *form* and Preview the Report from the FORM with a WhereClause.Leave a comment:
-
Reports are not interactive, they are basically a piece of paper. What are you trying to achieve.Leave a comment:
-
Excellent! Glad we could help.Leave a comment:
-
Maybe this is the link you seek: http://allenbrowne.com/ser-28.htmlLeave a comment:
-
I would use this approach instead of what you have: http://allenbrowne.com/ser-13.htmlLeave a comment:
-
You are using the new NavigationToolB ar in Access 2010?Leave a comment:
-
Here's one possible solution: http://www.baldyweb.com/Bookmark.htmLeave a comment:
-
Excellent! Thanks for posting back with your success and glad we could help.Leave a comment:
-
You need a separate SELECT query or Domain Function to test the record first.Leave a comment:
-
The name of a control is on the "Other" tab of the property sheet of the control. If you use the Me. preface in the code then Intelisense will show you the possible legal answers.Leave a comment:
-
See if this "1st Month" works as you would expect....Leave a comment:
-
You should name your Controls differently that the fields to which they are bound. Access does not know whether you are referring to the field or the control.Leave a comment:
-
Try changing them to Single or Double again and see what happens.Leave a comment:
-
All of the fields in the Development table save two, are text fields. You are doing numerical testing against "text". Your table fields should be probably the Single DataType fields.Leave a comment:
-
The Name of your control is Combo22. "age" is the field to which that control is bound. The field is not actually updated until you either move to another record or close the form.Leave a comment:
-
Maybe you should try and attach you db at this time. Compact and Repair and then ZIP it up first.Leave a comment:
-
You lost me on that one. You enter a value in the weight control and when your code executes and you hover over the weight entry you get the "wrong" value?Leave a comment:
No activity results to display
Leave a comment: