Re: Why?

VBA 6, used by Access 2000, 2002, and 2003, has bugs and is poorly
integrated into Access, particularly Access 2000.

MS did fix some of the bugs in Access 2000, but as Access 2002,
not as a service pack.

Your solution (importing everything into a new database) was
good and correct.

Often, you can fix this kind of problem by using the /decompile
command line option: create a shortcut to MSACCESS.EXE, then
add the /decompile option to the shortcut. Use the new shortcut
to open the MDB with the corrupt project.

This specific problem you had can sometimes be fixed by deleting
the module from the VBA project window, instead of using the
Access database window.

(david)


"jahoobob via AccessMonster.com" <u12179@uwe> wrote in message
news:6282eda5535d0@xxxxxx
I have a front end to an employee info db that resides on a network drive.
One person uses this frontend. I made changes to this fe, added three
trial
modules that opened reports from a from and closed without testing them.
The
regular user opened the fe and got the Invalid argument error and couldn't
do
anything without the debugger going to one of these new modules. I had
named
the form field that returned the report name incorrectly. She closed it
on
her computer and I opened it on my computer with no problems. I compacted
&
repaired OK. She still got the same error. I deleted the three modules
and
compacted and repaired. Still the same error and the three modules
showed.
I deleted them from here view and closed and opened the db. Same error
and
the modules still showed. Went to my computer and the modules were gone.
I
even did a restart on her computer and the problem remained.
I "fixed" the problem by importing all the objects into a new db and she
can
now work in it.
Does anyone have any idea about what was going on here?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200606/1


.

Relevant Pages

  • Re: command failed to execute.
    ... I doubt that David's fix has anything to do with your sending and receiving ... But just to be on the safe side, create a new shortcut. ... You were also correct re all your surmises about what I was doing re Photo ... From all we heard so far there is no problem with *saving* attachments. ...
    (microsoft.public.windows.vista.mail)
  • Re: desktop shortcuts/Outlook email links, dont work; XP says "Ca
    ... I was SOOO hopeful this nifty IE fix you sent, ... when I copy a shortcut url and plug it into my taskbar ... I paste the url into the little window ... when I click on a desktop shortcut, ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Windows Media Center is not showing up...
    ... shortcut I created with the information that was given to me, ... Orlando (Goofy says "Hey!"), Florida ... the admin but am at a loss as to how to fix this problem. ... running Windows Vista Home Premium, does anyone know what my problem ...
    (microsoft.public.windows.mediacenter)
  • Re: msinfo32 and System Info
    ... You may or may not be able to fix this. ... It used to work but a Windows Critical Update screwed it up. ... Can't Open Msinfo32 ...
    (microsoft.public.windowsxp.general)
Loading