Search results

Interesting. I'm going to pass it around the office and get some opinions. My initial take is it wouldn't be allowed but evidently it was.

A dictionary has 2 parts, a key and an item. If you try and add a duplicate key it'll error but in that code it is using the .exists method and exiting the function and setting the functions return value to true. I'm a big fan of dictionaries as I find them much easier to use than collections...

One method I use is to use a form instance with Withevents. This all goes in the calling form. Top of calling form module - Dim WithEvents MyForm as form private sub SomeButton_Click() docmd.openform "SomeForm" set MyForm = forms("SomeForm") MyForm.OnClose = "[Event...

Once again, Not what I said. Enlighten yourself. https://www.brennancenter.org/our-work/analysis-opinion/presidents-cant-use-justice-department-their-personal-law-enforcement

They are ethically obligated to serve the constitution. They are not the presidents attorneys.

You may be waiting a long, long time. https://static01.nyt.com/newsgraphics/documenttools/41b5fc5814067eb0/1ae076b8-full.pdf

Guess you haven't been reading the resignations. Most DOJ Ausa's serve both democrat and republican presidents. They don't however compromise their ethics to do so.

You'll be able to tell by the resignations.

The G.O.A.T.

This is an interesting one... https://www.readtheirlips.com/

What is this supposed to do?

When I read the decision it appeared to me to be a very narrow finding which only applied to the definition in that particular Act of 2010. Do you guys have some sort of a "gender certificate" for trans people?

Any code related to the list box besides the items selected? Bear in mind that a list boxes value can be set to anything in code, even values that are not in the list. If you're setting the value on load with .itemdata(0) I believe you get a dotted outline

So your basically using a fiscal year 4/1/2025 to 3/31/2026. Does each grant have a different start date?

Are you dealing with fiscal years? Function GetFiscalYear(Dt As Variant, Optional StartMonth As Integer = 7) As Variant If Not IsDate(Dt) Then Exit Function If Month(Dt) >= StartMonth Then GetFiscalYear = (Year(Dt) + 1) Else GetFiscalYear = Year(Dt) End If...

I think your missing the point to NOT use hyperlink datatype. If you must store the full path to a file then just store the path as text in a text field. You can then use vba to open the file as if it were a hyperlink. If you keep the files in folders in the same folder of the database you...

unfortunately you've used hyperlink datatype. see this link - https://codekabinett.com/rdumps.php?Lang=2&targetDoc=access-hyperlink-data-type It's much easier to use plain text to store a path and vba to follow it.

Here's an example i made for someone on another forum. It does not store the path to any files. when the database is opened it creates a folder named Clients in the same folder as the database. When you enter a new client and open the client form, it will create a folder for that client within...

A lot depends on how your file folders are set up and how your Pdf's are named. I tend to have one main folder with subfolders. The subfolders are named for each client and hold just the files related to that client. That way I don't have to store the path to any file or worry that any 2 files...

Might depend on how you broke them.