Search results

Recently I viewed a video about Lisp machines. I learned that Richard Stallman was involved in them... then UNIX systems took away the Lisp machine's niche... so no wonder Richard Stallman created GNU which stood for GNU's Not UNIX. :cool::ROFLMAO: I came from a strong background in Borland...

Very good way to discover this very helpful on-line community! This year, exactly 30 years ago I was developing a solution involving: WordPerfect for Windows / Paradox for Windows / DB2 running on OS/2 to drive creation of documents. I used DDE to interact between WordPerfect and Paradox. I...

And for me, the FSO solution complete with editing (opening existing, creating new fixed file) completed in a literal blink of the eye. I cannot imagine 1000x faster than a blink. 🤯 I am thankful,

Oh, I did not know there was one in current VBA. Like I began the thread, Internet search first lead me to a solution which had been removed from Access VBA. A suggestion with sample code came to use a FSO, and I was able to make it work. I will review what DIR is. I am thankful,

Well I finished off the Access VBA tool today. I got the File system searching perfected yesterday, stubbed off code that would get called on a per-file basis. Today's task was merely doing the VBA code via String manipulation to heal the out of spec XML files. Again, drawing from my ooRexx...

???? How would you suggest getting the output of command line DIR back into Access? There is no queue to VBA interface that I know of.... unlike ooRexx which has Rxqueue that you can pipe to and that interfaces directly to the ooRexx memory space. I am thankful,

Ah, very good point! Perhaps I should become less anti-Variant variable data type. I guess when I code, even error handlers, I anticipate things working well enough that things return still the expected data types. You do raise a valid point that should things go very poorly, there is the...

Oh, meaning you typically use Variants for that type of work rather than Variants in some cases, Objects in other cases.... what ever is most appropriate for that section of code? I am thankful,

Interesting.... why the inconsistency? Why the use at all of the dreaded Variant data type? Personally I only use Variant when I need a consistent variable which can itself hold a variety of different data types. Seems like this use case is only able to end up with a fso object, so why not type...

🤣:cool: So was fsoFile or Variant your preferred data type? If Variant, why so? I am thankful,

No..... the link you provided above appears to have had me download your v1.1 version of the example. Dated 2018-03-29. At least that is what Form_frmMain states as the version and date. Very odd. I am thankful,

Greetings theDBguy, Question about your sample code.... Why did you prototype a variable for the fsoFile object, but then not use that variable and instead stick it into a Variant object? I flipped it back the other way, and seems to work using the fsoFile defined as an Object? (I dislike any...

Greetings theDBguy, Wow is it complicated to get a directory listing in VBA! Many LOCs of VBA needed. In the Open Object Rexx (ooRexx) language, it is a single call to SysFileTree. I was able to get your example code working on my work computer, get the needed output of qualifying files in a...

Greetings, I am seeking examples of Access VBA (running in MSO 365 Build 16.0.x 32-bit) of how to obtain file system directory listings. Seems Application.FileSearch is now deprecated / removed. I have heard of using some Microsoft Office Object solution. There might be others that come with...

Correct.... which in my application I skipped the Group concept, and just assigned individual permissions directly to the individual user accounts. It lacks in that you cannot add or remove a specific permission from a logical group of users. On the pro side, I never had to worry about "I want...

Joyful Christmas! Häid Jõule! Rõõmsaid Jõulupühi!

In a Client/Server application I developed with an Access FE, then on the SQL BE DB, it was running on a single shared DB account. The Access FE obtained who the account was of the Windows login, authenticated by matching username. Additionally, those login ID accounts had permissions within...

That was the needed detail.... I had to hard code define which Sheet the VBA code is attached to that I was trying to invoke. Maddening few hours. Yes, I am trying to be fast with this task.... just put up with code built into the sheet, not as a separate Class or Module. In Access, I do not...

Greetings, Working this time in Excel VBA, which is giving me challenges.... Excel spreadsheet, saved to xlsm file format so I can put VBA code in and execute it to manipulate cell contents on the sheet. On the sheet, have a very basic "Hello world!" amount of initial functionality: Option...

Bravo Navatante! Excellent work! For DAO queries and settings variables, see this thread: "Replace pass-through DAO.QueryDef with DAO execution of Stored Procedure Q's"...