I have linked a large SQL Server table to Access, however 'only'
2,195,439 records are shown and are available to query.  Can I increase
the size (cache??)/number of records showing in Access?
Thank you.

I've created a Form in Disgn View with all the fields and the captions. I
can see the form when I click on Form View, but it disappears when I click
on Print Preview and I get a blank page when I print. Any reason why?
Thanks in advance for help.

I have a table in Access 97 with [BillDate] a Date/Time type field
Formated "Short Date", UK local settings (dd/mm/yy).
Want to go to a record with a date selected from a combo (correctly
Short Date formatted) on a form.

Greetings.  In Access, is there a way to open up a drop-down combobox
with keys on the keyboard, instead of using the mouse to click on the
down arrow of the combobox?  I really prefer to use the arrows on the
keyboard and the enter key to make my selection.  But if I have to click

I was wondering if anyone could recommend some resources for incorporating
Caller ID functionality into an Access application.  I've tried one third
party package which works very well but has a tendency to lock up my
computer for an unacceptable amount of time (15-30 seconds) ...

I am having a strange problem.
I am developping an application that acceses an Access db through Jet
(.UDL files).
I have writen parametric INSERT queries that work fine.

In a multiuser access/jet database, I need to provide multiple instance
order entry form/continuous subform.  I have been looking for best
practice, but there seem to be competing ideas.  Want to maintain
performance and prevent bloat.

I have a combo box with Auto Expand and Limit to List both set to
'yes'.
When I type 'C' I correctly get:
C J Valeting

   I am trying to use the function found on the MVP site
http://www.mvps.org/access/api/api0019.htm to hide the Access window. I must
be missing something as I keep getting an error message: "You entered an
expression that requires a form to be the active window".

I'm trying to retrieve the connection string for a linked table in a
backend that is password protected.  I've modified the code shown below to
temporarily check that the backend has been successfully opened by showing,
via a messagebox, the last record in the table.   The ...

What are "pages" and how are they different to forms?  Being used to A97 for
the past 7 years I've never come across them before.
Regards,
Keith.

   I'm looking for a way to have a field in my database that will
automatically be filled with a random 4-character alphanumeric string
every time I enter a new record. Like an autonumber field, but
alphanumeric and random. Could anyone tell me how to do this? Please

I have an .mdb file (access database) which has been set to table level
locking (i.e. not just records in question, but the whole table). The
database is also in sharing mode (ie. not exclusive)...
here is my problem:

Hope this is the right place for this...
I am creating a testing database for components as they come off a
production line.
My reports need to select faults that are found, as well as pass or

I have a report with a subreport. In the subreport, I have a cell in a
group footer that is used as a counter (ControlSource = 1, Running Sum
= "Over Group".
When I run the subreport independant of the parent, the running sum