VBA Problems

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: David C. Holley (DavidCHolley_at_netscape.net)
Date: 01/26/05 

Date: Tue, 25 Jan 2005 23:17:35 -0500

Something weird is going on. I was in the process of debuging a form
(frmReservations) in Access. As a part of this, I created a copy of the
form (frmReservations_backup). Once I had figured out the problem with
the original. I deleted it and then went to rename the _backup to the
original. At first, Access really didn't like that indicating that a
form by that name already existed, although I had deleted it and it
didn't appear in the DB window. Then when I tried to view the VBA code
for the backup, Access started through an error message - "Error
accessing code. The connection to the network might have been lost."

I did a compact and repair on the db file, which didn't work. I then
imported the form into a fresh db file, which seemed to fix the problem,
but then when I started working with a function in a module that I
exported and imported, Access would throw the error message at me when I
tried to ADD parameters to a sub.

I've already done a uninstall/reinstall of ALL of Office on the chance
that this would fix it, but it didn't.

Any ideas?

FYI: Office 2000 Pro on WinXP

David H
Come on baby lite my fire: www.spreadFirefox.com

Relevant Pages

  • Strange Problems with VBA
    ... Then when I tried to view the VBA code ... Access would throw the error message at me when I ... that this would fix it, ... files as opposed to Access and may just flat out import/export ...
    (microsoft.public.office.developer.vba)
  • Re: VBA Problems
    ... In 2000 I have had to cut and paste the code by hand to fix just ... need to compile error free before you start working with them. ... > backup, Access started through an error message - "Error accessing code. ...
    (microsoft.public.office.developer.vba)
  • Re: Cant open Excel2003 workbook containing VBA macros with Excel2000.
    ... but can you "Save As" Excel 2000.xls and get it to work ... > I have an Excel2003 workbook with lots of VBA code. ... > But when an Excel2000 user tries to open it, he gets an error message ... > part of my code is causing the error so I can fix it and make it ...
    (microsoft.public.excel.programming)
  • Re: Delayed Write Failed - after SP2 - Q213733
    ... > customers have started to experience this error message while doing their ... The Backup fails as a result. ... > Does anyone know where to find the XP version of the 'hot fix' for this ... > BP Ritchie ...
    (microsoft.public.windowsxp.perform_maintain)
  • Windows XP pro system backup error
    ... I am trying to do a backup (have been succesful in the past) using system ... All of a sudden I now get the error message ... What is this and how can I fix it? ...
    (microsoft.public.windowsxp.perform_maintain)