Question Contact Administrator

[Rhino999]

Does anyone know how to Contact the Administrator.

I have Private Messaged Vassago and he has not gotten back to me.

Does anyone know if there is anyone else besides Vassago who has Administrative Privileges.
Someone with the authority who can 'Email' a Member and tell the Member that their Private Messages are Full and they cannot be reached by Private Messaging, until they Delete some of their Messages.

Thanks in advance for you advice or help.

 

[The_Doc_Man]

Try CJ_London. I'd help but I'm not an admin.

 

[pbaldy]

To my knowledge only Vassago and Jon are admins. CJ is a moderator, as am I. As I mentioned in a PM, if you reply to a thread the user in question was active on, they should get a notification email. I do have access to their email address as a moderator, but I'd rather keep that as a last resort. The user in question hasn't been active for a while, so you might find that posting to the thread or starting a new one will get your question(s) answered in a more timely manner anyway.

 

[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 his elegant solution.

I thought that the original author would be the best person to fix a bug in Column 10, and that is why I reached out to contact him.
He agreed to look at it, but when I messaged him again the messages would not go through.

Thanks for your time and help
Rhino999

 

[CJ_London]

what's the bug? I just tried the sample and it works OK for me - Column 10 is 0 and does not show on the report. Perhaps he has fixed it?

 

[pbaldy]

Different columns were hidden for me too, but I expected that the non-hidden columns would move left so that there were no gaps. Did that happen for you CJ? I was also curious what the bug was, but got busy and didn't follow up on either.

 

[CJ_London]

no, controls did not move over - I stepped through the code and controls were assigned the appropriate new .left value, but no error generated and the .left value remained unchanged.

db format is 2000 so I put it down to that, and the question was about column 10, so I just assumed it was not an issue for Rhino.

I thought perhaps the bug was about naming - and thought that perhaps txtO10 had originally been written as txt10, but has now been fixed.

 

[Rhino999]

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

 

[Rhino999]

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 Column KO10 data, just its heading.

Now I see that if Table Column 1 is blank then the Report does not shift left correctly. However, if you have table Column KO1 filled in, the Report shifts left correctly as intended.

Although, Column 10, still remains to be a problem.

I have tried to spot what's wrong, but I am unable to fix it.

Any help is greatly appreciated.
Thanks again

 

[CJ_London]

Taken a closer look


1. the reason it does not reposition is because the controls are 'arranged' - to fix, in report design, select all controls, and on the arrange tab, select 'remove layout'. This will also fix the positioning of the 1st column - there are several arrangement groups, they all need to be removed.

2. to display values in column 10, click on the control and set visible=true

 

[pbaldy]

Ah, good find. That wouldn't have been there in a 2000 db.

 

[Rhino999]

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 working properly!

 

[CJ_London]

That wouldn't have been there in a 2000 db

No - but also interesting that it applied it by default.

Way back when I converted 2003 mdbs to accdb's I don't recall it being applied to existing forms/reports

 

[pbaldy]

Good point, I wouldn't have expected it to be added to an existing report either. I don't recall it happening to me either, but I'm so in the habit of removing the layouts I may have done it.