Search results

pbaldy, your so right as usual! After replying back to you, I when through the code and I saw exactly that I had not yet loaded the values to stLinkCriteria. Thanks again so much. You are of immense help to the VBA, and Access Community!

pbaldy, thank you for responding. I ran your solution an it does not get an error or Mismatch. I worked correctly! Thank you! Now that it has finally worked, I'll be able to check out the rest of my code. Thanks so much!

Let me thank you in advance for you help. I have a ComboBox that shows Detail records. When one record is selected, it is loaded to the PODetail Table. I want to prevent a duplicate selection of a ComboBox record. I’m trying to use a Dlookup in the AfterUpdate Event of the ComboBox in the...

Dear ridders: Thank you so much for all your thoughts about the problem and trying to help me. I looked at the problem and could not see anything wrong, so as you requested, I reluctantly began to create a sample Database stripped down to the bare essentials to run the report. When I went into...

Thanks for responding. I'll go though the code to disable what I can and see what happens. As for unloading parts of my Database, if I can't identify anything, I'll see what I can to try to upload enough objects to allow the report to run. That is not an effort I really want undertake.

Thank you for responding. I'm not sure what you mean by 'Doable' when you say, Doable the Detail on format code on one report & confirm the problem disappears. Could you please explain! I have been through it line by line and as of yet I have not been able to identify what the problem is. The...

Well, I say All the Reports do the same thing, because I copied the code of the Details On format from the first report that I created, to the rest of them, because I thought is was working properly. I don't have another Database that has a report to test, if a the Detail records are completely...

Thanks for your suggestion: I just tried KeepTogether=No and there was no change in the results. I'm still a unnecessary second Report Page with a Header and a footer that belongs to a continuation page.

Thanks for responding. Yes, I have checked and moved the Page margins and it did not make a difference. Can Grow is set to NO. Keep Together is set to Yes. Force New Page is set to None. All my reports do the same thing. I just checked one which has Can Grow set to Yes and I still have the...

Dear Members, I need some help. I have a Report with Page Headers, Detail and Page Footer. When the Details are filled with a full page of 10 records, the Report creates a second Page instead of printing just 1 page, with the Footer totals at the bottom. If the Detail has 9 records, 1 page...

I would like to thank everyone for helping me. I finally found the problem with the Print Preview rendering Error. 'A custom macro in this report failed to run and is preventing the report from rendering' It was because I was Opening a Template Report in Design View hidden mode in the On...

sxschech, thank you for looking at this for me. I'm doing it the same way it was proposed my vbaInet at http://www.access-programmers.co.uk/...d.php?t=232405 The Sample File is HideBlankColumns.mdb , please take a look at what he did. There is a Query and a Report for that Query. That Report...

static, thanks for responding. I'm not sure I understand what you mean. It may be related to the way I have explained it. The Report was Designed for Legal Size. It's only when data from a Form that has not been fill in completely, that I evaluate the empty Columns in the On Format Event and...

sxschech, thank you for responding. Your suggestion is a good one! I have thought that if I can't get a resolution of modifying the Print Setup on the Fly, I would have to create something on the order of what you said, measuring all the Columns in Twips and then when the Blank Columns add to...

static, thanks for responding. Just to make sure that I understand, your solution is to Click a button on a Form and run code before the Report runs to reset the Report back to Legal size Paper, right! But that doesn't solve my problem of print the Report on the appropriate size paper in the...

My original contact to the Forum was at http://www.access-programmers.co.uk/forums/showthread.php?t=291003&highlight=HideBlankColumns I initially contacted the forum regarding a Sample Database to Hide Columns on a Report Located at...

CJ, thanks so much for looking at it. I'll look at what you discovered and make the changes you suggested so that I can get it to work completely. An additionally thank you to pbaldy, for the time he spent evaluating it. Thanks again, Rhino999 P.S. I did what you suggested and looks to be...

CJ and PBaldy, After playing with it, I discovered additional bugs where the Report Columns do not move to the left and fill in the White space. I did not initially realize that there were more problems with it than the Column 10 issue, where if table Data exists, there is no printing of...

CJ and PBaldy, thanks so much for looking at it, I really appreciate your help. The Bug I found was when you populated the table 'tblrecords' in Column KO10 the report does not print the table data, it just prints the Heading of KO10 on the Report. Thanks again for your help Regards, Rhino999

Pbaldy, thanks for looking at my post and making a suggestion. vbaInet posted this terrific solution Sample Database 'HideBlankColumns.mdb' in this link http://www.access-programmers.co.uk/forums/showthread.php?t=232405 in Jan 2010 Nothing on the Internet that I have seen even comes close to...