I have a form where the user inputs a series of figures into a number of
controls. After they've input the total (they don't want the program to
create the total) there is a check to make sure the total of the controls
equals the totals they've input. Here is the code in the Before ...

Scenaria -
Access 2000 FE - 2 clients
Access 2000 BE - on a network server.
Tiny little application, all tried and tested code.  Worked fine until

The snippet of code below shows the long way to set a variable (lngRow) with
the value of a corresponding constant, based on a counter value.  Is there a
way I could set lngRow without resorting to the Case statement by
introducing the value of J into the variable name like this: ...

Students reports are produced in an Access databse written by myself
(amateur ... but it does seem to work!) Comments are written into a memo
field.  Many staff prefer to do this bit at home and cut and paste from
word.  This works fine, but some have decided to include bullet ...

I hided a Query (via properties), how to unhide??
Is there another simple way to protect a query so that nobody can run it?
Thx in advance
Steven

Access 97 here.
I want a simple way to "lock" certain records on a form. Some records remain
"live" until all data is available which happens over time. When all the
fields are complete, I want the record to be able to be "locked", or

Thanks again, Chuck, for your clsReadTextFile!!
I've been running some tests against a SOAP web service using Java and
Axis to make the calls, receive the responses and log the output.
I have 100ks of logging lines to sort through, and will build the log

Can anyone tell me where I could find a specific list of differences
between Access 2000 and 2003?  I have done extensive development in
Access 97 and 2000 but I have been out of it for about a year or so
and I am about to emark on another project so I need to know if it is

Hello all,
Newbie to MS Access.
I started using the Time and Billing template a couple of days ago. Now for
the fun part, changing what I have to what I can use.  

Is there any way in which I can have the background colour of one or more
records set to the colour stored in a datafield within the record?
Hans Karman, Canberra, Australia

I'm trying to create one query by combining several smaller UPDATE,
INSERT and DELETE queries. I know this is easily done in SQL Server
using GO, but I can't figure out how to do it in Access.
Is it even possible, or are there at least any workarounds?

Has anyone had any success forcing user to change their logon
passwords?
Code for Access 2003 or any prior version would be helpful.
Please reply to list or to my email.

I'm having some problems with an Access 2000 MDB file with a SQL Server 7
back end, using ODBC linked tables. I previously wrote about this, but am
reposting it with some additional information and in summary form, in hopes
that someone might have an idea about what's going on.

In MS 2003 or 2002 can anyone tell me the simplist way to change color
of text in a form or report? I want the values of currency fields
changed to red if the amount is >= to $1,000. I am not a programmer!
Thanks

Okay, so the Jet support is no longer in MDAC as of a few years ago.  This
was not a problem previously, as MDAC 2.5 was included with Windows 2000.
Now, however, Windows XP does not include MDAC 2.5.
(Right so far?)