Recent content by dwcolt

I found this incredibly helpful code that allows a user to drag and drop an Outlook file directly into Access and store a copy on the specified drive. http://www.tek-tips.com/viewthread.cfm?qid=1346884 I'm trying to figure out if there is a way for a user to drag an individual ATTACHMENT from...

I'll have to chalk that up to email notification; I would have had no clue otherwise!

Well, to add some context, I received a PM from another member asking about this solution. I don't have enough posts to be able to respond to a PM, so I had to post my solution here!

Thanks everyone for the help! Here is the final script that solved the problem: Private Sub EmailMarkedDocuments_Click() On Error GoTo Email_Err_Clear Dim MyDB As Database Dim MyRS As Recordset Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Dim...

I've installed Windows Search Service (Windows Search 4.0) on SBS Server 2008. I am trying to locate a script that would access the index and allow for full-text searching. Essentially, I would like to be able to type in a word or string into a searchbox, and have MS Access query the...

As my other post indicates, I am having problems with the mapnetworkdrive command for a variety of reasons. Is there any alternative VB script I could use to map a network drive from within Access? Any insight would sure be appreciated!!

This is driving me crazy. I have a button that maps a network drive. Here is the code: Dim objNetwork Dim fs As Object Set objNetwork = CreateObject("WScript.Network") Set fs = CreateObject("Scripting.FileSystemObject") objNetwork.MapNetworkDrive "I:", "\\10.100.1.10" The first time I click on...

This is driving me crazy. I have a button that maps a network drive. Here is the code: Dim objNetwork Dim fs As Object Set objNetwork = CreateObject("WScript.Network") Set fs = CreateObject("Scripting.FileSystemObject") objNetwork.MapNetworkDrive "I:", "\\10.100.1.10" The first time I click on...

Got it working like a charm! Thanks so much for the insight. Here's the final code: Private Sub UploadToIpad_Click() On Error GoTo Form_Error If IsNull(Me.TimekeeperName) = True Then MsgBox "Select an available timekeeper to begin the upload.", 0, "CW Case Management System" Else...

Ok, follow up problem. I am using this script to upload files to a remote tablet. When I map a network drive to the tablet using the tablet's IP address, the file copies over just fine with the drive letter as the upload path. But I want to be able to upload directly to an IP address...

Fantastic. I was tinkering with this and getting very close to that solution. Thanks so much!!

My previous post on this may have been overly complicated, so here is the simplified version. I have a table that contains hyperlinks to various files. I want to write a simple script that will take each hyperlink and then copy the actual file into a pre-specified folder. If anyone could...

BINGO!!!!!! That was exactly it. Script works perfectly now! Thanks so much.

Thanks, but this seems to have the same loop structure that I already have. Any other ideas?

Help! For the life of me I cannot figure out what I'm doing wrong. I have a Microsoft Access query that lists the full directory path for a number of files. I tried to write a script that will create a new email message in Outlook that attaches each of the files listed in the query. The user...