Error with SendObject Function - Steve Schapel

  • Thread starter Thread starter Tameria
  • Start date Start date
T

Tameria

Steve,

I used the =[Forms]![NameOfForm]![NameOfTextbox] agrument
in the Message Text field of the Macro
(using the query -> form -> macro) suggestion you gave me.

Everything looks great but when I run the macro I get this
error message:
Microsoft Access can't find the form 'formname' in the
macro expression or Visual Basic code
*The form you reference may be closed or may not exist in
this database
*Microsoft Access may have encountered a compile error in
a Visual Basic Module for the form.


- I don't know what the problem is. Have you ever seen
this error message?
 
The form name is spelled correctly. It was closed the
first time I got the error but I went back and opened it
and still got the same error.

Any suggestions??
-----Original Message-----
Tameria,

I assume the form is open at the time, and that you have correctly
spelled the name of your form in the macro argument?

- Steve Schapel, Microsoft Access MVP


Steve,

I used the =[Forms]![NameOfForm]![NameOfTextbox] agrument
in the Message Text field of the Macro
(using the query -> form -> macro) suggestion you gave me.

Everything looks great but when I run the macro I get this
error message:
Microsoft Access can't find the form 'formname' in the
macro expression or Visual Basic code
*The form you reference may be closed or may not exist in
this database
*Microsoft Access may have encountered a compile error in
a Visual Basic Module for the form.


- I don't know what the problem is. Have you ever seen
this error message?
Click to expand...

.
Click to expand...
 
Post the actual expression that you now are using. Let's see what you have.

--
Ken Snell
<MS ACCESS MVP>

Tameria said:
The form name is spelled correctly. It was closed the
first time I got the error but I went back and opened it
and still got the same error.

Any suggestions??
-----Original Message-----
Tameria,

I assume the form is open at the time, and that you have correctly
spelled the name of your form in the macro argument?

- Steve Schapel, Microsoft Access MVP


Steve,

I used the =[Forms]![NameOfForm]![NameOfTextbox] agrument
in the Message Text field of the Macro
(using the query -> form -> macro) suggestion you gave me.

Everything looks great but when I run the macro I get this
error message:
Microsoft Access can't find the form 'formname' in the
macro expression or Visual Basic code
*The form you reference may be closed or may not exist in
this database
*Microsoft Access may have encountered a compile error in
a Visual Basic Module for the form.


- I don't know what the problem is. Have you ever seen
this error message?
Click to expand...

.
Click to expand...
Click to expand...
 
=[Forms]![email test]![emailtext]


-----Original Message-----
Post the actual expression that you now are using. Let's see what you have.

--
Ken Snell
<MS ACCESS MVP>

Tameria said:
The form name is spelled correctly. It was closed the
first time I got the error but I went back and opened it
and still got the same error.

Any suggestions??
-----Original Message-----
Tameria,

I assume the form is open at the time, and that you
Click to expand...
have
correctly
spelled the name of your form in the macro argument?

- Steve Schapel, Microsoft Access MVP
Click to expand...
wrote:

Steve,

I used the =[Forms]![NameOfForm]![NameOfTextbox] agrument
in the Message Text field of the Macro
(using the query -> form -> macro) suggestion you gave me.

Everything looks great but when I run the macro I get this
error message:
Microsoft Access can't find the form 'formname' in the
macro expression or Visual Basic code
*The form you reference may be closed or may not exist in
this database
*Microsoft Access may have encountered a compile error in
a Visual Basic Module for the form.


- I don't know what the problem is. Have you ever seen
this error message?

.
Click to expand...
Click to expand...


.
Click to expand...
 
Doublecheck to be sure that your form name has the space between email and
text. If that's not it, then this expression likely isn't the source of the
error message that you're seeing.

Not being fully aware of the previous history for this topic (I "jumped" in
because I knew Steve was busy on a project and it appeared as if I might be
able to help out!), I don't know the type of macro argument in which you're
using this expression. Does the emailtext control have the correct info that
you expect it to have?

--
Ken Snell
<MS ACCESS MVP>

Tameria said:
=[Forms]![email test]![emailtext]


-----Original Message-----
Post the actual expression that you now are using. Let's see what you have.

--
Ken Snell
<MS ACCESS MVP>

Tameria said:
The form name is spelled correctly. It was closed the
first time I got the error but I went back and opened it
and still got the same error.

Any suggestions??

-----Original Message-----
Tameria,

I assume the form is open at the time, and that you have
correctly
spelled the name of your form in the macro argument?

- Steve Schapel, Microsoft Access MVP


On Tue, 5 Aug 2003 09:40:18 -0700, "Tameria"
<[email protected]>
wrote:

Steve,

I used the =[Forms]![NameOfForm]![NameOfTextbox]
agrument
in the Message Text field of the Macro
(using the query -> form -> macro) suggestion you gave
me.

Everything looks great but when I run the macro I get
this
error message:
Microsoft Access can't find the form 'formname' in the
macro expression or Visual Basic code
*The form you reference may be closed or may not exist
in
this database
*Microsoft Access may have encountered a compile error
in
a Visual Basic Module for the form.


- I don't know what the problem is. Have you ever seen
this error message?

.
Click to expand...


.
Click to expand...
Click to expand...
 
Everything is spaced/typed correctly and yes the email
text control has the correct info in it.

-----Original Message-----
Doublecheck to be sure that your form name has the space between email and
text. If that's not it, then this expression likely isn't the source of the
error message that you're seeing.

Not being fully aware of the previous history for this topic (I "jumped" in
because I knew Steve was busy on a project and it appeared as if I might be
able to help out!), I don't know the type of macro argument in which you're
using this expression. Does the emailtext control have the correct info that
you expect it to have?

--
Ken Snell
<MS ACCESS MVP>

Tameria said:
=[Forms]![email test]![emailtext]


-----Original Message-----
Post the actual expression that you now are using.
Click to expand...
Let's
see what you have.
--
Ken Snell
<MS ACCESS MVP>

The form name is spelled correctly. It was closed the
first time I got the error but I went back and opened it
and still got the same error.

Any suggestions??

-----Original Message-----
Tameria,

I assume the form is open at the time, and that you have
correctly
spelled the name of your form in the macro argument?

- Steve Schapel, Microsoft Access MVP


On Tue, 5 Aug 2003 09:40:18 -0700, "Tameria"
<[email protected]>
wrote:

Steve,

I used the =[Forms]![NameOfForm]![NameOfTextbox]
agrument
in the Message Text field of the Macro
(using the query -> form -> macro) suggestion you gave
me.

Everything looks great but when I run the macro I get
this
error message:
Microsoft Access can't find the form 'formname' in the
macro expression or Visual Basic code
*The form you reference may be closed or may not exist
in
this database
*Microsoft Access may have encountered a compile error
in
a Visual Basic Module for the form.


- I don't know what the problem is. Have you ever seen
this error message?

.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Ken,
I appreciate your help.
-----Original Message-----
Doublecheck to be sure that your form name has the space between email and
text. If that's not it, then this expression likely isn't the source of the
error message that you're seeing.

Not being fully aware of the previous history for this topic (I "jumped" in
because I knew Steve was busy on a project and it appeared as if I might be
able to help out!), I don't know the type of macro argument in which you're
using this expression. Does the emailtext control have the correct info that
you expect it to have?

--
Ken Snell
<MS ACCESS MVP>

Tameria said:
=[Forms]![email test]![emailtext]


-----Original Message-----
Post the actual expression that you now are using.
Click to expand...
Let's
see what you have.
--
Ken Snell
<MS ACCESS MVP>

The form name is spelled correctly. It was closed the
first time I got the error but I went back and opened it
and still got the same error.

Any suggestions??

-----Original Message-----
Tameria,

I assume the form is open at the time, and that you have
correctly
spelled the name of your form in the macro argument?

- Steve Schapel, Microsoft Access MVP


On Tue, 5 Aug 2003 09:40:18 -0700, "Tameria"
<[email protected]>
wrote:

Steve,

I used the =[Forms]![NameOfForm]![NameOfTextbox]
agrument
in the Message Text field of the Macro
(using the query -> form -> macro) suggestion you gave
me.

Everything looks great but when I run the macro I get
this
error message:
Microsoft Access can't find the form 'formname' in the
macro expression or Visual Basic code
*The form you reference may be closed or may not exist
in
this database
*Microsoft Access may have encountered a compile error
in
a Visual Basic Module for the form.


- I don't know what the problem is. Have you ever seen
this error message?

.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Tameria,

I am unable to think of what the problem might be. I have just tested
this again, and it works as expected for me.

Following the other "instruction" in the error message, could you
check any VBA code in the form's module (if there is any). In fact,
you should try to compile the project. Open any code module and do
this via the Debug menu... the actual menu item will vary according to
the version of Access. If there is an error with the compiling, we
will need to fix this. If it compiles ok, open your form and try the
macro again. Let us know.

- Steve Schapel, Microsoft Access MVP
 
I guess I can use OpenForm for this function. Thanks again.

-----Original Message-----
Ken,
I appreciate your help.
-----Original Message-----
Doublecheck to be sure that your form name has the space between email and
text. If that's not it, then this expression likely
Click to expand...
isn't
the source of the
error message that you're seeing.

Not being fully aware of the previous history for this topic (I "jumped" in
because I knew Steve was busy on a project and it appeared as if I might be
able to help out!), I don't know the type of macro argument in which you're
using this expression. Does the emailtext control have the correct info that
you expect it to have?

--
Ken Snell
<MS ACCESS MVP>

Tameria said:
=[Forms]![email test]![emailtext]



-----Original Message-----
Post the actual expression that you now are using. Let's
see what you have.

--
Ken Snell
<MS ACCESS MVP>

The form name is spelled correctly. It was closed the
first time I got the error but I went back and opened it
and still got the same error.

Any suggestions??

-----Original Message-----
Tameria,

I assume the form is open at the time, and that you
have
correctly
spelled the name of your form in the macro argument?

- Steve Schapel, Microsoft Access MVP


On Tue, 5 Aug 2003 09:40:18 -0700, "Tameria"
<[email protected]>
wrote:

Steve,

I used the =[Forms]![NameOfForm]![NameOfTextbox]
agrument
in the Message Text field of the Macro
(using the query -> form -> macro) suggestion you gave
me.

Everything looks great but when I run the macro I get
this
error message:
Microsoft Access can't find the form 'formname'
Click to expand...
Click to expand...
in
the


.
Click to expand...
.
Click to expand...
 
Tameria,

No, not all the time. Just at the time that the SendObject macro is
being run. :-)

- Steve Schapel, Microsoft Access MVP
 
Back
Top