Search results for query: *

In some of my reports, groups and items are intitally hidden, with a toggle (+ -) next to it so users can expand just what they want to look at. Of course, some users just want to expand everything and print it out. When a report has dozens of groups, it's a pretty tedious task to click each...

First off, please bear with me if you think this question shouldn't be in this forum. Because of the nature of the question it's rather ambiguous about where it should be. The question is, I have to email a report of data from a sql 2005 database to people once a week. The powers that be...

Forgive me if you think this shouldn't be in this form, but it is in fact about VFP automation. I'm creating a feature in my VFP app to create mailing labels. The data for the labels comes from SQL, thru VFP, then exported to Word via automation. Everything works fine. Now I just need to...

I have a typical combobbox in a typical grid to allow users to enter typical data. The problem is that when the combobox in the grid has focus, the displayvalue is not showing. When the form is loaded, the data displays fine in each combo in each row in the grid, but as soon as the grid...

I'm trying to use an App.Config file and class to retireve a database server connection string at runtime in my n-tier app. The code in the App.Config is: <?xml version="1.0" encoding="utf-8" ?> <configuration> <connectionStrings> <add name="MyConnName"...

Does anyone know how to automatically paste the contents of the Windows Clipboard into the body of an Outlook email item? In my app, I've got a feature that allows users to generate graphs based on some historical data they've selected. Then I've got a "Send Graph" button, that when the user...

Does anyone know how to get the contents of a General field in a Foxpro table, into a SQL table using SQL Passthrough? In this case, I've got an MS graph in the General field of a foxpro cursor. The foxpro cursor has 4 columns, as follows: iPK - int cName - c(20) cdesc - c(100) oGraph -...

Does anyone know how to export only certain pages of a report? In the print dialog there's an option to specify only certain pages to be printed, but in the Export dialog there's only the options of Destination and Format. What I need is to be able to Export just certain pages of a report...

How does one specify a conditional formatting formula for a report object in the crystal activex control? In my VFP 8 app a report is created at runtime using the Crystal Report activex control (vers 8.5). I need to know how to apply for conditional formatting formaul for an objects at...

In my VFP 8 app a report is created at runtime using the Crystal Report activex control. I've figured out how to do everything in code using the activex control except the conditional formatting of objects at runtime. For example, in the details section of a report I want the detail line to...

Does anyone know how to display the Group Name Value in the Group Header using the RDC for a newly added group? I have no problem adding the group, setting its condition field and all, but when it comes to actually displaying the value of the group, I'm at a loss. For example, if a newly added...

Does anyone know how to implement more than single-character searching on a Select Box (drop-down box). For example, suppose I have a select box containing all 50 U.S. states, and the user presses 'M'. Focus in the box is then put on Maine. But if the user presses 'MI', focus in the box goes to...

Does anyone know how to implement a keyboard shortcut for an object in a HTML form, like a hyperlink or button. For example, being able to press <ALT-S> to depress a Submit button on a form in IE. Thanks much! Dan

Does anyone know if there's a way to change the error messages that SQL produces... the &quot;DateTime Field OverFlow&quot; error message just isn't that intuitive to end users, ya know. So is there anyway to change it to something like &quot;Invalid date&quot;? Thanks, Dan

Does anyone know how to not have the words &quot;Microsoft Internet Explorer&quot; display in the title bar of the IE browser when up a non-default title? Is this even possible? (knowing bill, probably not, but just thought I'd ask anyway <g> Thanks much!!!

I need to be able to create Tool Tips for navigation menu options, for when the menu option itself is too long to display entirely. So that if the menu option is not displayed completely, and a 'mouse-over' event occurs, the Tool Tip will be displayed showing the entire menu option. This...

I have a table that has 2 columns in it.&nbsp;&nbsp;One of the columns is updated by the UI.&nbsp;&nbsp;The other column is a calulated update based on the other column.<br><br>What I want to do is put a trigger on the table so that when the row is updated or inserted the calculated column is...

How do I set up an update trigger on a child table that updates the corresponding parent row in the parent table.&nbsp;&nbsp;For example, in the child table there's a column, nProducts, which is the number of products that child provides.&nbsp;&nbsp;The parent table has a column, nTotalProducts...