Compile Codes

1 Nov 2008 11:34 AM

Denver

I have a lot of VBA codes in my database
but some of it are just pasted from examples
or imported from download samples.

I want to convert my .mdb to .mde
but as i convert i need to compile my codes.
now the issue is there are some errors on from pasted or imported codes but
i dont know how to fix them. can anyone give me a suggestion on how to
manage this errors?
although there are comments but i cannot figure out exactly because im not a
programmer and new to VBA. iam using access 2003

thanks for any help, i appreciate

1 Nov 2008 9:24 PM

Joan Wild

It's always risky to blindly copy/paste some code from someone without
understanding what it's doing.

However, why don't you post the text of the error message that comes up, and
then post the line of code that it highlights.

--
Joan Wild
Microsoft Access MVP

Show quoteHide quote

"Denver" <Den***@discussions.microsoft.com> wrote in message
news:5FC9361C-73E6-4E9F-9421-3C34D8E5EF49@microsoft.com...
>I have a lot of VBA codes in my database
> but some of it are just pasted from examples
> or imported from download samples.
>
> I want to convert my .mdb to .mde
> but as i convert i need to compile my codes.
> now the issue is there are some errors on from pasted or imported codes
> but
> i dont know how to fix them. can anyone give me a suggestion on how to
> manage this errors?
> although there are comments but i cannot figure out exactly because im not
> a
> programmer and new to VBA. iam using access 2003
>
> thanks for any help, i appreciate
>

4 Nov 2008 6:54 AM

Denver

Hello Joan Wild,

I know it's risk to copy/past a codes without knowing its functionality but
I find it helpful to me because im not a programmer and new to Access.

But Thank you very much that you give me a good suggestions.

Thank you Joan Wild, I appreciate.
****************************************************

Show quoteHide quote

"Joan Wild" wrote:

> It's always risky to blindly copy/paste some code from someone without
> understanding what it's doing.
>
> However, why don't you post the text of the error message that comes up, and
> then post the line of code that it highlights.
>
> --
> Joan Wild
> Microsoft Access MVP
> "Denver" <Den***@discussions.microsoft.com> wrote in message
> news:5FC9361C-73E6-4E9F-9421-3C34D8E5EF49@microsoft.com...
> >I have a lot of VBA codes in my database
> > but some of it are just pasted from examples
> > or imported from download samples.
> >
> > I want to convert my .mdb to .mde
> > but as i convert i need to compile my codes.
> > now the issue is there are some errors on from pasted or imported codes
> > but
> > i dont know how to fix them. can anyone give me a suggestion on how to
> > manage this errors?
> > although there are comments but i cannot figure out exactly because im not
> > a
> > programmer and new to VBA. iam using access 2003
> >
> > thanks for any help, i appreciate
> >
>
>