Search results

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...

(Is that the only solution to disable the customize? To create MDE?) I unchecked "Allow Customize" in the Properties of my custom toolbar but the down arrow still appears and the user can click on it and choose customize. When he proceeds to customize it he can't - but the pull down arrow with...

I think I'm totally misunderstood. I don't have a problem with linking the subform with the mainform. I have a control on a subform that I want to give a value to based on a complicated query that calculates a total for the records in the subform. (I cannot use the SUM function in the footer of...

Thanks; that will do the job and as i said - gaps in basic knowledge. Question: Isn't it more db efficient (on the background) to load the query already filtered rather then to open it with all records and then filter the report? Or is it something I really shouldn't worry about. ~ just wondering.

I have a report based on a query. I would like to be able to open that report from an OnClick event but limit the query to a particular value for one of the fields. The value must be supplied from within the vba code. So the logic in the code would be something like this: open report where...

I have a continueous subform with a control in the footer to which I would like to pass a value from a query where the RecordID in the Qry = RecordID on the ParentForm. Do I have to do it using vba (if so, on what event do I update the control and call the vba code) or can I do that just using...