Search results for query: *

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...

I believe that would work. Now, what if I had a requirement for being able to modify the ORDER BY, at runtime?

The range might be a single value or, as you noted, between two values.

I'm not sure how a child datastore would be implemented only because I have not used a datastore before. I'll read-up on it and see if this will work. The issue I'm trying to solve at runtime is being able to change the scope (SQL where clause) of the report based on any given user's criteria...

Than for the reply. I have tried this already with the GetchildDW method and then tried to modify Sql and it did not work. I have labored over this for many hours and have not been able to succeed. I've recently read something to the effect that report DW's cannot have the SQL modified at run...

Is it possible to access column data in a nested report from a composite datawindow event such as "retrieverow" with the following code: string_variable = this.object."reportname".getitemstring(row, "columnname") I've tried this, but it can't find the column name...