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

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


"June7" wrote:

>
> 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.
>
>
> --
> June7
> ------------------------------------------------------------------------
> June7's Profile: http://www.thecodecage.com/forumz/member.php?userid=784
> View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=131696
>
>

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.

--
Steve Schapel, Microsoft Access MVP


"JK" <jasonk at necoffeeco dot com> wrote in message
news:506C0D6A-AA54-4C3F-8824-(E-Mail Removed)...
> 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
>
>
> "June7" wrote:
>
>>
>> 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.
>>
>>
>> --
>> June7
>> ------------------------------------------------------------------------
>> June7's Profile: http://www.thecodecage.com/forumz/member.php?userid=784
>> View this thread:
>> http://www.thecodecage.com/forumz/sh...d.php?t=131696
>>
>>

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" wrote:

> 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.
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> "JK" <jasonk at necoffeeco dot com> wrote in message
> news:506C0D6A-AA54-4C3F-8824-(E-Mail Removed)...
> > 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
> >
> >
> > "June7" wrote:
> >
> >>
> >> 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.
> >>
> >>
> >> --
> >> June7
> >> ------------------------------------------------------------------------
> >> June7's Profile: http://www.thecodecage.com/forumz/member.php?userid=784
> >> View this thread:
> >> http://www.thecodecage.com/forumz/sh...d.php?t=131696
> >>
> >>
>

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?

--
Steve Schapel, Microsoft Access MVP


"JK" <jasonk at necoffeeco dot com> wrote in message
news:8C85C002-335A-44DD-A236-(E-Mail Removed)...
> 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.

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" wrote:

> 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?
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> "JK" <jasonk at necoffeeco dot com> wrote in message
> news:8C85C002-335A-44DD-A236-(E-Mail Removed)...
> > 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.
>
>
>

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.

--
Steve Schapel, Microsoft Access MVP


"JK" <jasonk at necoffeeco dot com> wrote in message
news:B0745732-7615-43EA-AA19-(E-Mail Removed)...
> 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
>

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" wrote:

> 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.
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> "JK" <jasonk at necoffeeco dot com> wrote in message
> news:B0745732-7615-43EA-AA19-(E-Mail Removed)...
> > 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
> >
>
>
>

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.

--
Steve Schapel, Microsoft Access MVP


"JK" <jasonk at necoffeeco dot com> wrote in message
news19194E0-66F0-4D7B-ABD9-(E-Mail Removed)...
> 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