Search results

My mistake. 2/22 is a Saturday. The only reason those queries work is because -2 and +5 are hard coded.

If the date entered is a Monday I would want that date as the "Previous Monday". I don't quite understand that query. There is a dash before Weekday and also a "-2". How could the -2 be hard coded?

The user enters a date on a form: 2/18/2025 I need a query that will calculate the previous Monday and the coming Saturday. The result should look like this: I'm familiar with DatePart and DateAdd but just can't figure out the logic. ANy help will be appreciated.

Nevermind. I used a non-proportional font and it solved my problem. Thanks so much for your help!

Okay. I guess this is a dumb question but what is a "non-proportional font"?

I have a listbox whose rowsource is a table consisting of two columns. Works great. However, the user wants the data to be displayed as text in a text box so that they can copy/paste into a Word document. I already wrote the code to loop through the table and write the table's rows into a text...

Yes. I see that now. Thanks everyone!

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!