Search results

Hi, I tried adding that and it made no difference. I think when I call form_load from within form_open, it is still too "early" to affect the display of the form. Effectively it is just as though I am calling another sub from within the Open event. Thanks, Keith.

Hi, Thanks for pointing me in the right direction. It wasn't easy, but in the end I got the following code to work (fingers crossed - its worked so far!) CommandBars("ToolBarViewDetails").Left = 1000 CommandBars("Switchboard").Left = 0 CommandBars("ToolBarViewDetails").Top = 0...

Hi, That's what I figured, but the Load event doesn't fire on my form. If I code a Load event comprising just a MsgBox "hello", the message doesn't appear. I did try putting the code you used in the Load event, but it doesn't work. That's when I found that the load event wasn't firing at all...

Hi, The default behaviour I am getting is that the form opens with the first field already having focus and its value highlighted. The first field is the calc_actual field in the first row - the form is set to Continuous Forms. I want to suppress that behaviour so that the field still has...

Hi Mile-O-Phile I've tried the Form_Load event but it doesn't fire. I've checked and it appears that Load doesn't fire on any of my forms where I dynamically assign the recordset, but does on those simple forms where I don't mess with the recordset. Is there another place I can put the script...

Hi, I have the following code in my form's open event: Me!Calc_Actual.SetFocus Me!Calc_Actual.SelLength = 0 This code has no effect. I want to avoid the field that initially gets focus from being highlighted (but it needs to be enabled and locked). The field already gets focus by...

Hi Drew, Where are you coding that script? I pasted this from the A2K help on the Resume statement: If you use a Resume statement anywhere except in an error-handling routine, an error occurs. Do you want an Exit Sub instead of Resume? Cheers, Keith.

Hi, I think you need to code the following in the Change event of each of the first 3 checkboxes: If Me.FleetManagement = True Then Me.Passive.Visible = False Me.Active.Visible = False Else Me.Passive.Visible = True Me.Active.Visible = True End If Not sure if...

Hi, I have an application toolbar, and certain of my forms also have a common Form toolbar defined. I positioned the form toolbar so that it was docked to the right of the application toolbar. At some point the form toolbar decided to position itself BELOW and to the right of the application...

Hi, This should do the trick (in the OnTimer event, if I correctly understand what you are seeing): DoCmd.Hourglass False HTH, Keith.

Hi, You have a number of options to play with that will affect the appearance in Continuous Forms view, by amending the Properties of the form. This includes setting Dividing Lines to No. I suggest you play with these options and see if you can get the look you want. Hope that helps, Keith.

Hi Rob, That did the trick, thank you so much! I think your solution is similar to something I tried earlier, but I adopted the idea of only the MDE being protected, but adding a back-door for me to get in (as I will still need to debug the MDE). I couldn't get it to work initially, but found...

Disable Shift Key - Sorry Hi, I know there are numerous threads on this but I can't make ghudson's solution (http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36043) work for me. I'd like to open the application, preventing the shift key from bypassing startup, unless the...

Hi, This should do the trick: Forms!form1.EnterNewOrder_Click However, you will need to make the PRIVATE sub into a PUBLIC sub for this to work, I think. (A better coding technique would be to create a separate (public) Enter New Order function in the code for form2 and call this function...

Hi, Try un-checking "Display Database Window" in the Startup options. Cheers, Keith.

I should have known that! I stand corrected. Thanks, Keith.

Oops, spoke too soon! The code was failing because I was trying to reduce the size of the detail band too small to accommodate a label. Even though I had hidden the label programmatically, Access still seems to insist I leave room for it! Thanks. Keith.

Hi, I am trying to change the height of my form's detail section programmatically. As a simple example, why doesn't the following work: MsgBox (Me.Detail.Height) Me.Detail.Height = 7000 MsgBox (Me.Detail.Height) When I run this script the two message boxes both show...

Hi, Here's how I would tackle it: First create a query from the tables, selecting the columns that you want in your result set, i.e. Number of candidate, name etc. Then create a form or report based on that query. Then in the form with the drop down boxes, put an OK button, with the script to...

Hi Rich, That worked great! In the OnAction I put: "= DistributeValue ( )" which references the function in the active form when the toolbar is visible. I had tried before but didn't think to put the =, which produced a weird message about the macro or "callback function" not being found...