Recent content by moke123

While you're at it you should eliminate any spaces and special characters in your field names, as well as all your other objects.

you could also use Select Case Right(Me!cboFormat.Column(1),2) Case "CD" Case "LP" Case "45" Case Else End select

you could also run the query and use the following to test if records returned. if not Me.List0.ListCount > 0 then MsgBox "Sorry, no records were found.", vbInformation, "Search Menu" Me.txtLname.value = Null Me.txtLname.SetFocus end if

Back when I worked privately, we used to do it the old fashion way. Look out the window, see what kind of car they showed up in, and set our hourly rate accordingly.

You guys do know that an alford plea and pre-trial diversion are not mutually exclusive and are often taken together, right?

The current administration cut 30,000 jobs from the VA last year and I think another 35,000 of unfilled positions. It was part of project 2025. No surprise that it will take months to get an appointment.

This begs the question of how they get hidden or not in the first place. You could set a variable at that point.

I encountered errors too. vbNewLine and vbCrLf both resolve to 13 but chr(13) wasn't working correctly, neither was chr(0) for null. Easy work arounds with only 2 short lines of code.

For multi-select listboxes I use the following code. The reason for the enums is that they are also used in other procedures. you could use it as GetList = "TransactionID IN(" & fGetLbx("your listbox object" & ")" Public Enum eDelimiterType NoDelimiter = 0 DoubleQuotes = 1...

I would say it's an object. when I need to requery all the list boxes on a form I use something like this and pass in the form reference Public Sub ReqLbx(frm As Form) Dim ctl As Control For Each ctl In frm.Controls If ctl.ControlType = acListBox Then ctl.Requery...

I read an article which mentioned that the US data centers will require nearly 90% of the global supply of high end computer chips.

Wow $2800+ a year seems pretty high to me. There are a lot of factors taken into considerations by the underwriters. Age, driving/accident records, commercial vs. personal, miles driven per year, # of drivers in household, coverage limits, and more. I pay $840 a year for both liability and...

Something like this?

For what reason are you using dateserial? And using date() in the year criteria rather than BDate?

Is this question related to this? https://www.huffpost.com/entry/reddit-challenges-australia-teen-social-media-ban_n_693bde79e4b07bcd25427c0a?ba=&utm_source=buzzfeed&utm_medium=iframely