Search results

I have an old habit of trying to use "not" and "=" rather than "<>" - in this particular instance, though, it makes no difference, since either way, Dir(strPath & strFilename) returns the error regardless of how it's evaluated.

Sorry for not being clear - I know what the error is. My question is that, if it is a bad file name, why does it cause an error rather than return an empty string? Further, when I type the literal file path and file name into the Immediate window prompt, while the VB is in break mode, I do in...

I'm trying to delete a file in a network location. Sometimes the file is there, sometimes it's not, so I'm using the following code: strPath = "\\network drive\My Folder\" strFilename = "MyFile.doc" If Not Dir(strPath & strFilename) = "" Then Kill strPath & strFilename Occasionally, I get a...

That's true - I realize my response was kind of ambiguous. Sorry about that I solved the problem, though. I used the ADODB.Stream object. It also has LoadFromFile and SaveToFile methods, but is more compatible with the varbinary data type. I'll post the code when I get back to the office on...

OK - I get this, but how do I store the OLE object in the first place? Is there any way to do it in VBA using a file path and file name?

I'll be sure to check them out - at one point this was an ADODB recordset, but I'm woefully unskilled in deailng with ADO compared to DAO (my preference.) Perhaps that's where my troubles began.

I'm trying to store files on a linked SQL Server table, much the way I would using the Attachment data type in Access. (I couldn't use the Attachment data type, though, due to size restrictions - we're storing about a gig a week.) Almost everyone says to store the attachments on a file system...

OK, this one's a doozy... First, I'm developing both the Front End and Back End in Access 2007, and I intend to distribute the application using the Access Run Time. The powers that be will not let me use SQL Server. The database is required to house attachments. Initially, I had created...

What makes it "not pretty" is the quick flash that comes with requerying. Not a huge deal, but I'm sure my end user are going to thing there's something else going on. That said, I really like the idea of using the time to first check to see if there are any data changes before refreshing...

I have a list box that displays the contents of a back-end table that is has a new record added roughly 45 times per hour. I'd like the listbox to refresh automatically when a new record is added and, ultimately, notify the user that the new record is there. Are there any non-form events I can...

Although I've been programming in Access for over 15 years now, this is my first foray into Outlook VBA. The Form thing occurred to me - I need to look into this deeper... Thanks for the tip!

Here's my clunky code. While I am an avid commenter, I'm normally not this thorough; this was done for the sake of lay person who wanted to understand the procedure thoroughly. Public Function GetEmail(newMsg As Outlook.MailItem) As String ' As some of the inquiries will be created by...

Hey folks, I'm building a help-desk application that converts incoming emails to trouble tickets, scarping various details about the inquiry from the body and subject of the message. Some of the emails come directly from clients, making identifying the client fairly simple - I simply compare...

Ugh! I hate those, "Why didn't I think of that?" moments... This is a great idea, especially given that I was just informed that SQL server is not an option. To be fair, this project is little more than a short term solution to help them figure out what they're going to want in an...

Thanks Paul - that thought has occurred to me. Unfortunately, I don't have a ton of SQL Server experience, and I'm just contracted for a short time to accomplish this. I suppose, after finalizing the table design in Access, I could then transfer it to SQL Server; I'm guess maintaining it will...

I could use some advice... I'm developing an Access application that's integrated with Outlook. It's a custom CRM solution that automates trouble tickets based on incoming emails. As such, both Outlook and Access will be running perpetually. This is a multi-user product - about 40 users...

I get that they're tailoring their certifications to match the prevailing winds, but since VB is a widely-used language used in ASP programming, I'm just surprised they haven't bothered to allow for the VB track in the certification process. Oh well, the way I see it, the MCPD cert, though...

I've been an Access Developer for close to 15 years now, and the VBA jobs seem to be dwindling, but I see a lot of VB.Net jobs - almost 10 for every VBA job I find. Since I have a lot of VBA experience in both Access and Excel, I figured I'd take on VB.Net. I'd like to get certified, but it...

Thanks so much, Bob! I have a feeling we were typing this at exactly the same time... :)

Of course, the second I post this, I discover the workaround: Instead of using .InitialFileName I used .SelectedItems(1) I was under the impression from various online sources that ".InitialFileName" would return the selected file - I guess that's not the case.