I have a database on a shared drive. It has user level security (ie: mdw
file). It was created in A2000 and works fine when opened on workstations
with A2000 installed.
Some workstations have A2003 installed. On those workstations there is an

On Macros tab I have quite a few macro names.  I would like to delete
all of them instead of doing it manually.  Is this possible through
code, and if so, does anyone have a sample?  TIA.

does anyone know the SetOption name for the option  "Used Windows
Themed Controls on Form" in Access 2003?  This thing is a thorn in my
side and it would be nice to set it programtically.
Thanks

I've been asked to amend an Access 2002 DB that has been used by users
using the MDE version. I have, what seems to be the original MDB
version containing all the front end stuff but, by now, the tables are
way out of date.

Hey everybody, got a secnario for ya that I need a bit of help with.
Access 97 using linked tables from an SQL Server 2000 machine.
I've created a simple query using two tables joined by one field
between them.  The join field in both tables are indexed and I'm

HELP!!!! I have a form with a combo box to select "Staff ID" and a
Calendar which puts the selected date into my "Date" field. These two
fields are the criteria for my parameter query. This works fine!!! :)
the problem is that i want to use the same query with 2 different

http://rajtrytry.dubaimlm.com
free Register On $ 100 Free
dubai companey Relised Paymend
free join form

I have an access 2003 database and i was having a few problems with it-
for instance every time i tried a compact and repair, access would crash
out - I tried exporting each table to a new database and on exporting
one of the tables i receive the error message 'Record is deleted ...

Bape hoody     supplier  ( paypal accept )   (  www.sneaker-fan.com
)
Bape hoody  supplier  ( paypal accept )   (  www.sneaker-fan.com  )
Bape jeans  supplier  ( paypal accept )   (  www.sneaker-fan.com  )

Is there a simple way to do the following?  Assuming that the working
day is 6am to 6pm and appointments are booked throughout the day for
example:  8:00am - 9:30am, 10:00am - 1:00pm, 2:00pm - 3:00pm.
How would I go about displaying the unused time slots i.e. 6:00am -

Been using Access 97 for years.  I use a statistics add-on (Total
Access Statistics) which is kind of expensive and I haven't found
anything to be gained by upgrading. But I'm now told I probably should
because of memory issues with Access 97 which are getting increasingly

I'm trying to populate a listbox as a value list in code (access
2003).
Unfortunately I'm getting 'runtime error 2176 - the setting for this
property is too long' somewhere around the 2000 character mark.

Here is the SQL code of my MS Access query.
SELECT [IBCCP Referral].[Caller ID], [IBCCP Referral].CallDate, [IBCCP
Referral].QualityAssuarnce
FROM [IBCCP Referral] INNER JOIN [IBCCP Agencies] ON [IBCCP

Hi! I am trying to retrieve Date and Time from another record in the
same Table tbl_Group1 having a similar Serial #  (Field name : SN).
The Table have 2 duplicates record and I am trying to retrieve 2
fields from the earlier record.

I have a table with a list of departments & Dept IDs (table a) and
also a master table (table b).
When staff are completing an input (this is saved in the master table
b) they fill in multiple data which also includes their department