Dale Kalsow
dkalsow at yahoo.com
Mon May 21 13:26:45 CDT 2012
Good Afternoon, I have the following code running behind a button in VBA: Private Sub btnFileShare_Click() Dim strDirectory As String strDirectory = strMasterPath & Me!txtCaseID.Value If Dir(strDirectory, vbDirectory) = "" Then CreateDirectory (strDirectory) End If Dim X As Variant X = Shell("C:\windows\explorer.exe " & strDirectory, vbNormalFocus) End Sub Public Sub CreateDirectory(sPath As String) On Error GoTo DirectoryError Dim sPathPart As String Dim i As Integer MkDir sPath Exit Sub DirectoryError: Resume Next End Sub If is working properly. My question is can the window that opens be contained in a tab on an access tab. In other words, I have one tab for general client information. One tab for payments from that client. And one tab for a fileshare where the user can please any documents relating to the client. Thanks! Dale ________________________________ From: jwcolby <jwcolby at colbyconsulting.com> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Sent: Monday, May 21, 2012 8:53 AM Subject: [AccessD] Blatt or other email Does anyone have a "plug and play" library for an email package other than Outlook? I need to send email with attachments. I am hoping that someone has written a module for Access which I can just drop in, place a dll or something in a known location and start sending email. -- John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com