when typing and prining  I get only 1/2 page.  Can't seem to figure out how
to extend to full page.  Need help!

Hi All ....How can I create a short message box as opposed to very wide? I
want the following message to be displayed in similar format.
This cassette has been rented by:
FirstName LastName

I have created a form that I use as criteria for a query.  The user enters a
Start Date and an End Date by either typing it in or using a Calendar.
Is there a way I can set the default date in the Start Date field to be the
first of the previous year; 01/01/04 and the End Date to be ...

I'm trying to import an Excel spreadsheet called dh.xls to an Access table
named tblprofilestage.  But, I keep getting an error to check the path, but I
know the path is correct.
Can anyone help me with the code?  Here it is:

I am creating a custom reporting form to allow a user to select (using
checkboxes) which fields they would like to see or hide in the resulting
subform which is populated by a query.  I tried setting the
subform.field.visible property to false, but when looking  at the data in a

Probably a silly question but I've realised that I don't actually know how
to do this properly: Basically what is the best way to navigate to a
particular record in a bound form if you know the PK of the record in
question and assuming that it exists.

I have a main form containing a sub-form. The main form includes a text
box with the control source being a Dlookup expression.  The value of
this control is dependant on what is selecetd in a combo box in the
subform.  I therefore need the control in the main form to update when

My need in the form I'm talking about is very simple. I say this
because I've seen posts that say recordset clone can be used in a snap
to find a record.
I have not used access before. The little db work I did used oracle 8i

I build in te code of Allen Browne following his instructions but something
must've gone wrong. When I try to edit a record on the form and then go to
another record an error-message appears: compile-error: ByRef-arguments do
not match.

I am using the 'Elapsed Time' function given on the 'Colums' page of
Microsoft, which works brilliantly.
I need to then use the result to calculate the amount billed. Do I simply,
format the text box as a Decimal or is it more complex than that?

I have a form where all the variables should be filled in. The problem is
that sometimes some of the data are missing. My supervisor wants to have
prompt when closing the form, to go back if a question has been left blank .
Is there any easy way to check on all the variables? ...

I have Tabular Form "OtData", which has 4 fields. The first Field is "OtNo"
and its Data Type is Numeric.
I have set the Default value of "OtNo" on Form as :
Dmax("OtNo","OtDataBank")+1

I'm using the Macro TransferSpreadsheet to transfer excel file to Access.
But, it keeps giving me an error that Microsoft jet engine cannot find the
object "c:\fixup.xls"   The pathand name is correct.
I don't understand why it cannot find my file.  Does anyone know why or what

If I have a form that calls the function AuditTrail() - I did not write the
code. I believe it is the famous Allen Browne code.  I can see the data on
the screen. I can't find it in any of my tables.  Is there a default location
where this data is stored?

Is it possible to retrieve table attributes such as Modified Date and Created
Date to be displayed within a text box on a form ??
Many thanks in advance