There's an old database system called "PICK" - still in use in
various forms such as 'OpenQM' - wherein you can SELECT or READ
directly into an array variable. For example :
  "SELECT * FROM DemoTable TO ArrayVar"

How post request to Http from MSAccess?

I would like a particular action to fire every time there's a
mouseover event for any button on my (Access 2003) form.   Does anyone
know how to do this without writing an OnMouseOver event procedure for
every button?

I am in a new position and looking at the possibility of using
Sharepoint for my database instead of the whole backend on the server,
frontend on the workstations route.  Does anyone have websites or
other books they recommend? Any experiences? Roadblocks to avoid?

I have a 2 unmatched queries
Table1_view (records in table1 not in table2)
Table2_view (records in table2 not in table1)
Both table contain fields

When the person doing the data entry is entering data into a subform,
I need to connect to a sql server and get specific value based on the
record number and date.
There is 15 values I have to retrieve while the person is entering the

Just noticed something interesting in the above. If you have your program
file set to "Compact on Close" in access 2007 (which is desirable when you
have a larger program that frequently needs compacting), if you use the
following code on an "Exit Application" type button, the ...

I'm trying to overcome the problem that some users including myself
have noticed with combo boxes in A2003 databases that are run in
A2007.  When the combo is tabbed out of the backstyle changes to
transparent.  I haven't yet seen a fix for this.

In a report in Access (11.65566.8821 SP2) I receive what appears to be
Chinese characters for one field only.  I can't find the setting that
made that happen, I'd like to return that field to English.  Anyone
know?  Thank you.

I have a query that performs very well immediately after a compact/
repair, but quickly degrades after the database has been in use
(updating activity) for a short time.
When running quickly, SHOWPLAN output reveals that the Jet optimizer

I'm a novice access VBA programmer. I’m trying to write a nested
query
to explode the bill of material. But the BOM table has more than 20
levels. It’s really redundant  and annoying to write all those nested

I have Microsoft Office Professional 2003 and the computer I connect to
also has A2003 retail.  The others in that office use Access 2003 runtime.
Q1) I wanted to see if they were up-to-date on their service pack but
the "About Microsoft Office" menu item is missing when the run ...

I have a form which includes a list box populated with items from a
query.  When a user double clicks on a row in the list box, each
column item is put into a specific text box.
The problem right now is that a row is already selected, and the items

This is the vba code
   Set db = CurrentDb
   On error goto fErr
   …. loop

I connect to my client's PC via the internet.  His PC's OS is Win2000
and he has both retail Office 97 (or it might be just A97) and Office
2003 with Access version.
Today I attempted to get into an A97 app and got a "Microsoft can't open