copy or import macro does not work?

[JK]

When I try to copy or import a macro using Access 2003 it doesn't work for
some reason. I end up with a blank macro. None of the names, conditions or
actions appear. Does anyone know why this is happening? I was thinking it
might be due to corruption soI recreated the database but that didn't help.

Any ideas would be greatly appreciated.

Jason

 

[June7]

No clue about why won't import or copy. I don't use macros, all VBA
code. That's my recommendation, convert all macros to VBA.

 

[JK]

That's what I had to do. But I don't understand why I all of sudden cannot
copy or import a macro. Thought maybe someone would know why.

Thanks!
Jason

 

[Steve Schapel]

Jason,

Do you mean go to File=>Get External Data in one Access 2003 MDB, and import
a macro from another Access 2003 file? And the macro comes through, but
it's empty? That's how I understood your original question. If so, sorry,
I have no idea why -- this is not expected behaviour and I have never seen
it before.

 

[JK]

Our IT guy recently made some changes to our Symantec End Point Protection
software and I'm wondering if that had something to do with it. I tried to
disable the anti-virus software on my PC to see of that would make a
difference but it didn't. I don't get this one and it's a problem because I
run one of the macros using the windows task scheduler. I don't know how to
run a VBA sub that way.

Thanks,
Jason

 

[Steve Schapel]

Jason,

Do you mean go to File=>Get External Data in one Access 2003 MDB, and import
a macro from another Access 2003 file? And the macro comes through, but
it's empty?

 

[JK]

That’s exactly what is happening. It’s driving me crazy. I’ve even had
trouble creating a new macro. I’m thinking it must have something to do with
system security preventing me from working with macros but I’m not sure.

Jason

 

[Steve Schapel]

Jason,

I'm very sorry, I am unable to suggest any explanation for this, as it is
very unusual behaviour.

In trying to track down the cause, I guess the next steps would be to try
creating a brand new sample database file, put a macro in it, then make
another new file and try the import process, and see what happens. As well,
try the same thing on another computer, with the same fiels that are causing
the problem.

Having said that, I am also wondering about what your purpose is here. In
my experience, copying a macro from one file to another is a very rare
occurrence.

 

[JK]

I still am unable to copy/import a macro without the macro data being blown
away. I did try it on another PC within our company network and it worked
fine. I have no reason to believe my PC or my Access App. is corrupt.

When began developing the application I'm working on now - I was a major
rookie. I used a lot of macros to open forms and reports. The application is
so big at this point it would take a while to track every macro down to
convert to VBA.

And there is still the problem of the one macro that I run using the Windows
Scheduler. I don't know how (if possible at all) to run a VBA sub using the
windows scheduler. Maybe I'll post that question and begin converting all
macros to VBA and just never use a macro in my Access Apps. again.

I appreciate your help.

Jason

 

[Steve Schapel]

Jason,

First of all, I agree that a macro is the appropriate approach for running
via scheduler.

What is happening here is very unusual. Sorry it is causing you such grief.
It is not the fault of macros per se, as demonstrated by the fact that it
works on another PC. This indicates that there is "something" weird going
on with your computer, which I can't imagine what that would be. However, a
complete un-install and re-install of Office would be my next step.