Recent content by ksor

Mama Mie, blow your horn !:D

Biting the hand that feeds you is no good - that's right ! But if you go to a store asking for something they don't have - you go to the next store :D - that's how life is !

Instead of you acting as police - why don't you answer my question instead :p

I use these lines to delete the records from a temporary table and reset ID automumbering to start from 1 again: DoCmd.SetWarnings False DoCmd.RunSQL "DELETE * FROM [INFOs midlertidig]" DoCmd.RunSQL "ALTER TABLE [INFOs midlertidig] ALTER COLUMN [Id] COUNTER(1,1);"...

Argh ... ofcause it worked ! THX to both of you !

I have a textbox in a continuous form, placed behind all other controls and I want it DISABLED. I use it for highliting the record i focus with a special color - and it works, but ... When a record is NOT in focus I just want to see that "behind-textbox" but not with the DISABLED standard...

What is FSO ?:confused:

> Gasman Yep !

Yeah, it works nicely BUT you can NOT, while running through the files, use Dir() one more time. Why do that, you say - in my case I was (wrongly !) running through Word-documents using Dir() and examine each of them for Hyperlinks to a local FILE - and here I used Dir() one more time to test if...

The overall goal is here to test if the Hyperlinks links to an existing local file OR an URL. A part of testing for a local file is using Dir() :mad: - that's the problem !:banghead: So I just collected all file names into an array and use this array as the primary Dir() - and It works like...

Because the link I gave tells what's the problem = Dir() command CAN*T be used "nested" - the second use will _BEEP_ the first use. In MY case I had to collect ALL file names in an array first and then run through this array and examin each file for hyperlinks - and it works nicely !

Here is a similar problem: https://bytes.com/topic/access/answers/192904-dir-function-problem

I don't get you there ... it stoppes at the specific line I pointed out earlier and if I step further I just get the same error message again ???????? I have Debug.Print the files and it runs through and the suddenly the "chain" is broken and the error comes up ... there are much more files...

But this danish 'ae' is too in the folder name on the folder that runs with NO error. I only gave the LAST part of the folder name C:\Users\ksor\Documents\Slægtsforskning\Slægtsfors kning_V4\BAFO_docs\ gives NO error ! C:\Users\ksor\Documents\Slægtsforskning\Slægtsfors kning_V4\BO_docs\ -...

As I write just under the code.