Search results

B-I-N-G-O!! That worked a treat!!! Thanks for your endless patience. I can actually see where the problem was too, which is great. On to the next task... Thanks again buddy M

Hmm... that's changed it so as it now doesn't change any of the passwords. Might have to leave it for a while and come back to it. Starting to fry my brain! o_O Cheers for trying to help me. M

Am I heading the right way with this...? UPDATE tblUsers SET tblUsers.[Password] = [Forms]![frmResetPassword]![txt_NewPassword], tblUsers.Username = [Forms]![frmResetPassword]![txt_NewPassword] WHERE (((tblUsers.Password)=[Forms]![frmResetPassword]![txt_OldPassword]) AND...

Hi. Thanks for your reply. Wow, that definitely looks along the lines of what I'm after. Do I need to do anything special to use it? The reason I ask is that I opened it up and tried logging in as Jill. As mentioned in your description, I was prompted to select a new password, but when I did, I...

Thanks, I really appreciate you taking the time to help. So sorry if this is really basic stuff, but I can't figure out exactly where to include your code. My update query looks like the attached screenshot... Apologies for being a biff! M

That's just weird! I can't think why it links them to FB. I've attached the screenshots to this message and the VBA code is on my reply to Minty above. So from your suggestion, am I right in thinking that it needs to be included in the Update Query expression builder? Cheers :)

Here it is. I can't take any credit for putting it together as it's something I came across when searching for some answers. Private Sub Command4_Click() Dim db As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String If Trim(Me.txt_Username.Value & vbNullString) = vbNullString...

Sent you the email, however just tried to submit the post again (unchanged) and it's accepted it. More confused now than I was before :D Thanks for your help. M

Hi. I have no idea why, but for some reason it accepted my post (even though nothing was changed on it from my original attempt!). Thanks for your help. M :)

Ok friends. I need some help… I’m new to this so please explain it as though you were instructing a young child! This is to do with user log-in details for my database. I have a table called tblUsers, with the usual stuff like ID, Name, UserName, Password fields etc. I have managed to get the...

Too big, I'm afraid :-(

Thanks for your reply. An Admin suggested that, but it still doesn't work. I have emailed him the post directly so he can have a look at it. Cheers :)

Therein lies the problem... I can't post it to show you :ROFLMAO:

Nope. Just some background info on my question and some screenshots.

Is anybody else having problems posting questions? I'm getting the following message... "Your content can not be submitted. This is likely because your content is spam-like or contains inappropriate elements. Please change your content or try again later. If you still have problems, please...

I'll give it a whirl... I'm guessing your address is <snipped>? M

Thanks. Just tried but got the same message. I've attached a screenshot...

Thank you :)

No links, but there were screenshots. I tried removing them, but got the same message. Most confusing.

Thanks Jon. Appreciate the welcome. I did just try to post a question in the VBA section, but it would not post as it said it contained spam or prohibited items etc. It didn't... honest!!! Any ideas/advice? Cheers M