I am using Ken Getz's API dialog box to allow users to select a file in my
application.  I am setting a starting directory and I need to make it so the
user can not change that directory.  Is there a way to do that?
Thanks in advance for any help.

I have an Access 2002 application that is run over the network from Windows
XP. The main form has a Treeview control and a subform that shows the record
of the selected item in the tree. I am using the Filter property of the Form
to show only the selected record.

we collect fees in 2 terms. Can I implement this in access. When I select
term1 all the fees pertaining to that should be displayed and the student has
the option of paying in installments too. i.e term1 fees = 5000, he can pay
the same in installments. So when the student pays ...

I need to have commissions calculated a number of different ways.
I'd like the actual calculations stored in a table, ...I think.
Then the user can select which calculation to use, the code gets sucked
into....

I have an Access 2003 front end to a MS SQL 2000 database.  One form uses
data from a view.  I have no trouble updating the table underlieing the view,
but in order to add data, I need to pass a value back in a field of data type
(SQL) uniqueidentifier.  The field is the key on ...

For an attendence system I use a form which first asks for a date and then
takes names and that date to a new table.
That gives me the possibility to fill out the attendance for that day.
Because the question for the date is made by ACCESS itself, it is not really

I am trying to relink my tables. I'm getting the message "Invalid Procedure
Call or Argument." All I can say is OK. I can't get to the link menu. Any
ideas folks? I'm using Access 97. Otherwise the database works just fine.

I need to create an Open File Dialog box in Access 2000.  I am
attempting to use the code from
http://www.mvps.org/access/api/api0001.htm but am not clear how to do
so.  Do I just paste it into the VB code which relates to the form

Do you now if is there a function or procedure to generate a specific tone
frecuency and duration?
Saludos.

I have to compare two columns of a listview.
I use this:
If lvw_Asign.ListItems(X).ListSubItems(4) >
lvw_Asign.ListItems(X).ListSubItems(5) Then

input fields
start date
end date
Frequency (Weekly or Monthly)

Does anyone know of a basic code for zipping and unzipping files.  what I
really wont is the code itself to be all "Access Module".  I am trying to
avoid DLL's or other linked files.  
The Goal.

  I would like to send queries straight to the Oracle database that I am
connecting to.  I do not want Access to process it since they seems to be a
lot faster when I use a pass through query.  However, I want to use variables
in the SQL statements which I dont believe pass ...

We have a staff database which we use to try and keep track of staff leave.  
Recently however I've noticed that staff have been booked in for two
different reasons at the same time.  For example annual leave from the
10th-17th and sick leave from the 12th-14.

Hi;
I'm updating two Dao RecordSets in a VBA module.  My sequence of events is
as follows:
"StartTrans"