How can one obtain obtain the height of a MS Access 2K form?
There is a width property, but I don't see a corresponding height property.
I need to obtain the height of the form so that I can dynamically resize an
object on the form in the form's Form_Resize method when a user ...

I'm trying to create an odbc data source for a MS Access .adp file.
Apparently there is no driver for this type of file available on this
PC.  Do you know where I could find one?
thanks

I am very new to access. I am starting a new job and have been asked to
design a data base.
After much messing around I have got something that is just o.k.
The problem is that every time I put a date in it displays 1899, never the

Hi there folks,
Within Access 97,
Can anyone tell me the proper way to 'ping' a workstation on a NT 4 network
and/or gather data such as the IP adress. Currently I have code and use

Hi
We have an Access 2000 database application in Windows 2000
enviroment. They will be moving to a new location but the servers will
be at the same old location that they currently are (They are moving

I have a form that consists of 150 records and is still growing.
there are times when I want to print a certain record of the form, say
record 12.  I go to file --> print and choose the page number of the
record.  But what I would like to do, to decrease the amount of

Okay, I checked with usual suspects and I'm still frustrated.
.txt file, fixed width.  About 88 fields of varying length.  All text
fields.  It will only let me add seperators to about the 410th position but
there are 420 positions.

I have 2 forms, frmMain and frmHistory.
frmHistory has a field called Return.
frmMain has a command button called "Due Today" (which will henceforth
be called as DT), which opens frmHistory and filters it to display

I tried installing the ValuePack, but the Snapshot choice still
doesn't appear when I try to Export a report.  What is missing?
Thanks,
Bill Hutchison

I'm searching for an scaled down way to print reports to .pdf format
directly from a form that selects multiple reports for review or printing.
It would seem that there is a simpler method rather than the copious amounts
of coding required to set the default to Acrobat Distiller and ...

We would like to use Jet engine as database for our application. But I
found out that there are five versions of Jet Engine 4.0, one for each
version of Windows. But we would like to ship only one installer for
our application. How can I solve this problem?

Hi Gurus
I have been working on a rather sophisticated update procedure for FEs of my
application that are spread throughout the country.
Now, I recently thought: WHAT IF

In regards to this post from last month (from Julia Baresch):

I have a database for a small city grass roots organization. I have a
list of block captains, there information is entered thru a form. Each
of these block caps will bring in their contacts and we enter the list
into table thru form. So far fine...I created a second form tied to

I am attempting to to write a query that has a numerous nested IIf
statements.  The problem that I am having is that it is to long of a
query to be built in design mode and when I build it in sql mode after
a certain point it give me the error message that the expression is to