Search results

Thanks everyone. It was easy to find a workaround. I'm just curious why my code in my original post didn't work. It seems to me that it should have worked.

DBGuy - Microsoft 365 MSO (Version2402 Build 16.0.17328.20648) 32 bit

cmb_Client is an acComboBox - but shouldn't this code prevent me from getting the "You can't hide a control that has the focus" error? For Each ctl In Me.Controls If ctl.ControlType = acTextBox Or ctl.ControlType = acComboBox Then ctl.Value = Null cmb_Client.SetFocus...

Found the problem. This was my code behind the double-click event. I wiped out the value at the end. Not a good idea. lst_Goals_DblClick(Cancel As Integer) txt_Goal = lst_Goals.Column(0) txt_Comments = lst_Goals.Column(1) cmb_Frequency = "" cmb_Intensity = "" txt_Comments = ""...

See attached. Double-click frm_Login Login: test PWord: testing Choose "Speech" from Therapy drop down Click "Unfinished Notes" Click "Client" Choose Note from drop down box Click "Goals" Choose "Articulation" from the Category drop down box Double-click "Compensatory Strategies -...

I have a list box called lst_Goals. On the double-click event it should populate txt_Goal and txt_Comments with values. Here is the code: txt_Goal = lst_Goals.Column(0) txt_Comments = lst_Goals.Column(1) txt_Goal poplates as it should. txt_Comments remains blank. I put a msgbox in the...

That works! Thanks to all!

Thanks Pat - However, now I get "Object doesn't support this property or method" on the ctl.Bold = True line.

I want to make certain command button captions to be in bold print when my form is opened. To determine which command buttons should be bold I open a recordset and run the following code: If rs.RecordCount > 0 Then Do Until rs.EOF Dim ctl As Control For Each ctl In...

In the back end SqlServer table the date and time are in the same field. However, when it's linked to Access only the time appears. I have no formatting in that field.

Thanks CJ_London. I used the Timevalue function as suggested. The msgbox value depicts the correct Time_In value as is in my database table. However, no record is being returned in the rsD recordset. Below is my complete code. I'm trying to determine if another record exists as to prevent a...

‘If I run this query it returns what I expect. SELECT tbl_Note_COG_BasicInfo.Client_Id, tbl_Note_COG_BasicInfo.DateOfService, tbl_Note_COG_BasicInfo.Time_In FROM tbl_Note_COG_BasicInfo WHERE (((tbl_Note_COG_BasicInfo.Client_Id)="600045") AND ((tbl_Note_COG_BasicInfo.DateOfService)=#8/29/2024#))...

This didn't work because I put tics at the beginning and end. I removed the single quotes and now everything is working as it should. I can't thank you guys enough! I'm new to encryption and this was quite a challenge for me!

PassWordHash is binary(64) in the table. Just FYI.

Yes. That's it. Thank you! One more question. Why doesn't this work? This is how I would validate the user, correct?

I get what I would expect: 0x24D6EDB8DBE2BCA27CFEFC1B0682BB7C34A0F5AA23EC6EA2724CC0DBFDBB9EB3D6BC90FEA92B84C0820DB784319ED53E6FB5DE74B19C36FEDE0C594D374792CD

The salt in my sproc is commented out. I have two options in the sproc: salt and no salt. I tried them both.

@sonic8 - Below is the sproc. I call it with: exec uspAddUser 'jsmith','joseph','John','Smith','0' USE [Notes_TEST] GO /****** Object: StoredProcedure [dbo].[uspAddUser] Script Date: 7/26/2024 10:06:39 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE...

@cheekybuddha - The online converter was referenced by the author in the article posted by DocMan. I just wanted to point out the frailties of hashing strings. If someone can use: then all bets are off in so far as validating encrypted passwords is concerned. @sonic8 - I will post that...

From the article: If you type "Let's eat" into the suggested online calculator you will not get the hash that the author claims. However, if you copy and paste "Let's eat" from the article into the calculator it will return the promised hash. The author gives no explanation for this.