Recent content by linxpatrick

I took a look at Module1. Within the function fncCummuAbsent, there are no comments to explain what you want to happen. For example, what is ayDI? You can safely use up to 32 characters in a function name so why not expand fncCummuAbsent to it's full name. Not sure what Cummu means but I...

Hoped you would notice that I joined. Thank you for the link.

Break the absences apart by year, month. and the number of days absent per block of days absent. 1111 01/01/1019 to 12/01/2019 would be broken apart into 2019 for the year, 1 for the month and 11 for the days. If the start of the period you are testing begins on 11/01/2019 you will have to...

I have a couple applications that I've been preparing for 64 bit Office but still run on 32 bit Office. The difference between coding a 32 and 64 bit Access application has to do with some of the data sizes and calling Windows APIs. When declaring Windows APIs you have to check to see if you...

Incomplete code Dim lngPosition as Long Dim strPath as String strPath = "C:\TEST\tempfoldera\" lngPosition = InStr(1, strFolder, "\") 'This returns the position of the first backslash. lngPosition = Instr(lngPosition + 1, strFolder, "\") 'The position for the second back-slash strPath =...

The way I imagine accomplishing what you are talking about is something like this. You will have a table for the description of the project. At a minimum it will require a record ID that uniquely identifies the record so that you can link records in other tables to it. The record ID should not...

Hello all. My name is Patrick. I have been working with MS Access and other database and application technologies since 1997. I have my own company, creating custom database applications for businesses that require them. Besides Access I work in PHP, Python and some other languages and with...