Recent content by Mr.K

how to disable the close btn? see: http://www.access-programmers.co.uk/forums/showthread.php?t=98554

I ended up adding the Close Current Window btn to my custom toolbar. It works OK but the icon sucks because instead of a "X" it is a "folder with an arrow". I thought about your solution and the down side is an additional empty toolbar going accross the screen just to have the X on the right...

The problem is that I don't want the preview toolbar. I have my custom bar that comes up, to which I can add the close button, but that is not a good solution because of other issues that come up. (That close btn isn't the standard X so the user doesn't see it easily and may go for the X button...

I have the following code that runs when Db opens: For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i It hides all the toolbars. Now, when I open a report everything is fine with it - I have "min, max, close" buttons on its window. However, when I maximize it - it...

solution http://groups.google.com/group/comp.databases.ms-access/browse_thread/thread/fc401042af9cd49/e5f26b7c0f416357%23e5f26b7c0f416357

replace the Debug window with my own - I know how to set up error handling within a sub or function, but how can I trap the errors globally for the whole DB that open the window and ask if the user wishes to debug? In other words "how to use a custom error handling routine to replace the Debug...

problem remains unsolved ... just tried and I can't. So my original problem still isn't solved :(

Thanks jkl0; your post thought me some useful stuff but this is not quite what I need. I already have a menu bar (not a custom form with a button) and wish for the print button to display the "print window" before the report prints. I think I could use your solution successfully if I had a...

I'm using the menubar button: send report as an attachment. This button works fine when I open the report through the db window, but it doesn't when I open the report via vba. I think you're right about sending the underlying query - it looks like that is what happens. Why does it happen and how...

Hi; I have a report which when opened via the Database Window can be easily sent as an email attachment in various formats using the menu File->Send to... etc.. However, when I open the same report via VBA with: DoCmd.OpenReport "rptRegistrationList", acPreview the attachment that gets created...

Hi, I used the code below to hide all the toolbars and then created my custom ReportToolbar so the user can print the report. All works OK; however, the PRINT button on my custom toolbar sends the report imidiately to the printer. How can I create a button that I could add to my custom toolbox...

any VBA suggestions from the experts to my last post would be greatly appreciated.

I have that, it doesn't remove the arrow. gemma-the-husky, all my toolbars are disabled and the user cannot view the design of the forms, etc.. What I was talking about was the design of the toolbars. Even though he cannot customize them, there is still that pulldown arrow that looks and...

My continuous subform Payments displays a TotalDue after (for) each record (payment for a class registration). However, some of the payments are partial payments for the same RegistrationID. In such case my TotalDue displays the same total amount due for a given RegistrationID whenever the...

I'm trying to execute a macro that hides a PrintMenubar when a query closes. Do queries have events associated with them like forms do? I can't find anything under properties. Showing the PrintMenu when the query opens isn't a problem since I can put the DoCmd.RunMacro in the vba of the button...