Recent content by 747skipper

@MajP All true. But the object of this query was to learn something. Even I could write the name of each block into it and arrange to use it in an error handler. What I wanted to know was was there an equivalent to me.name which would return the sub or function name, and now I know there...

Thanks again Chaps, @MajP reading your code more carefully I see the "& " cmdClickMe_Click"" which is just what I'm trying to avoid, since I will have to add a different version of this in every sub or function. @isladogs (love the Lab) I haven't tried it with the reference yet (because I have...

Wow what a lot of replies. Thank you all @MajP That's the sort of thing I wanted BUT when I call a sub and pass me.name it passes the form name not the sub name. @KitaYama Mz-Tools sounds good but I'm only doing odd jobs for a charity, I am no longer a professional programmer. @MarkK...

OK a bit of a weird request, but does anyone know if I can obtain the name of the current sub or function at run time, in code? I have a top level error handler to close a form and return to menu, acting as a back stop if an error I haven't allowed for occurs. This covers several subs and...

Yes I did. The two tile options giving me about 30 small windows and the cascade option a similar number one above the other. Expanding one of these to a workable size caused the Find box to appear at the top or bottom of the window whilst maximising an individual window returned to centring the...

CJ. Thanks. That does work so I'm getting somewhere. The monitors are identical but the left hand one is directly in front of me and I've got used to having that one as Form. Oh well old dogs can learn new tricks. isladogs (love the picture big lab fan) The "Window" option helps, in that...

Thanks CJ but no. I have the main Access window displaying the form in monitor1 and when I select "Design View" " See Code" it spawns a separate window which I then drag to monito2 and set as maximised.

FIRST this is the in the VBA Code window, not a program I'm writing. I have two screens with the form open on one and the code on the other. Whenever I open the find box [ Edit. Find] or Ctrl F, the box opens exactly across the join of the screens. Some of these boxes you can drag where you...

Thanks isladogs (thumbs up for Labrador). Now I know it's not available I'll work round it but it was driving me mad trying to find it.

Thanks a lot DBguy. Lightning fast replies and accurate Gen. Thanks

It is a form. So can I not group and get totals on form? Only a report?

Thanks for reply but No. Also I apologise for posting a question about a Form in the Report section. I told you it was driving me mad!

First let me say I understand sorting and grouping, and if I use the "Create" button I get a nice green Report Layout Tools with a Grouping and Sorting button. But in an existing report I cannot find the way to display either that button or the pane at the end of the report which allows setting...