Search:

32064

I've got a number of responses to our comment card forms entered into a db and I've begun to analyse the data. Each department has multiple fields/categories they are scored on. One thing...

I ended up getting it with this code:

Option Compare Database
Option Explicit


Sub SendMessagePos(Optional AttachmentPath)
Dim objOutlook As Outlook.Application
Dim objOutlookMsg As...

Thanks for this.

The field I am testing is tblWorkOrder.CompletedDate. If there is a value (date value, obv) in here, the WO should be finished. If it is blank, the WO is unfinished. It seems...

I'd like to set up a button on a form that will take information from that record and send an email to the address on the form. I want the body of the email to be a form letter with fields from the...

I have a table of work orders. I have designed a query that filters it via a number of combo boxes on a form, but I have run into a snag trying to implement one more filter. I'd like to have an...

found some code here (http://msdn.microsoft.com/en-us/library/cc793964%28v=office.12%29.aspx) that I'm going to try and use

I have a workbook with many tabs, one for each room/area of a hotel (102, 103, 104, Library, Kitchen, etc). On each of these tabs is a list of jobs pertaining to that room. Some rooms have many...

I have a list of sheet names that I want to be able to navigate easily. I'd like to add a formula into the cell next to each sheet name that will automatically generate a hyperlink based on the...

I have a spreadsheet with many sheets where I want to hide the same rows on all but the first 3 sheets. Sheet 1 is the summary page - on this sheet I enter a date range (also have a pair of cells...

Figured it out. The code was correct, however, it assumed that the short date order used by Word/Windows was DD-MM-YY. Since I'm dealing with an American piece of software, it was giving MM-DD-YY,...

Yes, I found that tutorial but the code example doesn't seem to work properly. I chose the sample "Calculate a day, date, month and year, using n days delay" but it seems to be adding n months...

I have a field {arrival} which is a date. I want to display {arrival+3}, expressed as a day of the week. So if {arrival} is a Friday, I want to be able to output "Monday" in my document. I tried...

There's five (2 BD-TP, 2 BD-NS, 1 BD-NS, 2BD, 1BD) but that makes sense, thanks.

Yeah, I found that out the hard way. Working around it:

{ IF { MERGEFIELD RoomTypeID } = "*TP""Twin Peaks" }{ IF { MERGEFIELD RoomTypeID } = "*NS""Twin Peaks (Northstar)"}{ IF { MERGEFIELD...

OK, this is a confirmed bug in the proprietary db app I'm using, but thanks for the help Paul.

Same error

If I insert it alone (no IF) it works fine (returns 2 BD-TP, for example). I think that's what you're asking - the merge field works fine when simply inserting it's value into the .dot

In a kludgy attempt to bypass evaluating the fields that have spaces in the them, I've written the following, but it's not working either because as soon as RoomTypeID is evaluated it kicks out the...

The braces are from Ctrl-F9, so that's not it. Sometimes the field contains no spaces (ie: 2BD) when that's the case everything works. However when it does have a space, I get the op code error.
...

i'm trying to do a conditional mail merge but i get "Error! Unknown op code for conditional" when the value of the field I'm testing has a space embedded in it.

{ IF { MERGEFIELD RoomTypeID } = "2...

I'll try that tomorrow but it looks like it is what I want.

I wasn't doublequoting my singlequotes, if that makes sense /forums/images/smilies/smile.gif

Thanks!

This is in a worksheet - the Summary worksheet.

VAR1,2,3 are what I trying to figure out how to use - they are just how "I" think it should work...

VAR1 = the text in column A; the employee...

I have a formula that i want to introduce variables into but am unsure how to do so.

=SUM('employee name'!Q$113:Q$123)+SUM('employee name'!U$113:U$123)+SUM('employee name'!W$113:W$123)
is the...

Thanks Hans - works beautifully.

For anyone wanting to use the above - a closing parathesis is missing.

Jon

Hans -

The second suggestion is what I would like to do, and works great! Is there an easy way to keep the xxxx-xxxx from displaying in the case of a null value in that field?