Search results for query: *

Hi lameid, thank you for your help. I was trying to avoid using a file dialog but as you say it may be too hard using Windows Explorer, I've spent a fair bit of time on it already. I will try the dialog idea or I may have to rethink what I am trying to achieve. Appreciate your help Lameid...

Hi all, I have a button on a form to open Windows Explorer and select a file variable set in the code. I want to pause the execution of the code while the Explorer window is open. I am using WScript.Shell as below but the code continues to run, Explorer opens and correctly selects the file. It...

Hi jrbarnett, Thank you, the ChDir function works well, thanks for the suggestion, quick and neat. I called the routine from within the TransferWithUI and TransferWithOutUI functions, depends on which interface you wish to use. Thank you to all who contributed [thumbsup2] Code below for...

Thanks jrbarnett, I'll give ChDir a go, certainly a bit more elegant. I don't think any posts are missing strongm. I'm in a different time zone, hence the delay.

Sorry strongm, I missed your post. Yes the path exists but the code seems to be trying to save as a filename and a filename with : and \ is not allowed.

I have come up with a workaround. At the point where the file is saved in the scanner code (Open sFileName For Binary As #iFileNum) I have used the GetOption and SetOption functions to get the current database default folder (as set in Options under the General tab) and set it to where I want...

I tried that but it doesn't save the file at all. It gets to the function 'SaveDIBToFile' and the line 'Open sFileName For Binary As #iFileNum' and generates the error "Path/File access error".

I am using the TWAIN scanner code written by Lumir Mik's (lmik@seznam.cz) to scan documents into Access. It works very well but doesn't give the option of setting the folder to save the scanned document. It currently saves the file to the Default Database Folder set in Access options. I have...