Recent content by girls3dog1

PB10.5 MSAccess I'd like to save the edit mask characters to the database when I a save the column data. The edit mask has the following format: XXXX-XXXXXX-XXXX-X. The saved column data would look like the following: 1234-123456-1234-1. Can anyone suggest how I can save the mask characters...

Thanks. I'll review your response. The itemchanged event does not work for me since you have to loose focus for it to fire. I can understand this for a normal edit style column, but not for a dddw style column. So, you're right, it's useless for dddw.

pb10.5, Build 5063 I would like to have the equivalent of a selection change event for a dddw in the same way as a ddlb. Can I do this with a user event using the pbm_cbnselchange? If not, is there another way to code this for a dddw. Thanks in advance for your help.

pb8 I've created a File Data Source (DSN) in the ODBC Administrator and yet when I go try to select it within the Database Profile Setup, it does not appear in the Connection dropdown list of the Database Profile Setup. All I see are System and User DSN's, not File DSN's. What am I doing...

Turns out the problem is by design within MS Word. Modifying the registry based on this KBA solved the problem. http://support.microsoft.com/default.aspx?scid=KB;EN-US;825765

Should the template be a .DOT?

Thanks, but I believe the problem lies in the fact that the following line of code does not open the document file with datasource file attached. If I step through the code in debug I can force it to open correctly and then mailmerge works correctly. I just don't know why this line of code...

doc file with a datasource is being used.

I have a word template file with a datasource defined with it. I open the file in VBA with ...Document.Open("filename") and the file opens with out the datasource. Is there a way to have the template file open with datasource attached? Here's snippet of my code: //Open document and merge...

Pb8 I have a problem with the following code that converts dw to an MS Word file. I get an error message that states the following: "Error calling external object function execute at line 74." Line 74 is the mailmerge.execute, which is shown below. This is my first attempt at ole and...

Yes, I placed the expression in each of the column background color properties. I just tried it again and if I edit any column, then all column background colors change.

Yes...that's my family; a wife, two girls and one dog. I have tried this before (if(isrowmodified(),rgb(255, 255, 0),rgb(255,255,255))) and all columns change color, not just the one I'm editing. Too bad there's not a IsColumnModified() function.

PB 8.0.1 Build 8004 I'm attempting to change the column background color anytime the user edits the existing column data. Once the data is saved the background returns to the original color before editing. Either of the the following methods works. However, once the modify or dot property...

How can I save a datawindow report to either Excel or Word?

It works; finally! Thank-you for your help. The problem in the past appears to have been that after I modified the report DW SQL, I would perform a second retrieve of the whole composite DW in hopes of seeing the associated modified report DW. The data would never appear in the report. The...