Search results

Hi. I figured I should round back and provide an update. There was no defaulted schema ini file in the directory. I opted to just create a function from scratch that punts the recordset to a file. Worked for my purposes and moved on. The issue with the MS built-in function remains a mystery...

Hi. No format function. The source query to this query to be outputted determines the value of this field using DateSerial to land on the last day of the month. Even if this were text I do not think it a good idea that the transferText function lops off even a single character of any format...

Hello. I have a subroutine that exports the tabular results of a query to a csv file using.. DoCmd.TransferText acExportDelim, , sQry, sPath, True Very straight forward but it truncates the invoice date column clipping of the right most digit. ie what should read in the outputted file...

Yes. Very nice. I needed that proof of concept. The problem was not what I had initially thought. Thank you for helping me dispel that. As it turned out I was trying to assign a string array to an array of user defined types. The fact that I had an array of UDTs that had a UDT array as a member...

Hello. I have a user defined type that has a member variable that is a string array. I cannot seem to get an instance of that UDT to have it's array member be assigned an array from a FunctionThatReturnsAnArray("blah"). The semi-pseudocode below is a simplified version of what I'm trying to...

The negative lookback isn't working either. It is after-all a limitation of the VBScript.regex function. A shame because lookforward and lookback are both equally valuable. I'll just move ahead without it. Thanks to you both.

I am using Guus2005's Regular expression function so graciously contributed to the code repository. It's been great so far. I have run into a bit of an issue regarding the 'lookaround' functionality (allows a pattern match to be broader than the return value). immediate: 'The positive...