When I run a VB exeucte file with Call Shell as follows:
Call Shell("""C:\Program Files\Microsoft Office 97\Office\micaccss.EXE""", 1).
The error message says: File not find.
When I use Windows 2000 to directly run micaccess.exe, the message from this

In Access 2007, how do I minimize the ribbon when my application loads? I
can more or less do this with Sendkeys, but I'm looking for something more
reliable and robust. Thanks.
George

I put a password on my .mdk access file.  How can I programatically supply
that password when I refresh the link to the data in excel?

I can successfully run some codes in a standard module and create recordsets
for an query.  However, if I want to run this module again, I will always get
the above run time error and a msgbox "The database has been placed in a
state by User"Admin" on machine "xxxx" that prevents ...

I have code which uses Randomize and the rnd() function.  Sometimes this code
gets an error based on some other command in the code which is fine.  I do an
error catch on this error.  The problem is after the randomize and rnd() are
executed then the rest of the code runs and an ...

Access code eg Dim MyDB as database works in Access 2000 but not in Access
2007 (running under Vista)  Help!

I would like to know the code needed on a form using On Click to perform a
backup of the entire database.  I realize that this may force the auto
closing of the database and auto reopening after the backup is complete.  I
will need to be able to state where the backup file will ...

I have an Access 2002 application that uses this control.  I am having issues
with client machines having different versions of the file causing the #Name
issue.  I would like to try late binding of the object to get around this.  
Does someone have an example of the VBA code ...

I have a shortcut menu named menuFilter (right-click menu).  It is assigned
to the form property.
When my application starts, all command-bars are disabled with the standard:
For dintCount = 1 to CommandBars.Count

I have 1 form based on tblevents which tracks event information, date, time,
attendance etc... Tblevents has a unique eventID (autonumber).  I have a
subform based on a query of a junction table which tracks product sales. the
query has fields itemsalesID,EventID,ItemID, sold ...

The following code in VBA for Access functions incorrectly because the
recordset returns wrong number of records, it shows only one record, while
it should be 1500!
I would appreciate if you could explain this behaviour to me.

Hi, I'm trying to have a message box return a 3 line message with 2 variables
passed from the form when the Go button is clicked. This is what i have so
far.
Also i would like to check 2 text boxes for Is not null value then i fire

I have a memo field with multiple sentences in it.  I'm trying to pull out
just the second sentence to autopopulate another field.  Each sentence is
seperated by 2 vbCRLFs.  How can I pull out just the second sentence?
My thought was to locate the 2nd vbcrlf from the left and also ...

Using MS Access 2007, having build a financial reporting utility, I now have
a potential database corruption problem, given that the reports imported and
then removed and reimported leave the DB growing in size, where if it were to
be compacted without closing we would never ...

When I click on the button upper right corner, the access application close.
I would like create a function to do the follows:
If I click on this button, must show a message to ask the user if do you
really want quit the application, if the response is yes, then close, if is