I have a report that is displayed and filtered with a combobox.
When the user presses the button, it shows the report filtered by the
content of the combobox with the OpenReport command.
Problem is: how can I do the same button so that the filtered data is

I have the following code that opens as many as 5 different forms based on
the selected items in the list box.  It does not stop code execution on each
form open, it just opens all of the forms at the same time.  
Private Sub cmdOpen_Click()

I need to Fax a couple of reports directly from MS-Access.
no fax modem installed, but I am on DSL.
Any ideas ?
Thanks

I am trying to use the following code to relink a database's front end to the
back end.
 Dim dbCurr As DAO.Database
 Dim tdfCurr As DAO.TableDef

MS Access 2003, running on Vista Ultimate sp1
I'm trying to simply copy a file from one location to another, and get a
runtime error 70: Permission Denied. The permissions for the file are set for
full control for all users.

I want to make sure that only 1 user is able to launch the database and run
the app.  What is the best way to accomplish this?

Can I set the ODBCtimeout property in code (don't want to fool around with
the Registry settings)
-----------------------
I have code that loops through each table in my database and gets the number

Whenever I close one particular application I get prompted for the database
password (MS ACCESS 2007).  Has anyone run into this problem that can provide
some insight?  I haven't got a clue as to why I would be prompted for this on
exit!

I have foung many threads that talk aboud that but i find them confusing. i
would like to find an easy way to sum up a column that is filtered and is
requery with a curent form event. so here is the deal.
First Table : Loans

My boss gave me a project and I am not sure how at get the answers he wants.
I have a database that has over 150,000 products and the date the products
changed prices.  Item #  -   Products   -  Quanity  -  Price per unit. .      
               I want to get the price closest to ...

We have 2 computers, each running Access 2007 on Windows Vista OS.  Computer
A and B both have an Access Front End in a local folder and the Back End is
in a different folder on computer A.  
The program runs fine from each computer if run alone.  The problem is

I have a custom function called FISCALYEAR (TableDate) which I created to
use in a query. It takes a single argument which is a field from a table. I
use this function in a query to determine if the TableDate falls into the
fiscal year. It returns true or false.

I know how to do this in excel however I am new to access.
I have a form that is to be updated in three parts.  If the form is not
updated after a certain period then an exception is generated identifying the
party that has not completed their task.

I trying to calculate the week ranges by entering a week number and year.
eg week 1 = 01/01/2008 to 5/1/2008
Does anyone know how to do this?
I've tried several things but they dont seem to work. Any ideas?

I have never used ADO for manipulating records, I would like to learn how to.
Assuming I have the following tables and fields:
tblEmp empnum, empname
tblShift StartTime Endtime