Darrell Burns
dhb at flsi.com
Fri Jun 24 17:11:07 CDT 2011
Re: Status_Msg I place a view-only textbox control at the top of every form called "StatusMsg" for displaying instructions, warnings, error messages, etc. The arguments are: txtMsg as string, FormName as string, ColorCode as integer. Colorcode controls the font colors...1=Green, 2=Yellow, 3=Red. The background is dark. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Friday, June 24, 2011 9:05 AM To: Access Developers discussion and problem solving Subject: [Spam]8.31 Re: [AccessD] Does a directory exist? What is the proc Status_Msg? Arthur On Fri, Jun 24, 2011 at 11:50 AM, Darrell Burns <dhb at flsi.com> wrote: > Here's a function that I use... > > Private Function VerifyFolder(path) As Integer > On Error GoTo VerifyFolder_err > Set fso = CreateObject("Scripting.FileSystemObject") > Set Folder = fso.GetFolder(path) 'throws exception if folder doesn't > exist > VerifyFolder = True > Exit Function > VerifyFolder_err: > Status_Msg "Folder does not exist: " + path, stMsgForm, 3 > VerifyFolder = False > End Function > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com