When you do a compile in Access, it should take you to the exact line of
code.

What version of Access are you using, and how are you doing the compile?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)



"Cal Greenberg" <(E-Mail Removed)> wrote in message
news:4CC61253-EC93-4AFC-97D1-(E-Mail Removed)...
> When I get a compiler error, the error message specifies the module where
the error occurs. This is not helpful when the module contains a large
amount of code. Is there a way to get the compiler to provide the line
number where the error occurs?

Thanks for your help, Douglas. I am using two different versions ---- Excel 97 and Excel 2002. I get the same result in both versions -- the error notice does not go to nor show the line where the error occurred

I compile in the code mode by clicking on debug --- compile

Thank

Cal

You'll probably have more luck asking in a newsgroup related to Excel (they
start microsoft.public.excel: microsoft.public.excel.programming might be
your best choice)

This newsgroup is for questions about using VBA in Access, the database
product that's part of Office Professional.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)



"Cal Greenberg" <(E-Mail Removed)> wrote in message
newsDF53D8D-DAB0-436A-B69E-(E-Mail Removed)...
> Thanks for your help, Douglas. I am using two different versions ----
Excel 97 and Excel 2002. I get the same result in both versions -- the
error notice does not go to nor show the line where the error occurred.
>
>
> I compile in the code mode by clicking on debug --- compile.
>
>
> Thanks
>
> Cal

Sorry, No I meant Access 97 and Access 2002 ---- Ca

----- Douglas J. Steele wrote: ----

You'll probably have more luck asking in a newsgroup related to Excel (the
start microsoft.public.excel: microsoft.public.excel.programming might b
your best choice

This newsgroup is for questions about using VBA in Access, the databas
product that's part of Office Professional

--
Doug Steele, Microsoft Access MV
http://I.Am/DougSteel
(No private e-mails, please



"Cal Greenberg" <(E-Mail Removed)> wrote in messag
newsDF53D8D-DAB0-436A-B69E-(E-Mail Removed)..
> Thanks for your help, Douglas. I am using two different versions ----
Excel 97 and Excel 2002. I get the same result in both versions -- th
error notice does not go to nor show the line where the error occurred
>>> I compile in the code mode by clicking on debug --- compile
>>> Thank
>> Ca

Sorry: no idea. I've never seen that problem.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)



"Cal Greenberg" <(E-Mail Removed)> wrote in message
news:ACB24C8F-A903-45CC-8FA5-(E-Mail Removed)...
> Sorry, No I meant Access 97 and Access 2002 ---- Cal
>
> ----- Douglas J. Steele wrote: -----
>
> You'll probably have more luck asking in a newsgroup related to Excel
(they
> start microsoft.public.excel: microsoft.public.excel.programming
might be
> your best choice)
>
> This newsgroup is for questions about using VBA in Access, the
database
> product that's part of Office Professional.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (No private e-mails, please)
>
>
>
> "Cal Greenberg" <(E-Mail Removed)> wrote in
message
> newsDF53D8D-DAB0-436A-B69E-(E-Mail Removed)...
> > Thanks for your help, Douglas. I am using two different
versions ----
> Excel 97 and Excel 2002. I get the same result in both versions --
the
> error notice does not go to nor show the line where the error
occurred.
> >>> I compile in the code mode by clicking on debug --- compile.
> >>> Thanks
> >> Cal
>
>
>