![]() |
#15
|
|||
|
|||
![]()
Hey Paul!
Hi Paul, I have started to test with your latest code now that I think I have cleaned up my report. Looks like things are finally moving forward as hoped, with all thanks to your dedication in helping solve the problem. I am still ashamed that one letter caused so much grief. My apologies for not being very thorough, but it all starts to look the same after a while. I am using this sql statement: Code:
StrSQL = "SELECT * FROM [CORE$] WHERE [TYPE]='" & itype & "' AND [SIG_CREW]='" & isubresp & "' " & _ "ORDER BY [STARTS] ASC, [COMPLEX] ASC, [UNIT] ASC" 1) I need directory type. Right now I getting letter type merges. Where do I need to change that? 2) I am having a heck of a time establishing the time fields in a h:mm AM/PM time format despite having included switches. The date switches worked fine, just not the time. { MERGEFIELD E1_Start \@"h:mm AM/PM" } - with ALT-F9 3) I am getting duplicate reports being run, but this may not be related to the module you helped me with. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sharing data between Office applications | mdavies | Office | 1 | 11-26-2013 02:55 PM |
![]() |
abreeden | Office | 1 | 05-18-2012 08:02 PM |
![]() |
RiverStyx | Office | 1 | 05-30-2011 08:31 PM |
Change skin color of applications? | Jack R | Office | 0 | 07-04-2010 04:25 AM |
How many Word applications are running GetObject | stevecarr | Word | 0 | 01-09-2006 07:41 AM |