have a Access 2003 Database that is also used by 2000 and 2002 users.  I
have report that I would like to make available for my teammembers.  
Teammembers would like to have the ability to sort by one or more fields.  
There are five fields i.e. SN#, CustomerName, SalesRep, ...

I'm using an MDB that has to connect to several MDE's.
I have worked out the automatic creation of all those links in VBA
This works fine, but only if the MDE's are not opened at the same tim
by another user. So, I have to ask at those people to close their MD

this is my table structure
lower                upper              price
100                    200                $7.20
200                    300                $8.10

I use the Shell function to zip a file. The directory path to the input file
contains embedded blanks in the name. I can't change the name. So, how can I
hard code this path? eg H:\"My directory"\ doesn't work. Thanks.

help please
I have a button that let me choose a file to attach to a form.  Once
attached, the attachment file is copied to a list boxt on the form.  Now when
I click the submit button, all the information is saved on a table except the

Here is my Select Case statement - it tests for values in a text field - and
if it matches - then sets the background color.  Works like a champ - HOWEVER
- what I really want it to do is to look for the text values - ANYWHERE in
the text field - then set that color.    

I have a process that selects data to update/append to different tables.  
Which is the fastest way to get this done?   Should I utilize queries and
pass parameters?  Or should I open the recordset in code and do rs.updates?
Thanks very much for any advice/information!

Has anyone had their functions or subroutines rolled back to a prior state
after compacting an Access database even though they saved the changes prior
to compacting the database?  I have had this occur on multiple occasions and
need to find a reliable way to trap when this ...

I am trying to insert the results from a recordset into a table. I have my
sql statement and it appears to work fine when I run it on its own function
but it is not doing what I am telling it to do.  Can anyone see what I am
doing wrong? Thanks

I need to get a sum between a date range.  I am using to varibles on date to
do this, but haven't found the correct syntax yet.  What am I doing wrong?  
vSDate and vEDate are my varibles.
vSQL = DSum("[qty_picked]", "VIAWARE_AFRM_TO_VIA_T", "[dtimemod] between

I want to make all UK PostCodes in a MS Access (XP) table show exactly 8
digits. Some are only 7.  For example TR14 8SP is 8 digits, whereas TR1 8SP
is 7 digits long.  I need a formula that will look at the postcode and
convert 7 digit postcodes to 8, i.e. TR1 8SP becomes TR01 ...

Is ODBC linked-table the only way to have a pre-defined link to SQL
databases ?
can it somehow be linked as ADO (or it must be done thru programming) ?
i have already an access program that is running but i am thinking of

I have a project I am working on where the client requires a document number
to increment by 1 each time and the prefix of the number is the year (ex.
05-00001, 05-00002, etc.)  I need to program the number on the form to roll
back to "06-00001" at the beginning of next year (And ...

After installing SP2 ( I don't know if this error also appears without it),
when I create database (or use old one) and create new userform (not regular
form)in it, and close database and then reopen it, I get error message The
Visual basic for Applications project in database is ...

I'm sure this is easy but, using the OutputTo command I am outputting several
queries as spreadsheets. That is so easy, even I can do it! What I am
struggling with is incorporating the current week number in the file name as
I export weekly and don't want to overwrite each file ...