Recent content by Waka0212

Changing to brackets did the trick! Thanks!

Ok. Table1 or TIR Calculator has a date field in it, MIN TIR Date. That date will house what ever date I want to be the minimum required. Table 2 or Personnel Data has has field labeled TIR Date. This date is specific to each person. The goal is to be able to insert a date into table 1 or TIR...

Hello all. I'm trying to filter data between two tables. I've created a table that has a date field that is used as a reference, so I don't have to put the same date in everyone's record in my second table. My sexond table has personnel data. I'm trying to create a query that will filter out the...

@theDBguy, yup, that did it. Pressing 'Enter' key now acts like pressing the 'Login' button. Appreciate the quick and easy fix!

Ok, thanks for the quick reply! I'll give that a try in the morning and report back.

Ok, greetings all and thank you for reading. I have a login form and it's working as intended, mostly. The issue I have is that when someone attempts to login and instead of using the 'Login' button which houses all the code they naturally hit 'Enter'. This however does not login as their...

OMG! 😂 I feel so dumb, I can't believe I missed that... Well thank you all. After correcting those items, it worked perfectly! Thanks again.

Just for some clarification, the following are labeled on frm_login: Username is txt_UserName Password is txt_Password Login button: cmd_login The table is labeled tbl_login Fields are: UserID LastName txt_UserName txt_Password

@isladogs, I will check this out later tonight. Thank you!

Same as before.

I tried your supplied code and still same result. The image above is with your supplied recommendation.

OK, not sure if I did this right, but here is what I did and what I got.

Sorry for the late reply. I will start trying these ASAP and update. Thanks for all the replies! And @Gasman, lesson learned for code snippets. Thank you!

So, I've been putzing around with this code for a few days now for a login form. Everything seems to be working correctly except I cant get passed the strSQL. It pops up a "Run-time error '3061': Too few parameters. Expected 2." I'm using a thread from the following link...

Honestly, I don't know about majority of coding. I typed what I wanted in Google and found this expression and made it work. Or atleast thought I did. If there is a better way to return a year(s), month(s), days(s) result, I am totally open to suggestions! Please and thank you! And when I get...