Search results for query: *

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!

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

Great! Thanks for the help!

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.

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

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.

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

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

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!

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

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

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

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

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

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

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

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

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

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.

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