Does anyone know of some simple line drawing add-on apps. I just need to be
able to do some simple line drawing with dims. 4 walls and a door and allow
the user to type the dims for the walls. All simple.
Thanks

I am new to Access Monster forums.
I developed an Access form which employees add their daily route.  The form
contains a sub-form in data-sheet (tabular) view where users add address and
other information each day.  (All data is stored in a database (.mdb file) on

I posted two issues in microsoft.public.access.adp.sqlserver. For
those of you who have tried to deploy an ADP with the A2007 runtime,
or who are otherwise interested, I would appreciate very much if you
would take a look at them.

Is there a way to change a reports Sorting Grouping at runtime?
I have an Access 2000 report, I want the user to be able to select from
a combo box to sort the order of the records by FirstName or LastName or
PostCode etc. I currently have several reports with different sorting

At month end, there will be a month-to-date table that should be
appended into the Year-to-date one.  The MTD table is a lump-sum one,
no way to enter into the YTD one entry by one entry.  I can append Feb
MTD to Jan MTD and make it a YTD table, just don't know how to do it

I have a DB2 table and when I open it, all the records show up as
#Deleted.  I went here: http://www.techonthenet.com/access/tables/del_err_linked.php
and tried this, but I don't get a pop-up box to choose any primary
keys.  The kicker is that the table works fine in Crystal Reports ...

OK, I will try to explain this as clearly and as concise as possible.
I am using Access, which has three MS Excel Linked tables, to store
call center metrics for reps.  My Excel workbook has three separate
worksheets, all linked to Access.  I have a query that performs some

We have a bunch of access add-ins that we created in acc 2000.  Trying
to upgrade to acc 2007 but we can't seem to get the add-ins to work.
Is there a equivalent to the USYSREGINFO?  We can't even find the
table (or any system tables) when we open the original myaddin.mda in

All,
My form "FRM_Main" contains 2 subforms, each an instance of the form
"FRM_Testators"
The object name of instance 1 of the form is "SFRM_Clients".

All,
I have a form (FRM_ShowAll) on which I have placed a number of
instances of the same sub-form (FRM_Assign) as different child forms
(SFRM_Agent, SFRM_Executor, etc.).  The sub-form is a continuous form.

I have an app packaged with Access 2002 ODE Tools
the installetion works perfectly on Windows 98, 2000 and XP, but it will not
install on Vista. I think it has to do with the fact that setup.exe for
Access runtime checks the operating system and does not recognize vista.

I have a contacts form with buttons that filter the form by last name.
The buttons code looks like this (a different button for each letter
in the alphabet)
DoCmd.ApplyFilter "", "[LastName] Like ""[J]*"""

I have a question regarding how i can refer to the fields that I want
to add into my dataset
Each of my fields in my rawtext file that I am going to import appears
in the form:

I am trying to import files that start the same but are sequencial.
For instance ABC123, ABC124 from C:\FOLDERNAME. These are .dbf files
that are created from a Foxpro program. I would like all the new files
be imported into one table and the file name to be inserted into the

I'm learning Access (2002)  as I go, but I can't find how to open a form
from a datasheet view.
I want to be able to view records in the datasheet and click on a link to
open a