Recent content by freeon

After testing if I continue using it I will definitely donate.

I thought about it but wasn't sure it was allowed. http://www.emdb.eu/

Colin Thank you for your time and help. Your last post got me to thinking. Surely in this day and age such a software must already exist. Not sure why I never though of searching for one before, however I have found one. It's called Eric's Movie Database and it's free. It does way more than I...

Maybe I should have started with what my end goal was. I have transferred my DVD collection to my PC and I'm trying to build sort of an interface to sort them. Genres and actors I will add manually and the will be able to apply filters based on different criteria. I was hoping I could launch the...

When I click on it now I get the security notice and in that window the path is show with the file name at the end so everything appears ok. However when I click open anyway I get error 490.

OK so now I have it setup to run the code then open the form when the database opens. It works, however every-time it opens it re adds all the files to the list. Anyway to only add names that don't exist in the list? As for hyperlink I was able to make work, sort off. Using the...

I'm using below code found on another site to list all files in a specific folder and all of it's sub folder. When I run the code I get a message saying files were added, however the table remains blank. As soon as I hit F5 the table loads as it should. What can I add to the code so the table is...

I can't believe it was this simple. My original code works. Even with this "Set objShortCut = objWSH.CreateShortcut(strShortcutPath & strShortcutName)" it puts shortcut in correct folder and doesn't put estimator name in the shortcut name. If I remove "strShortcutPath" it doesn't work at all...

As I mentioned before this is from excel workbook and was setup a bit differently in excel and obviously I'm doing something wrong when modifying to work in access. I am new to access and obviously missing something. Shortcut file and shortcut file are not the same thing. Or shouldn't be...

This is not working. It does nothing, doesn't create any shortcuts anywhere. If I add " strShortcutPath & " back to the code it works, just wrong name and wrong location for the shortcut. Private Sub Command247_Click() Dim fdObj As Object Dim objWSH As IWshRuntimeLibrary.WshShell Dim...

So how do I fix it? I tried removing below and get error 91. Set objShortCut = objWSH.CreateShortcut(strShortcutPath & strShortcutName) If I only remove "strShortcutPath & strShortcutName" I get "argument not optional Set objShortCut = objWSH.CreateShortcut()

I want to create a shortcut to a folder. Shortcut name is to be based on project name in textbox on a form called ProjectName. The shortcut location is to be based on name in a combo box on the same form called ComboEstimator. Code below does create the shortcut however it names the shortcut...

As I said I'm new to access. I just didn't get what he was saying.

OMG :cool:. I was using "lblTitle" from Label Name instead of using Title from Name. Also there is \ after access(it's just not showing up in the post for some reason). So it creates the new folder named after the project to the access folder. Everything works now...

The text in lblTitle is letters only. No illegal characters. I'm just trying to create a folder named after the text in the textbox. Project and access folder already exist. The final form will have more fields, I'm just trying to start with a simple form to get it working.