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 Chriss Miller 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: *

  1. SalGal

    Access - error in select case function (blank fields)

    Yea! The code As variant worked. Don't know why I didn't do it in a table; just started this way and wanted to make it work! Thanks to everyone!
  2. SalGal

    Access - error in select case function (blank fields)

    I'm working on an Access query; the data is in a linked MySQL database. Two of the fields are codes (A, M, 1, etc.). There is no translation table, so I did a quick function to supply the "real" meaning of the codes. All of the cases work except where there is no data in the field; the query...
  3. SalGal

    Parsing and "translating" numbers

    Great! Thanks for the help!
  4. SalGal

    Parsing and "translating" numbers

    Axworthy - so close! Unfortunately, "0" has an assigned value (spouse) for the first character, so I can't convert the blanks in the first space to zeros; I can use that logic for the second character since it does not use "0" as a possible values. I'll continue to play with it. . . thanks.
  5. SalGal

    Parsing and "translating" numbers

    Two parts to this question, but first background: Access 2003 Linked table (ODBC) with a 2-character text field Values stored in the field are numbers The first number represents relationship: mother, father, grandmother, husband, wife, other The second number is a modifier, if you will, of...
  6. SalGal

    Orphan Group Header on next page

    I'm going to have to use the report as-is. Unfortunately, with school starting in three days, there are too many requests and not enough time. Thank you for your suggestions.
  7. SalGal

    Orphan Group Header on next page

    Page attached. . . The following sections have blanks suppressed GH2 (teacher) GH3 (course)- this overlays GH4 (section) The following are suppressed [b]completely[\b] GF5 GF4 - New page after GF3 GF2 GF1
  8. SalGal

    Orphan Group Header on next page

    First, on the linking question: that would be happening if this were "regular" grades, but this is state standardized test scores, which are referenced only by the student ID (don't get me started on that)! Second, I went back and re-read my original post; I may not have been clear. There is...
  9. SalGal

    Orphan Group Header on next page

    The section to the left of the orphaned header is GH2. It shows: GH1 GH2 (the orphan header) GH2 (the new section) GH4 (I have GH3 overlaying GH4) D The detail section is tight against the sub report; all sections are set to suppress when blank. AARGH!
  10. SalGal

    Orphan Group Header on next page

    The subreport has everything suppressed but the header and details. No extra space there. I checked, and I have force new page after on the footer of the teacher section, not on the header. Very frustrating because it seems like it would be something simple! Thanks for the suggestions. . .
  11. SalGal

    Orphan Group Header on next page

    Crystal 8.5 I'm writing a report of standardized testing data for the students enrolled in each teacher's classes. The report is grouped by: Group #1 - school id# Group #2 - teacher name/number (combined) Group #3 - course number (Course 1141) Group #4 - Course section number (Course 1141...
  12. SalGal

    Export table from Access to Lotus space del

    Success! The Scripting.FileSystemObject worked like a charm! Many thanks - I will definite use this again. SG
  13. SalGal

    Export table from Access to Lotus space del

    Thanks for the suggestions - have hit a storm here and will try again in a day or so and report back. SG
  14. SalGal

    Export table from Access to Lotus space del

    That sounded like it would work - however, I haven't been successful. The code skips to the error trap when it reaches this line: Name "c:\PAYBR05P227904.txt" As "c:\PAY.BR05.P227904" Knowing me, I'm missing something very obvious. . .
  15. SalGal

    Export table from Access to Lotus space del

    I need to export three tables to the Lotus space-delimited format (there is no file extension). The files will be uploaded to a mainframe. Is it possible to: 1. Export the tables into the correct format directly (I've been exporting them to .txt then deleting the file extension) 2. Name a...
  16. SalGal

    How to export multiple queries to seperate worksheets in excel

    OK, I hate to gush, but you guys are fabulous! Thanks a bunch for explaining this so well - it's going to be very helpful in many situations. skb
  17. SalGal

    How to export multiple queries to seperate worksheets in excel

    This was a very helpful post, as I was attempting to do the same thing. However, the queries that I'm exporting to Excel are crosstab queries, and the first column of data is not appearing once the export to Excel has been made. I've read through the code (as best I can!), and I'm not sure...
  18. SalGal

    Export Access Data to an Excel Template

    Duh. . . Thanks a bunch - compiled and is working.
  19. SalGal

    Export Access Data to an Excel Template

    I understand that I need to reference it - but I don't know where or how to reference Excel. Again, sorry that this is so elementary. I appreciate the feedback. Thanks.
  20. SalGal

    Export Access Data to an Excel Template

    Hello all - I have a similar situation - I've copied the code above, but when I try to compile, I get "Compile error: User-defined type not defined" on the Dim appXL as Excel.Application statement. From digging around, I believe I need to somehow define the appXL variable. When I change it...

Part and Inventory Search

Back
Top