ACCESS FEED: Re: [MS_AccessPros] Form "Return without gosub' error

Rabu, 10 Desember 2014

Re: [MS_AccessPros] Form "Return without gosub' error

Robin-

I suspect you have some corruption in the old copy. I *never* turn on Name AutoCorrect - that's often suspected when corruption occurs.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Dec 11, 2014, at 12:34 AM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

As you knew Access does NOT update internal references so I am lumbered with the old table names. The question remains - why does the form open in the copy?

Cheers,

Robin

At 11/12/2014 10:05 AM, you wrote:

John,

Now here is a very funny thing!!

This database is a very new project and is expanding. As a result the table names that I originally chose are not ideal. I made a copy of the whole database to experiment with.

I changed the name of the main table to confirm that Access would update internal references. It appears to have done so and in the process the form opens without the error.

Can you explain that?

Cheers,

Robin

At 11/12/2014 09:36 AM, you wrote:

John,

It is not VBA. It must be an embedded macro.

Robin

At 11/12/2014 09:13 AM, you wrote:

Robin-

Did the Wizard create VBA code or an Embedded Macro? If VBA, you can examine the code and try to compile it to figure out what's wrong.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Dec 10, 2014, at 10:21 PM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I am using Access 2013.

I have a form first made about six months ago, uses command buttons,
one of which which now produces the error:

"The expression On Current you enetered on the event property setting
produced the following error - Return without gosub."

As a means to self diagnose I made a new command button but this
gives the same error. Where do I look for the answer to the problem.

Many thanks,

Robin Chapple

------------------------------------
Posted by: Robin Chapple <robinski@westnet.com.au>
------------------------------------

------------------------------------

Yahoo Groups Links