Search results

Forget the current OP, Pat. This is becoming a trend for you. You're showing a genuine lack of patience and the wording of your replies are sometimes demeaning to users looking for answers, not incivility. It's not that you need to seek forgiveness from anyone but you should count to 10...

You've lost the patient approach you used to have, Pat; not the same Pat from 20 years ago. I have a personal rule that says I won't be rude unless someone is rude to me. It might help you.

There are some who have been on the site a very long time and have lost the art of tact and gained a more supercilious attitude. It's not the first time I've noticed a senior member alienate a poster.

Sorry I missed your post - Yes I have Option Explicit declared in each module.

No, the form is already open and the Call is to an existing Command button within the same form.

That's interesting, moke123. But that code you examined had a bug which would cause the database to close spontaneously while moving from form view to design view. I have, on occasion, had error messages about the odd undeclared variable used in some code, but not often. Being undeclared doesn't...

My orginal post does indicate that the Call is self-contained within the one form. The code calls a routine on another object within the form's code. That I was replicating a similar call on another form may have caused unintended confusion.

No, the form name is correct and is opened by code on other forms without a problem. I had tried several different styles of the same command without success but on the main form, it works perfectly.

Hi Pat, I find the forum useful most times. The last problem I had was resolved although the root of the problem was never discovered. This time, I had chosen to use the Call Me.Command### as I'd never used it before and saw an opportunity, within my database, to try it out. It worked well on...

Yes, I omitted the Commandbutton number but the syntax was correct and, no, it didn't work. I used several ways as suggested by other online sources without success. The code, although it won't work, does compile without error.

The puzzling thing is that the Call works on one form within it's own form limits and successfully calls the button as if it was clicked. The other form, which again is self-contained and works entirely within its form, uses the same call but fails with the messages in my first post. I have...

Thank you.

Would there be a use for a button with no Click event? Or no events at all? Yes, but this line of code is restricted to its form. A similar line works OK with the main form, as above. All of the code is contained within the forms.

The code I'm having a problem with is already posted above. There is one line... Thanks DaveE

Command248 is a button so, yes, it has a Click event.

Thanks for your questions, Posting the database would be a little OTT for one line of code since the database is quite large. In each instance, the working form and the non-working form, there is one line of code that is a problem. The first form that works has the line, as described above...

Thank you for your input. Can you offer any help with the problem? Thanks DaveE

Hi All, Access 2010 My problem is - In VBA on my main form, I use the line - Call Me.Command117_Click, to execute the action of the Command117 button. It works fine. On a new form - In VBA, I've used the same method with - Call Me.Command248_Click, to execute the action of the Command248...

Hi arnelgp, The good news is that I have had no further problems with the database. I took the modified db from you and - Removed all of Module 2, reverted to OpenForm (Maximise) with all previous property settings for the form. Added back all the tables, forms, queries and reports that I...

The version from arnelgp seems to be OK. I have been using it normally with no failures. Last night, I started to gradually remove some of the changes arnelgp made to see which may have made a difference. Still functioning well. I will post a fuller report toarnelgp shortly. Thanks for your...