Search results

Public Function CalcAge_2(Hire_Date As Date) As String Dim intYears As Integer intYears = DateDiff("yyyy", Hire_Date, Date) If intYears < 1 Then CalcAge_2 = DateDiff("m", Hire_Date, Date) + (Day(Date) < Day(Hire_Date)) & " months" Else CalcAge_2 = intYears +...

With a table structure like the one @plog shows (unpivot to the source table), not only is the selection easy, but the table can also be easily maintained by the user via an additional user interface => no reprogramming necessary when changes are made. Database-compliant structures => mostly...

I also base my statements on my own experience. An rs.FindFirst is also noticeably slow with large tables. In this case, it would be better to use Seek or the intermediate step via collection/dictionary. When writing to a table, I would only set the index to be used later after the data has...

Iterate twice? I find it more efficient to write all relevant folders with its files into a table, you need one pass to enter new files anyway. Once I have a table, I can simply compare it with a table, a DB developer can write queries. A worse choice: rs.FindFirst... it's really worth it to...

I think it is extremely problematic to make a blanket judgement about a group of about 2,000,000,000 people. Moderate Muslims are certainly better for a society than Catholic mafiosi. Atheists who share humanist values may be even better.

OK, it worked for me, but I didn't have spaces in the names anywhere. Some cosmetic work for an extension: Public Function ListFilesToFile(ByVal StartDirectory As String, _ ByVal PathOutputFile As String, _ Optional ByVal...

No. Have you tested it yet, or are you just thinking about it?

The dictionary objects dictClipsDB and dictFilesFound must first be filled. How is this done? Analyzing the file system will take some time in itself, depending on the volume, and will contribute to the slowness. A dictionary and a collection offer very fast direct individual access to...

Create a view in SQL Server and link it as a table in your frontend. https://www.sqltutorial.org/sql-window-functions/sql-row_number/

Functionally, this already happens with the following expression: WHERE A.ID>=ID @naobao For the method used, you need a field whose sorted contents reflect the exact order required. The ID field alone does not provide this. Are there any other fields in the table, perhaps a usable one? If you...

I read something in the linked topic. 1st consideration: Before you think about codes, it is useful to think about conditions and processes. You have a CSV file with 1143 columns as a starting point. MS Access (Jet/ACE) can only manage 255 columns in a table and in a query. If MS Access is to...

I don't live in a glass house, and I certainly don't throw stones, not even for fun. But it seems to me that there is no mirror in your house that gives you a real image of yourself.

There is a lot of hate, intolerance and impudence in such a statement. That's probably how it has to be if you're fixated on people rather than politics.

Wasn't Kamala co-elected as Vice President? I read that Trump is very angry because he invested a lot of money in insults against Biden that have now ended up in the trash.

In principle, this shouldn't work.

As already described above, I experience something different in my environments than @The_Doc_Man describes, I don't have any unwanted locks on linked text files. The devil is in the details. I pointed out above that you describe EXACTLY what you are doing. Such a description could be presented...

Connection Strings can sometimes help. I wrote down the notation used above from an example many years ago, and it has never caused me any problems. I think it was also available in earlier versions of Connection Strings.

Cleaner than DMax is pure SQL, in this case a subquery. SELECT [FieldList], (SELECT MAX(DateValue(InteractionDate)) FROM InteractionT WHERE PersonID = PersonT.PersonID AND InteractionDate > 0) AS MaxDate FROM PersonT If no record meets the criteria or the table contains no records...

I suspect that the text file is opened separately in addition to the database access and is therefore causing problems. Alternatively, if the linked text file always has the same path and name, you don't need to delete anything. You can then replace an existing file with a newer version. You...

Describe what you mean by open. Only something that is open needs to be closed.