I am having difficulty with the workspace procedure listed in appendix I of access 2003 VBA book when I convert it into a procedure as part of a module. There are about 30 forms which will use it so it made sense to put it in a module rather than a class module.

i get the error 2460 or 2465 when i click OK

The code is copied exactly, however its the form variable that i am having problem with. I am trying to use it in access 2000 as that's the version i have to work with.

I need to be able to use it with subforms as well as within a tabcontrol.

public sub workspace(ctl as control fm as form)

The only item the form variable it seems to accept when called is Me

This is probably a basic point that i'm missing. I've looked around through my myriad of books for examples to see if i can spot my mistake, so that i can carry on writing the code for other forms.

I don't have much time, but try putting a comma between your variables in the declartion of the procedure as in;

ctl as control, frm as form

Good luck...Bill

that was my quick typing unfortunately, apologies on that

the opening statement does read

public sub workspace (ctl as control, fm as form)

Can you tell me which book you are using and which page? Also post the ISBN if you have it. I will take a look at the pages where you are finding this example.


mmcdonal

Look it up at: http://wrox.books24x7.com

The book is wrox's Access 2003 VBA Reference Book

Its appendix I

I tried putting a post in the books forum, however no-one seems to be subscribed to that forum anymore

That looks like a pretty large index. Can you reference where you are getting the code? What is the heading of the section?


mmcdonal

Look it up at: http://wrox.books24x7.com

The subsection within appendix i is "pop up memo field workspace with spell checker"