Solved problem with Dir function (1 Viewer)

[Gasman]

You have to look to see what tha variables contain?
Debug.Print FilePath and look to see what that is.

Access does not lie

 

[poppajim713]

I tried

 Kill Trim(FilePath)

to see if what I'd get. I got an error 53, file not found.

I am hanging my head in shame. I found the problem. I was creating a backup in one function that used

 Format(Date, "m-d-yy")

to create the name of the file, but in another function to delete the oldest file, from 3 days ago, I used the DateAdd function but didn't format that. So, I was comparing 12-2-22 to 12-2-2022. It's working fine now. I'm sorry, but thanks to all. The suggestion to use debug.print really helped. When I saw the 2 together is when I realized what a bonehead I was. Thanks again!

 

[Gasman]

Please mark it Solved then.

 

[poppajim713]

Please mark it Solved then.

I'm not sure how

 

[Gasman]

I'm not sure how

Top right of the thread, should be thread tools or something similar. Only the O/P can see it?

Edit: Actually, there is a Solved toggle button top right, next to an Unwatch button.

 

[Isaac]

I would strongly recommend switching to use Createobject("scripting.filesystemobject").fileexists("path to file") (yields true or false) instead.
For this purpose.

Dir is a very nuanced, command that can be used in a multitude of different fascinating ways, much more than it seems at first glance.

FYI, back when I used DIR to check file existence, I usually tested things like this:

If Dir(path to file)="" then [doesn't exist]
Rather than assigning Dir(path) as the assigned value to a string variable - ESPECIALLY with 'on error resume next' in front of it, which you should immediately remove while troubleshooting especially as well as permanently, as all it does is COVER UP errors that might HELP you figure out what is wrong - the absolute last thing you'd want right now!

The final way you settled (solved) on doing, that actually checks for the existence of any files matching that wildcard description - which isn't really an exact test you originally wanted, and probably thus isn't an ideal solution.

 

[poppajim713]

I would strongly recommend switching to use Createobject("scripting.filesystemobject").fileexists("path to file") (yields true or false) instead.
For this purpose.

Dir is a very nuanced, command that can be used in a multitude of different fascinating ways, much more than it seems at first glance.

FYI, back when I used DIR to check file existence, I usually tested things like this:

If Dir(path to file)="" then [doesn't exist]
Rather than assigning Dir(path) as the assigned value to a string variable - ESPECIALLY with 'on error resume next' in front of it, which you should immediately remove while troubleshooting especially as well as permanently, as all it does is COVER UP errors that might HELP you figure out what is wrong - the absolute last thing you'd want right now!

The final way you settled (solved) on doing, that actually checks for the existence of any files matching that wildcard description - which isn't really an exact test you originally wanted, and probably thus isn't an ideal solution.

Thanks for the help

 

[poppajim713]

Please mark it Solved then.

I'm sorry, but all I see is jump to new, Unwatch and a dropdown with edit thread and create poll

 

[Gasman]

 

[poppajim713]

Mine looks like this

 

[Gasman]

And is that on the first page?

 

[poppajim713]

And is that on the first page?

Just checked. It's on both

 

[Gasman]

Just checked. It's on both

Ok, forget it then.

Not sure why you do not have that button as you are the O/P.

I can only *guess* it might be because it is in the Introduce Yourself forum, and nothing really should be solved there?

Perhaps @Jon can confirm?

 

[poppajim713]

Ok, forget it then.

Not sure why you do not have that button as you are the O/P.

I asked DBguy. He's not sure either. Maybe there's an admin person?

 

[Gasman]

I asked DBguy. He's not sure either. Maybe there's an admin person?

Well I have linked this thread to the site owner, so if he does not know, we are screwed.

Perhaps an admin can move it to a suitable forum?
@theDBguy @The_Doc_Man, anyone?

 

[poppajim713]

Ok, forget it then.

Not sure why you do not have that button as you are the O/P.

I can only *guess* it might be because it is in the Introduce Yourself forum, and nothing really should be solved there?

Perhaps @Jon can confirm?

That makes sense. Rookie move on my part.