ms access 2003 to 2007 MACROS

  • Thread starter Thread starter David
  • Start date Start date
D

David

My macros won't work though they are on the trusted list. There is a yellow
triangle on the left side of each macro line and when I dbl clk the field to
run the macro this displays: [Forms]![frmBriefs]![ShipToPrefix], [Prefix]
"The value you entered isn't valid for the field. " I've looked at everything
to no avail. All the macro does is copy values from the record on the form
to the shipping fields on the same form if there isn't an alternate shipping
address present. PS. wondering if it has to do with filtered being on when
the form opens though I turned that off?

Any help is greatly appreciated... very frustrated here...as this upgrade
didn't go as planned. Thanks
 
Do you have a bar below the ribbon with message like this --
SECURITY WARNING - Certian content in this database has been disabled
then Options... in a box?
If so, then you have to click and then select - Enable this content
 
Thanks Karl for the quick response. No, no message below the bar. I just
keep getting error code 2950 when I try to run the macro. Any more thoughts?

KARL DEWEY said:
Do you have a bar below the ribbon with message like this --
SECURITY WARNING - Certian content in this database has been disabled
then Options... in a box?
If so, then you have to click and then select - Enable this content

--
Build a little, test a little.


David said:
My macros won't work though they are on the trusted list. There is a yellow
triangle on the left side of each macro line and when I dbl clk the field to
run the macro this displays: [Forms]![frmBriefs]![ShipToPrefix], [Prefix]
"The value you entered isn't valid for the field. " I've looked at everything
to no avail. All the macro does is copy values from the record on the form
to the shipping fields on the same form if there isn't an alternate shipping
address present. PS. wondering if it has to do with filtered being on when
the form opens though I turned that off?

Any help is greatly appreciated... very frustrated here...as this upgrade
didn't go as planned. Thanks
Click to expand...
Click to expand...
 
No. Sorry.
--
Build a little, test a little.


David said:
Thanks Karl for the quick response. No, no message below the bar. I just
keep getting error code 2950 when I try to run the macro. Any more thoughts?

KARL DEWEY said:
Do you have a bar below the ribbon with message like this --
SECURITY WARNING - Certian content in this database has been disabled
then Options... in a box?
If so, then you have to click and then select - Enable this content

--
Build a little, test a little.


David said:
My macros won't work though they are on the trusted list. There is a yellow
triangle on the left side of each macro line and when I dbl clk the field to
run the macro this displays: [Forms]![frmBriefs]![ShipToPrefix], [Prefix]
"The value you entered isn't valid for the field. " I've looked at everything
to no avail. All the macro does is copy values from the record on the form
to the shipping fields on the same form if there isn't an alternate shipping
address present. PS. wondering if it has to do with filtered being on when
the form opens though I turned that off?

Any help is greatly appreciated... very frustrated here...as this upgrade
didn't go as planned. Thanks
Click to expand...
Click to expand...
Click to expand...
 
David,

Probably can't advise without knowing what the macro is. Can you give
details please?

--
Steve Schapel, Microsoft Access MVP


David said:
Thanks Karl for the quick response. No, no message below the bar. I just
keep getting error code 2950 when I try to run the macro. Any more
thoughts?

KARL DEWEY said:
Do you have a bar below the ribbon with message like this --
SECURITY WARNING - Certian content in this database has been disabled
then Options... in a box?
If so, then you have to click and then select - Enable this content

--
Build a little, test a little.


David said:
My macros won't work though they are on the trusted list. There is a
yellow
triangle on the left side of each macro line and when I dbl clk the
field to
run the macro this displays: [Forms]![frmBriefs]![ShipToPrefix],
[Prefix]
"The value you entered isn't valid for the field. " I've looked at
everything
to no avail. All the macro does is copy values from the record on the
form
to the shipping fields on the same form if there isn't an alternate
shipping
address present. PS. wondering if it has to do with filtered being on
when
the form opens though I turned that off?

Any help is greatly appreciated... very frustrated here...as this
upgrade
didn't go as planned. Thanks
Click to expand...
Click to expand...
Click to expand...
 
Steve, my db has 10,000 records so I only want to process this macro for the
record on the screen. I start with a setfilter to the tbl.id and the form.id.
Then I setvalue so that lastname will copy to shiptolastname, then setvalue
so that firstname will copy to shiptofirstname , etc, street1, street2,
city, state, zip, country.

So. SetFilter, SetValue (lname), SetValue (fname) etc..... and run the
macro. Always get the error that a value in incorrect (size or type) but
I've checked all corresponding values in the table. Is there an email addr I
could send screen shots to?
Thanks
Dave


Steve Schapel said:
David,

Probably can't advise without knowing what the macro is. Can you give
details please?

--
Steve Schapel, Microsoft Access MVP


David said:
Thanks Karl for the quick response. No, no message below the bar. I just
keep getting error code 2950 when I try to run the macro. Any more
thoughts?

KARL DEWEY said:
Do you have a bar below the ribbon with message like this --
SECURITY WARNING - Certian content in this database has been disabled
then Options... in a box?
If so, then you have to click and then select - Enable this content

--
Build a little, test a little.


:

My macros won't work though they are on the trusted list. There is a
yellow
triangle on the left side of each macro line and when I dbl clk the
field to
run the macro this displays: [Forms]![frmBriefs]![ShipToPrefix],
[Prefix]
"The value you entered isn't valid for the field. " I've looked at
everything
to no avail. All the macro does is copy values from the record on the
form
to the shipping fields on the same form if there isn't an alternate
shipping
address present. PS. wondering if it has to do with filtered being on
when
the form opens though I turned that off?

Any help is greatly appreciated... very frustrated here...as this
upgrade
didn't go as planned. Thanks
Click to expand...
Click to expand...
Click to expand...
 
Hello,

I am also building a db in Access 2007 and get the same 2950 error even
though my db is in a trusted location. No, I do not get the yellow msg bar.
It's just acting like the db isn't trusted even though it should be.

What do I do??

Thanks,
Melanie
___________________________________________________




David said:
Steve, my db has 10,000 records so I only want to process this macro for the
record on the screen. I start with a setfilter to the tbl.id and the form.id.
Then I setvalue so that lastname will copy to shiptolastname, then setvalue
so that firstname will copy to shiptofirstname , etc, street1, street2,
city, state, zip, country.

So. SetFilter, SetValue (lname), SetValue (fname) etc..... and run the
macro. Always get the error that a value in incorrect (size or type) but
I've checked all corresponding values in the table. Is there an email addr I
could send screen shots to?
Thanks
Dave


Steve Schapel said:
David,

Probably can't advise without knowing what the macro is. Can you give
details please?

--
Steve Schapel, Microsoft Access MVP


David said:
Thanks Karl for the quick response. No, no message below the bar. I just
keep getting error code 2950 when I try to run the macro. Any more
thoughts?

:

Do you have a bar below the ribbon with message like this --
SECURITY WARNING - Certian content in this database has been disabled
then Options... in a box?
If so, then you have to click and then select - Enable this content

--
Build a little, test a little.


:

My macros won't work though they are on the trusted list. There is a
yellow
triangle on the left side of each macro line and when I dbl clk the
field to
run the macro this displays: [Forms]![frmBriefs]![ShipToPrefix],
[Prefix]
"The value you entered isn't valid for the field. " I've looked at
everything
to no avail. All the macro does is copy values from the record on the
form
to the shipping fields on the same form if there isn't an alternate
shipping
address present. PS. wondering if it has to do with filtered being on
when
the form opens though I turned that off?

Any help is greatly appreciated... very frustrated here...as this
upgrade
didn't go as planned. Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top