Browse [Find a directory or file]

[mveijndh]

Hi,
I've just downloaded the sample database
Browse [Find a directory or file], 97787 browse
I do like the set up of it, but I need to use a default location as that is based on year and month. Can I use a string that would land me on the default location first?

 

[Uncle Gizmo]

What do you mean by "year and month"?

 

[mveijndh]

I meant I want to save my files in default directories, so one directory for 2015, one directory for 2016. in 2016, 12 directorys for each month one directory.
I want to be able to automaticly create the directory if it does not exist and I want to automaticly save the file in that month for that year.
I did have a look at other posts, but did not find it, or did not see it!

Have a great 2016!

 

[Uncle Gizmo]

You need to break your problem down into steps.

1) extract the month and year from today's date.

2) build a UNC from the combination of the month and year (extracted above) and your default location.

3) check your directories to see if the UNC created above exists, if it does not exist then you need to create it.

4) now we come back to your original question how do you pass this UNC into ghudson's code?

http://www.access-programmers.co.uk/forums/showthread.php?t=97787

I suggest you research those questions, they have all been answered before. If you have difficulty finding an answer, repost each step as a separate question and build your solution like that.

 

[mveijndh]

Hi Gizmo,
Thanks for your reply. I'd seperated the steps, and found the solution for the default save Directory. I've not implemented it as priorities shifted!

 

[mveijndh]

I can't open the example database browsing.mdb from ghudson as this was made in an earlier version. Any updates on that one or a work around

 

[Uncle Gizmo]

Someone might convert it for you if you post a request in a new thread... If they do please make sure that the converted database is available for someone else.

If the sample database thread is locked (they usually are) let a moderator know and they should be able to add the converted database to that thread.