Search results

Hi guys, I had a few days off so I wasn't thinking about work, but one of our Access Developers was able to help me out with this code, and is is working! Option Compare Database Option Explicit '****************************************************************************** '* Program /...

guess were going in Circles, Gemma's didn't work 100% either for the same reason. Anyways thanks for trying, I don't want to take up all of your time trying to figure it out. I'm spending too much as it is, for now I am going with my initial setup that just hid the controls....my brain has...

no matter what I do I am not able to figure out what combination will catch when it is a single page and when multiple pages, every time I try something it is like a toggle just can't get it right.

what I don't understand is, I put a breakpoint ( the bolded line) and it sets it to TRUE, but doesn't show it? * before that it is false, so not sure if it is too late at that point, I am trying different sections to see Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As...

Hi Stopher, it won't show the footer when there is only one page of data. but you have "Report_Load" I just noticed, is that because you have 2007? I guess for me it would be report Open...I'll try that

They do get purged, but they build up fast, don't forget, the plan was to use something to search the directory to figure out the file that way i would not have to process all of them in Access. This qgrep would do that, but I'd need some sort of Shell Execute to use it..?

you might want to put the link to the post as it won't always stay prior to mine...but I have tried all that, it is not consistant with varying page counts...you have to read the previous posts

thanks Gemma, I have an import routine that can move and rename the files, I can't move the files to another directory because there are too many, and I can't do anything that will alter the existing file directories. I found this link about Windows Grep...qgrep you can download HERE from MS...

Gemma..thanks for the input, I would actually be able to use the transfer text, simply by loading it all as a single field, then loop through the recordset using Select Case to check the segments from the left in order to determine the position of the value of that segment, I believe the first...

There are many files that I would not want, you'll have to explain what you posted because I'm not sure if you were posting an overview of the steps or some sort of Script? I wasn't overly concerned about all the fields in the file, basically once the file is identified, I would import it into...

I know but it is not an issue working with the file and importing...the issue is searching a directory to find the file. This file layout is not good for importing, it is not a flat file but an EDI X12 standard...I would only be interested in the NTE segment...but really I am not even worried...

I am getting some success with both methods..the Page count matches ...but if you reduce the records in the "tblPickListDtl_App" table to 27 and run it it won't display the footer.

I know what you are saying, but not quite clear on how i will "Trap"it, when I have been debugging the code and stepping through the lines, I can see the Page counter is showing 1 of 2 (in variable), then the event seems to end in the "PageHeader_Format" event and previews the report...then...

oh no, not quite there, if the report footer has enough room to first on the first page, it seems to not set the visible to true, and I can see that the page numbers show 1 of 2. It seems that because the data formating is complete the current page counter does not move to match the "pages"...

you are awesome thanks for figuring it out, I was getting ready to look at the report footer again and code the controls to specific positions at the bottom of the page. Thanks also to Simon, and everyone else

Gemma wait...where did you put that? I can hide the footer, but can't show it on the last page?

So now I am trying a different approach, but still seem to have the same issue. I set all the controls and the Page footer to ZERO for the Dim and positions in the group header, and then in the footer ( I tried them all) I set them back to their original values ( only testing with one control)...

here is a stripped down sample, the way you see the code is not the only way I tried. I've commented out the hiding of the controls and tried just hiding the section but still no luck. I can hide the controls and make them show on the last page, but please note that it leaves a gap on the...

thanks wiklendt, it's not an issue in that respect because the documents are signed and then copied, if there is "Additions to one document that are not in another then I would assume they would not count...seems only logical? Any ways the idea is to situated at the bottom of the page ( last...

It's not that easy, the report footer prints where the data ends, so if the detail record ends at the top of the second page the the Report footer will follow right behind it, if I try to extend the report footer then at some point it will be forced to a blank page on it's own....I understand...