I have 3 tables titled "Dept", "Event", Student",
Table Dept Fields are: DeptID (Autonumber) & Dept (text)
In Tabel Event I have the field : Dept
In Table Student I have the field: DeptID

Been spinning my wheels for about a day on this one.  Hope someone out
there has an idea.  I have an unbound object frame in the detail section of
an Access report. Through this control I am linking an Excel worksheet. I
use VBA in the report_page event to put data into cell(1,1) on ...

How do i create a link in each record that links with the appropiate word
document or pdf file.

I have a table which is imported from a text file containing data related to
telephone calls including the Duration of these calls in hh.mm.ss format. I
need to be able to show this data in a form(or report) and include a Total
of this Duration time preferable at the bottom of ...

I have a form that allows users to enter the results of various experiments.  
I used a textbox to do this.  These are then stored as a field in the user's
record. My problem is this: the textboxes are limited to 255 characters (the
maximum size of the field they are bound to in ...

I noticed that whenever I have a SELECT statement with a WHERE =
[Forms]![frmForm1]![txtInvoiceNo], it doesn't work. But if I point to the
actual numerical field instead of the textbox like
[Forms]![frmForm1]![lngInvoiceNo], it will work. I have tried with quotes and

I have Database form that I unknowingly locked my self out of with the
startup feature. I was tring to make it usable for the end user without them
beingable to see the access toolbars. So i unchecked all of the things in
the startup popup and viola! no way to get back into it. ...

Using Access 2000.  I have used the Short Date mask before and only have to
type in 5/1/05.  In my new database on the Date Control I chose Short date
for my Date field and I have to type it in 05/01/2005 or I get an error.
How can I change it to accept 5105 and recognize this as ...

I want to enter dates in a form using the format dd/mm/yyyy.  I need the
input format to also use this format to mimick teh case report forms the data
is being entered from.
Thanks for your help!!!!

I want to use a ListBox to select multiple students for tardy violations so a
teacher does not have to enter each student seperatly.  The listbox would
come from an alpha query containing only the student name and student id.  
The id field is stored in the table tbltardy as the ...

I have a form with a combo box where the user can select a budget year and
then a subform on which the user can enter voucher information for that
budget year.
I have one control in the subform which is a combo box with a query for it's

I have a form that is created from a table.  I would like to have a text box
that a user can enter say an employee id number  and the appropriate data is
then displayed for that employee from the table.
Any help is greatly appreciated.

Our company computer monitor, some use 800X600 resolution, some use
1024X768.
How to use code to automatically resize form to fit differrent resolution in
Access 2000.

On the main form, I put a button to compact current database, the code:
  CommandBars("Menu Bar"). _
  Controls("Tools"). _
  Controls("Database utilities"). _

I have a database that records the number of days for a document to be
closed.  The problem is that we do not work on weekends and holidays so I do
not want this days to be counted.  Is there a way to do this?