Search results

That makes sense. Rookie move on my part.

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

Just checked. It's on both

Mine looks like this

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

Thanks for the help

I'm not sure how

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...

I tried Kill Trim(FilePath) to see if what I'd get. I got an error 53, file not found.

I'll look it over

I changed one line to this and it worked. FilePath = "C:\Users\smltu\Backup\*.mdb"

this is the code I tried. the first one the folder exist, but the second one the file doesn't exist. Dim FolderPath As String FolderPath = "C:\Users\smltu\Backup" If Right(FolderPath, 1) <> "\" Then FolderPath = FolderPath & "\" End If If Dir(FolderPath...

I tried some code that found a folder, but not a file in that folder

I did a bit of research. I think Environ started with Access 2007. I'm still using 2003.

Yes

This is exactly what I tested. sTxt = "12-1-2022.mdb" sFile = Environ("Userprofile") & "\Backup\" & sTxt Debug.Print sFile nothing happens. Thanks anyway.

Nothing

I'll give it a go. Thanks

I've tried using all text within the Dir function like sFile = "C:\Users\file.txt" which works, but trying Dim sTxt As String sTxt = "file.txt" sFile = "C:\Users\" & sTxt doesn't work. The file is not found.

I am brand new to this forum. Hello All!