Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Dan777

  1. Dan777

    Toggling reporting groups - expanding/hiding all

    Guess that'll work. Thanks guys!
  2. Dan777

    Toggling reporting groups - expanding/hiding all

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

    Automate emailing of sql data/report

    Sounds like it has a lot of potential. I'll definately check that out. Thanks RiverGuy!
  4. Dan777

    Automate emailing of sql data/report

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

    what are all the various mailing label types

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

    combobox in grid not displaying data when selected

    Thanks for the responses guys. Olaf, you ROCK! You and Igor were right on the money!!! The controlsource of the combo is in fact an integer primary key, and the combo is in fact bound to an integer foreign key. When I set FIXED to ON it worked, the display value was visible when the combo...
  7. Dan777

    combobox in grid not displaying data when selected

    Yeah, I've been playing with that infamous sparse prop as well. When set to false it behaves as described above. When set to true, it further enhances the head ache. When set to true, when the combo has focus, the proper display value is visible (Yaaa!). BUT, when the combo loses focus, the...
  8. Dan777

    combobox in grid not displaying data when selected

    It's a 1 to many form. The "1" is a therapy group. The many is the therapist(s) that facilitated each group. There's a couple hundred therapists that can facilitate each therapy group, and each group can have 1 or more therapists facilitating it. The combo in the grid is to allow end users...
  9. Dan777

    combobox in grid not displaying data when selected

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

    ConfigurationManager.ConnectionStrings / App.Config problem

    Thanks TG for the links. Unfortunately they've just showed me stuff I've already seen. In my app, it works fine when I try to read it and use it from within the same project, which in my app happens to be the data layer, which is compiled as a dll. But when I try to read it and use it in a...
  11. Dan777

    ConfigurationManager.ConnectionStrings / App.Config problem

    Thanks for the reply. I already have the System.Configuration reference established. Unfortunately, that's not the answer.
  12. Dan777

    ConfigurationManager.ConnectionStrings / App.Config problem

    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"...
  13. Dan777

    How to paste an object in the body of an email item via automation

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

    VFP General Field contents to a SQL table via SPT?

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

    How to Export only some pages of a report

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

Part and Inventory Search

Back
Top