Recent content by tbellomo

First off, I know -- "Why?" But before we get into "why," just let me know, is it possible? Can I manipulate/create macros from VBA? Possibly through: DBEngine(0)(0).Containers(5).Documents(x) Or is the a table that stores the macro definitions, similar to MSysQueries? Any help would be...

I would have preferred to keep it the way it is, but c'est la vie. I'm trying to configure MAPI with Lotus Notes to use SQL Mail... Server isn't running IIS as well. Thanks, Tim

Hello again. Previously, I had changed the setting from "Local account" to my username & password (which is the local account, isn't it?). Normally, when I run this code in access, all that's required is that I have my Lotus Notes up and running. Do you think I could hard code my username &...

OK...so I was having problems scheduling my DTS's, but those are now resolved. They run on schedule, and succeed. The funny thing is that one portion of the code doesn't run. I use this ActiveX in the DTS to open a database, and run its macro: Function Main() Dim objDB Set objDB =...

Yes, I'm aware of that... I simply don't have the authority to do so though. Thanks for the heads up, Tim

I knew that was the cause, but I hadn't found any threads going into the detail that you did to fix it. THanks Again, Tim

OK -- I figured that it would just use the account that I logged onto Windows 2000 with -- my account -- which has access to all of those directories. I just manually typed in my information. The job "succeeded" -- unforunately, it (the macro) didn't do everything it was supposed to... BUT I...

Both are set to "log on as: Local System Account".

That area is all grayed out on both property windows. Thanks, TIm

Currently, I have them set to run under Windows authentication -- but I've also tried "sa" -- to no avail. Thanks, Tim

Hi everyone, I know that MANY people have had similar problems in the area of a DTS package executing fine, but failing when scheduled. I've read all the threads I could find that dealt with this type of error, but I couldn't find anything that solved my problem. The DTS is a simple ActiveX...

Hello all, I have a couple of functions that do a formatted export to Excel using an xlt template. Option Explicit Dim XLApp As Object Dim XLTemplate As Object Dim XLSheet As Object Public Function fncEE_SetupFile(locTemplate As String, locOutput As String) Set XLApp = New...

Thanks to everyone for your outstanding effort! PHV - I'm not so sure, when I have fncGetDayCrit="In(3,4,5)" the query returns data type mismatch. Doc Simon - It didn't work for my situation, but thanks for the tip... it's gonna help in the future! Gollom - You hit the nail on the head...

If that's the only way to do it, i'll look into... I haven't done it before, but i'm sure I can figure it out. I was just wondering if there was a built in function that would strip the quotes out of the criteria to make In(3,4,5) rather than "In(3,4,5)". Thanks, Timo

I have a conventional query, and in the criteria spot on one of the fields, I put fncGetDaysCrit(). fncGetDaysCrit returns the value "In(3,4,5)", so the query looks for that exact string rather than values of 3, 4, or 5. fncGetDaysCrit is set up to return the value like this: If such and such...