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!

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

Search results for query: *

  • Users: jcbirch
  • Content: Threads
  • Order by date
  1. jcbirch

    Export Access RunSQL Queries to Excel

    Hi, I have an Access VB module that creates an Excel report. Part of the Access VB module calls a macro that runs a series of SQL statements based upon what the user specified. Different users have different business rules, thus there are multiple macros, and I select the appropriate one...
  2. jcbirch

    Include Random Memo Field Not in Group By

    Hi, I know it's bad form, but I want to run a SQL statement with a GROUP BY wherein not all my data is in the GROUP BY clause nor aggregated. I just want to randomly pick a few fields for inclusion. Long story as to why... but trust me it's fine. Fields are as follows: sender domain(s) date...
  3. jcbirch

    Create Outlook COM Add-In to Search/Replace Acct. Numbers

    Hi, Hope someone can help me. This challenge seems like a doozy to me, but I figure it would be very easy to someone who knew what they were doing. I have experience with SQL programming and using VB to automate Excel reports (formatting, page setups, etc.) but this is way above my head. I...
  4. jcbirch

    APPEND FROM with Empty DateTime fields

    Hi, I'm using VFP 6.0 with Service Pack 5. I'm trying to automate an import process because I have to repeatedly import multiple tab-delimited text files. I am creating a new table structure, then using the "APPEND FROM" command to import the data. My issue is this: if one of the datetime...
  5. jcbirch

    Excel Chart Location in VFP 6.0

    Hi, I'm creating an Excel report with a cover page (1st sheet) and a chart on the 2nd sheet, chart values in fields D35-F39. I can create the chart just fine. However, when I try to specify the location as an object on Sheet3, it totally disregards my specifications, and instead places the...
  6. jcbirch

    Copying Multiple Sheets from One Workbook to Another

    Hi, I need some help with copying Excel sheets from one workbook to another using VFP 6. What I want to do is create several data tabs. Then create several report tabs, and copy the appropriate data tabs into each report as appropriate. The code below just copies several sheets from one open...
  7. jcbirch

    Change Excel Page Orientation from FoxPro

    Hi, I hope this isn't a repeat/silly question. I'm a newbie at this. I'm trying to generate a report using FoxPro, and I want to export & format the final report to Excel from within VFP. I have already figured out some subtle changes to make to the VB so it will run from VFP (e.g. using...

Part and Inventory Search

Back
Top