I created a report that has labels in the top three inches of the page
header. There's also an unbound subform there. When I go to preview or
print, the records from the detail section overlap about the bottom two
inches of the labels so they can not be seen. Does anyone have any ...

Is it best practice to set Unicode Compression to "No" for memo fields in a
table?  What about text fields?
According to the VB help entry:
"Data in a Memo field is not compressed unless it requires 4,096 bytes or

How can I access a parent form's procedure from an event handler
within a sub-form?  What comes after 'Me.Parent.' ?  Or is that not
the correct syntax?
Thanks.

Does an Active X control exist that look like or is an excel
worksheet.
The Microsoft Office Spreadsheet 9.0 Active X control does allow you
to select a record source.

I've recently migrated the back end of one of my client's applications
from Access to SQL Server.
One of the forms is based on an Access query thus:
SELECT dbo_tblDistributionDetail.*,

I have written a stored procedure (sp) that calculates the number of
seats remaining for an event. I need to pass the event id to the sp.
I have a combo box that lists all the events. When I choose the event
from the combo box the  event executes the sp and the 'Enter Parameter

I have just inherited an Access Booking Application. Works fine,
including some quite complex code that calculates an availability
table from dates input by the user.
I have produced a simple asp to display this table in a browser.

Found some stuff on Google about this, but it was older and only applied
 to form code when a table was being displayed.
Anyway, I am adding records to a recordset where the values I am
inserting are based on the values in the current record.  The easiest

Access 2000- my form has fields for ?name?, ?arrival?, ?departure? and
?site nbr?.  Can I make a subform under ?name? that keeps a history of
all previous entries to arrival/departure/site nbr so that when the main
form is changed, the new information is ADDED to the subform? Thanks

I know there is already a plethora of emails regarding
Groupwise/Access problems but mine is slightly different to the ones
I've read about.
I'm trying to use the sendobject command to email reports to a list of

I have an Access 2000 application that has a backend database which
sits on the network and a frontend installed to each PC.
When the frontend is opened, users have to log on and then the
database opens their menu form with buttons for key activities.

Got a table like this.
Name   ID    Location
Bob    1     Home
Frank  2     City

I have an Access applicaion I built for my buiness. Last week the
application crashed and I haven't been able to get it running again
since in any form.
Now every time I try to run the application I get the following

   As you can tell by the post, I am still in the early stages of learning
VB so please bear with me. My question is, can you use the results of a SQL
as a variable in code? Something like....
Dim strSQL As String

I need to be able to copy and paste the contents of an HTML page into
a field in my adp. Is this even possible? In Word I can click Paste
Special, and select HTML and it copies the table just as it looks on
the html page.