Search results

I don't know much avbout OpenArgs, but quite possibly! I've used it to remember the name of the form that opened it, but I wasn't aware these configuration settings could use it. This has all got a bit out of hand, really. I started by trying to stop users from unwittingly editing a record...

I get the following in the Immediate window: optExpiryDate = 1 is assigned to None 2 is assigned to Years 3 is assigned to Date If I run it from the cmdButton that works, I get the following... optExpiryDate = 2 Thank you, Pete

OK, I'll give that go - it'll take a couple of days, but I'll get back to you :) Thank you, Pete

Will do, but it will be a couple of days I'm afraid. I've got a robing ceremony to go to tomorrow! (It's not me) Pete

Thanks, but I don't even know how to 'surround my code with the #VBA7 test' let alone where to do it! :o I guess it would be in the same Module as the code? :confused: Pete

When I type this... "if optexpirydate=1 then " and click Enter, it changes to... "If optExpiryDate = 1 Then " ...so I assume it 'knows' it exists and, on the form itself, using Me.op shows the control in the list (image4)

So, the form looks like Image1 with the first bit of code and image2 with the second bit. image3 shows that area of the form in design mode. Hope this helps, Pete

...and this is from the form that doesn't work... Private Sub cmdOpenRecord_Click() '===================================================================================== 'NOTE: Changes to this form must be replicated in frmApplicationDetails,cmdOpenRecord...

Here's the code to start with... Private Sub cmdEdit_Click() '================================================================================= 'NOTE: Changes to this form must be replicated in frmSearchResults, cmdOpenRecord...

Do you want the code from both the cmdButtons? They're 150 lines each and mostly (except the DIM lines) exactly the same. I can't u/l the database as it has data in it, but I can do screen shots of the form being opened in design view. Do you need screenshots of the 'source' forms, or just...

I think I know what's causing the problem prompting me to ask this question, but I really don't know why the code doesn't work the same way from both forms. What I'm trying to do is confirgure the second form to highlight fields that can be edited, using a series of With, End With instructions...

OK, thanks. Could I get around this by changing references to 'user32' to 'LoadCursorA', or am I being a dolt? Thanks

Hi, I have a Form which I open from two different forms, but which would use the same code on the Click event to set the configuration of that form. As I'm getting fed up changing the Click code on one form and then updating the code on the Click event of the second form, wouldn't it be easier...

Thanks, sneuberg. I did that, but got the same.

Hi Frothingslosh, Thanks for making the code available. I have tried to use your code, but before I even got to try it, the Code window shows some of the text in red, as per the attached image. I copied the text directly from your post in the forum. Does this need to be in it's own Module...

OK, so I see the logical steps to this and understand that, to use this method, I will have to include the Left, Top and Width values to be able to set the Height value. So, is there a way to determine the first three criteria from the Form this is launched from, so I can use these to set to...

...and I'll try and avoid typing errors! Is it possible to open a form and specify the size when it opens, please? The reason I ask is that, when I click a CommandButton to open a continuous form, the number of records varies, but I want the form to stay the same 'height'. Thanks.

Re: After asking an embarrasingly easy question earlier today... Thanks again, arnelgp! I must owe you a drink by now! Pete

Re: After asking an embarrasingly easy question earlier today... Not really, no. I just want to open a webpage, and I seem to be making some headway. Thanks, though. Pete

Re: After assking an embarrasingly easy question earlier today... Oops. Sorry about the typo in the title!