Search results

Hi Colin, Thank you very much! I am working on this now, can you please clarify if I am understanding the code correctly: -TableName after UPDATE is the table I want to change -TableName after SET is the same (table I want to change) DocumentStatus is the column I want to change. -...

Hi Colin, Any advice on how? Thanks.

Hi, So I have two Tables a "Master list" and an "Up issue list" and two corresponding forms. The User inputs new records into the Master list using the form, the columns/fields are; Document number, Document name, Document status and Date. The initial Document status of all documents is IN...

Thanks sxschech, that's good to know for the future!

Ok so I have managed to solve my original question! :D The text box now displays the filename only not the whole file path. The textbox only displays the file if it copies successfully Below is the code for anyone who is interested: Private Sub Button_Click() Dim CopyDialog As...

Thanks for your help moke123, you have given me some good ideas. I will keep working on it! :)

Converted to 64 bit by adding ptrSafe to all declare functions. Doesn't appear to be any problems when I debug but nothing appears to happen when I click the button on my form.

Thank you Moke123, I have added modFileFolderExists but modBrowseFiles and modShellExec are for 32 bit systems. I'm running 64. I will look into the conversion and let you know if I get it working.

Thanks Moke123, The code looks great I think it will do what I'm after. I have copied it into my database and am getting a Compile error, "sub or function not defined" on If FileExists. Any tips on how to fix this? Why would this occur? References? Thank you!

Thanks sxschech! Definitely don't want any files replaced. But having the option to rename would be great! I mentioned two buttons so the user selects a file to "upload" and then confirms that its the correct file before "saving". Maybe a message box could do the same job i.e. the user...

Thank you very much sxschech. The User selects one file at a time hence ".AllowMultiSelect = False" The User clicks one button that brings up the dialog box the user selects the source file and it automatically pings to the destination 'targetFile = "X:\Simone" ' . So currently its just one...

Thanks sxschech, This is helpful, however, I'm unsure of how this works with my existing code. :confused: Do I remove the FileDialog and use this instead. How do I use the function and the existing sub together? If I create a module and change my command button to 'RunCode' can I choose to...

Hi! When you click a button on my form the code currently opens a file viewer and copies the file selected by the user to a new folder. The original file path is displayed in a text box which is bound to a cell in my table. I want the text box (and corresponding cell in the table) to only...

Yesssss!!!! After your suggestion I moved "End With" to before the Sub Exit/Sub Error part of the code. Success, "Dim fDialog As Office.FileDialog" now works! =] Thanks!!

Weridly "Dim fDialog As FileDialog" didn't work, same Error; Type Mismatch Error 13.

Hi The_Doc_Man, Thank you very much!! Dim fDialog As Object has done the trick. :)

Thanks for your reply Galaxiom, Here is the code: Private Sub OpenDialogBtn_Click() 'On Error GoTo SubError (Suspended for Debug) 'Add Microsoft Office Object Library in References Dim fDialog As Office.FileDialog Dim varFile As Variant FileViewerTxt = "" 'Set...

Hi! So I'm trying to use FileDialog on a form, I have a created an event OnClick of a button and have a Text Box to display the result. Whenever I click said button, I get a Run-time error '13' Type Mismatch Debug takes me to this line of code: Set fDialog =...