Search results

I'm getting a type mismatch error in the following code on the "Set lstname = txt_CurrentListBox" line. I realize that lstname is an object (listbox) and txt_CurrentListBox is a textbox holding a string so the error makes sense. However, what can I do to use a variable for the listbox name so...

Pat - I wrote you a poem: If you said you were cold, I would wrap my arms around you. If you said you were thirsty, I would give you the ocean blue. I would give you anything: the moon, the stars, the sunset too. This heart in my hands I hold out to you.

Thank you all for your responses. GPGeorge - thanks for the explanation. It seemed to simple to be true.

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.