I am working with Access 2.0. I have imported
a report from an old application for use in a new
database being build in Access 2.0. The report
developed in the old mdb file

It would be nice to have an editor or "source safe" that tracks
changes and shows relationships between things like "If" and "End If".
Anyone know of any other possibilities?  I found one but I can't
afford the $300 USD price.

Iif I wanted a count of client "encounter" dates, from a table that
stored all services delivered to clients.  A client may receive more
than one service on a particular date, but I only want to count
unduplicated combinations of date and client ID.  I want to use this

I'm using a standalone Access database to record customer payments and we
have a separate credit card authentication box. Is there any easy to
implement software that will integrate into access to allow charging
customers' credit cards? I don't have any programming background.

I have a form that contains the following:
2 radio buttons (Name and Number)
1 check box (for Inactive Members)
1 combo box (list of Member names or numbers)

I'm aware that Access is best used for small to medium size enterprizes.
What I'm interested in is the use of Access as a backend when it's managed
by SQL Server on the web.  I currently have an Access2K db (approx 80,000
records) where I'm the only user.  The db resides on my ...

hi, hope somebody could help me with this, have some users created on an
sql 2000, and am trying to know which user opened the adp , so everytime
i put msgobx currentuser it gives me admin, though it isn't connected
thru admin......thx

I have an Access frontend for an SQL backend.  I'm simply using ODBC to
connect.  On my copy of this Access database, I have four linked tables and
all works well.  If I copy the Access MDB to another workstation, I have to
1) recreate my ODBC connections, 2) delete all my linked ...

I am [still!] setting up a database for a friend who's an Optician,
using MS Access 2002. All seems to be working well, but I have hit a
snag.
There's a calculated field both in a form and a query which calculates

I use the default windows phone dialer to make calls from an Access form.  I
close the phone dialer after the call is made using the below function.  The
problem is I'm not closing the Phone Dialer application properly which
results in the Phone Dialer icon remaining in the system ...

Does anyone know of a sample database that contains a form with a calendar
where events can be entered and sisplayed on any day?
Thanks!
Jessica

I have to (2) tables, Events and Errors.
Events
-------------
RecordNumber

Here is a code snippet in my Report:
** Snippet starts here ************************
Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As
Integer)

My form contains a combo box and the "not in list" event is triggerred when
the user enters a value that is not among the values listed in the combo
box.  I want the user to be able to add a new value (which is fairly easy to
do) but here's the twist...

Does anyone know of any potential problems running a 2000 database with
2003?
Also, what about installing all other Office products as 2003 versions but
leaving Access as 2002 running a 2000 database?