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

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

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

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?

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

I'd like to dynamically modify the height of a column datawindow object as function of the string length for the data in that column. I want to minimize white space in the datawindow because row data may have 1 character in this column and the next row may have 150 characters or more for the...

I'd like to know if I can modify the SQL with(dw_name.modify('datawindow.table.select" = Select......"') for a report that is part of a composite datawindow object.

Can Structure objects only be passed window to window via openwithparm and then extract data contained within with the Message object? Can I simply declare and create an instance of the structure in another window and then proceed to extract data from it without using the Message object?

I would like to have the text entered in a DW column object wrap to the next line if it runs into the right side of the object frame. I would like it to display this same way upon retrieval. Is there a DWO that supports this formatting? Thank-you.

For a simple SQL query I'd like to have the table name be a variable such that I can change the table name during runtime. I guess the advantage is that I just have to write the SQL once as I have many tables to query with the same where clause. To date, I've only had experience with tbl_name...

I have added a command button (one for each column) to the heading of a datawindow object and selected the Action property to be "Userdefined". Is it true that the script for the button would reside in the "buttonclicked" event of the datawindow? If so, can I then use the...

During run-time I get a Datawindow Information messagebox subsequent to saving a record that reads, "Types of expressions must match." The data commits OK and all fields are updated. I have not used any expressions in any of the column data.

I'm trying to determine which item has been selected from a dropdownlistbox with the selectionchanged event, but do not have the .item[] coded correctly. See below. if this.item[] = 1 then dw_datasheet.dataobject = "d_datasheet_cv" end if

When I run the following code from a Window open event I receive an error message that says, "Invalid Expression", which I believe is referring to the string value of ls_find_string. (inst_tag is the column name in the datawindow) ls_find_string = "inst_tag = " +...