Any help would be appreciated!!!
I need to sum AMOUNTTEND on a receipts subform that meet a certain criteria.
It has to be something like.
=sum([amounttend]) where [description]="tour installment"

I have 2 tables and the only unique and common identifier is part of
url:
TABLE1.url
/legal500_html/us500/edit/usv1_in1.htm

I have a report and I am doing the following calculation in the load
report event:
Me.TbxClass1_1.Value = Sales1Count \ Me.TbxSales1.Value
where Me.TbxSales1.Value gets determined by: (Starts out as 0)

I am converting an application from A97 to A2003.  I have 2 tables
created by another application as a Foxpro.dbf.  The table has no index.
The connect string in A97 is
    FoxPro 2.0;HDR=NO;IMEX=2;DATABASE=C:\Test

With the database window open I click on Help, then click on "About
Microsoft Office Access".  A dialog window is presented and there are 4
buttons at the bottom right of the form.  One is SystemInfo and when I
press that I get a Summary dialog box of particulars.  One of the

If I click on the Macros button in the database window there is 1 macro
that exists...AutoExec.
If I click on the Modules button and enter the VB Editor window there's
the menu option Tools.  Clicking on that there's the menu pad Macros...

I've noticed that dollar figures entered as 13.46 are going into my tables
as 13.459999997654399 (999 etc added by me here, but it's close).  Or, as
13.460000005435 rather than 13.46 only.  So, over time, I could see how this
will add or subtract a penny or 2 to an aging report ...

I've used a data field as the rowsource for a combo box many times.
The main advantage that I see is that a separate table of say,
"Customers" does not have to be constantly updated. When a new
Customer is added to the data table in question, they appear in the

I am trying to get MS Access 2000 to print names and addresses onto a
Dymo 400 label printer, I have set the Access Report to automatically
select the correct printer, then select the label size of “99012 Large
Address”.

I have an application that has been built and expanded for over 10 years. As
modules have been added to the front-end, new back-end DBs have been
created. For example the back-end DBs for Inventory, Purchase order, Work
Order all exist in separate MDBs. This of course eliminates the ...

Over the past several years I have had to deal with an increasing number of
problems involving setting up mdac, isams, service packs and the like on
client machines. Often these are not installed, not installed properly, or
not up-to-date. With 60 notebooks, there may be 30 ...

Hello everyone,  I'm using Access 2000 and SQL 8.0
This maybe easy but I can't figure it out.  I have a linked access
table to a SQL server table.  I use this table on a Grid on an Access
form.  There is a field on the grid for the Equipment Number the field

Hi When i Import .txt file in to Access Data Base a special Characters
like "∩" and "╗┐" is getting added to the Access tables. can any one
suggest me how to  take out this Special characters.
I checked the  .txt flies but there is no such special characters in it

I can't find a list of events that are constantly monitored
on background forms in A97. What I'm wondering is if
there are events that are NOT being scanned for on
forms running in the background. Say you have 4 forms

I have table structure below.  All spaces represent different fields
so there are 7 below.
Bill ES AR IM LV BB DE
I want the output to alphabetize fields 2-7 (after Bill).  So output