Search results for query: *

Here is what I am up against. I currently have a couple of Workspaces/Projects set up that are used to calculate auto insurance premiums. Upon building each project, a dll is created and placed in a given directory to be called by a VB6 front end. Everything was set up when I was hired so...

Macropod, You're exactly right, ... My code "worked" but didn't perform the task I was hoping it would. [sad] Yours on the other hand, ... was awesome!! [thumbsup] Thank you for giving me the assistance I needed to accomplish the task at hand. Your time and effort are much appreciated!! Thank...

Thank you Mike! That did the trick.

Can anyone tell me why the following code causes an error when executed within Word?? I'm getting a "run-time error 424 object required" ActiveDocument.MailMerge.Fields(i).Code = "{If {" & ActiveDocument.MailMerge.Fields(i).Code & "} =" & Chr(34) & Chr(34) & _ " " & Chr(34) & "XX" &...

Macropod, Thank you for the code! I've not had a chance to put it in place and test it in my scenario but it looks promising. In regards to the check boxes. These are merge fields. The original owner of the mail merge documents set them up so if a mail merge value met certain criteria, then...

Gerry, The IF statement is set up correctly. It states, IF FIELD_IN_QUESTION is NOT EQUAL to NULL (it has data) then use FIELD_IN_QUESTIONS'S value, ELSE "MISSING DATA" I follow what macropod is saying. However, what I'd like to do is not put any text in the area needing it (thus the "...

macropod, If you can give me further direction that would be great!! I tried to make the inserted IF statements work for me but I never could figure it out! In addition, is there a way to put blank spaces ( " " ) instead of "MISSING DATA" AND have it's background highlighted?? One...

Macropod, Sorry I'm being so dense here!! You make a very valid point with trying to do anything after the merge. However, can I do the highlighting on all merge fields without coding each one possible?

I'm not sure if I asked the appropriate questions in my last post to get a clear answer. So we'll try again! I have code which will highlight fields left blank after a mail merge has occurred. However, this code is all static in nature. That is, every merge field is coded "behind the macro"...

Macropod, Thanks for the reply. Do you know if there is any way to apply the IF statement to all mergefields within a Word document. That is, with 200+ forms, adding an IF statement to all mergefields within all of the possible forms is not a time or money wise option. I'm envisioning [ponder]...

I am looking for help in automating MS Word. Here is my situation: There is an Access Database that houses all data used in a mail merge. However, I have roughly 200 forms that can be used in the mail merge depending on the situation at hand. What I'd like to do is have Word dynamically...

Try this =Sum(IIf([Role]="fyi",0,[your priority number])/Sum(IIf([Role]="fyi",0,1) The first portion is getting the sum of all values where role <> "FYI" The sencond portion is getting the count of records where role <> "FYI" Hope this helps. Dan

VBSlammer, I currently have the ftp portion of this taken care of. (Although your code proves to be a little easier to follow) What I'm really looking for is a way to ensure that my end users won't "mess up" the ftp by being in the database table when the time comes to move the file. Does...

I'm looking for advice on how to best set up a 2000 database that will move a given file to a ftp server using a form's timer event.(i think) Here is the situation: I have set up a database that customer service reps will use in order to track their incoming phone call information. A client...

Dr. Simon, Your solution does work, ... however, I need the error checking code to work more so than I need the ability to evaluate any expression. Thanks for the info though!! I think I'll keep it in my "code library" in case it's ever needed! [thumbsup2] Thanks, Dan

It doesn't like the Evaluate expression?!?! It tells me that the "sub or function is not defined"

I am trying to set up a small bit of error checking code in order for my end users to get a "second chance" at entering valid data. They wanted the ability to "add" numbers together while counting documents without using a calulator (or God forbid they use their head!!!) SO they are entering a...

dhookom, I guess that is part of my question as well. How is it best to identify to Access that the 3 records the end user just entered are the records I need to print. I can add a field to my table in order to "tag" the records but I'm not sure where this will get me either?? The "info just...

Maybe I'm over thinking this, ... BUT I have a very basic form that accepts a date, Client, Count and Type. What I need to do is print a report (Header tag for a group of documetns) after every three entries on this form. i.e., End user enters: Date Client Count Type 11/8/04 ABC...

I am trying to open Lotus Notes 6.5 on my Windows 2000 machine but have hit a small road block. When I call the code to open Notes all I get is a quick flash of the "Lotus Notes Splash Screen" and then nothing happens. If I use a shorcut on my desktop it opens fine and gives me the password...