Hi there. I am trying to filter a form based on a table "TASKS"
I have a drop down box where the user can select to view all tasks starting
in the current week and previous week, and then to filter the data
accordingly.

I am trying to extract all the contact details from outlook but not on my
default mailbox. I have an additional mailbox named "Route Planning HD".
My code works fine for my default mailbox so the problem isnt there its just
directing access to look in a different place that i'm ...

I'm using Access 97 and the ahtCommonFileOpenSave command to bring up the
Open/Save box.
I need to set two file locations - the first is the file I want to import
and the second is the file name I want to save the output file as.

For the after update event of a combo box (named "classcombo") on the main
form Frm_Main, how do I set the filter control on the subform,
Frm_Main_subform.filter?
I'd like to say Forms!Frm_Main_subform.filter = "PriKey = " &

I'm using vb to format a pie chart in my access report. it works fine when
there's data but i get the error "run-time error 1004 unable to set the
seriescollection property" when there's none. Does anyone know how I can
modify my code to handle this? The code is below. Thanks!!

I have an application in Access that gets it primary data from a backend
database. "appbe.mdb". This backend resides on a server in the client's
office.
One feature of the app is the ability to "check out" records from the server

So, here's my simple code so far:
   Dim mylocation, stAppName As String
   mylocation = tbl_settings.Path.Value
   stAppName = mylocation & "\backup\backup.bat"

I want to include a space to the above. How can I achieve this?

I have already done this with ADo and now I'm testing my skill with DAO.
Results: failure...all day failure... That's why I'm here.
I'm writing a very little apps that should just connect a secured database
and make few changes in a table (deleting/changing data).

I am trying to write a VBA procedure to increment an entire table by a
value of 1 when a user clicks on a button of a form (or selects from a
custom menu).  The table, called tblStudents contains student ID's,
names, etc. and their grade level (e.g.- 10).  The user has requested

I have a form that has a check box in the form footer called chkTBArchive.  I
have a button on the same form footer that runs code that uses this check box
to run or not run specific queries based on its value.  When I clikc the
button the code runs up to this point and errors ...

OS: Windows XP
App: Access 2002 SP3
I want to run a batch file placed on another Networked PC. I have tried
'Shell' but I can not get it to run:

I am trying to learn the best way to create a new table off of an existing
table based on the data found in each row of that table.
I have a general idea of the logic... I have worked with R-base and MYSQL
but need to do it in Access. I also have a beta of Access 2007.

I am having a weird date problem and I just cannot figure out why.
I have some date data in a table which when I pull all of them and put them
in ascending order looks like this:
10/2/2006