I have a text box control on a form, the value of which is calculated
(concatenated) from entries on a subform.  Accordingly, I've set the
control's locked property to true and the tab stop property to false.  The
latter setting makes the control completely disappear.

I hope I can explain this all ok
I have on a form "frmCustomers" a command button on the [event procedure]
I have
Dim x

First of all apologies for posting so much code but this is rather involved
and I am totally stumped. Basically I have a main form (Staff Batch
SMS/E-Mail) which calls a function (SendSMS) in a module with in turn calls
a form (frmInet) which contains an ms internet control (Inet1). ...

I have an Access database that tracks project information. The
database is very simple, except for 1 small aspect.
Some background: 4 Tables - Project information, Employees, activity
and pay rates.

While you're waiting, try Super Viagra!

Hi gang,
Please help. I've been through the Access help, searched the Web, and
I can't seem to get a straight answer. As the Subject line suggests, I
want to run a fairly simple VB/Access Sub Function/Module that creates

Should I index fields that are linked to another table???
Note:
   - all links are ref. enforced
   - all links are one-to-many

Access 97
I'm lost on this code please can you help
=================================
Below is some simple code that will concatenate a single field's value from multiple records into a single string separated by a user defined character. There is no error trapping

Ok, I have an Access 97 GUI with SQL 7.0 backend.  On one database I'm
constantly getting a call fail.  I'm not sure why.  From the user
accounts it seems to happen mostly when they have the form open, but
are static...doing something else.  They begin to enter a record and

I'm conecting to ODBC to different RDBMSs and have a query in the form:
SELECT COUNT(*) from some_table WHERE LENGTH(some_field) <> established_length;
However, I just discovered that Access 2002 doesn't support this function (LENGTH).
Any clues or ideas on how to accomplish this?

I have an application (c#) that uses MS Access to store the data.  The
application install and works fine but in one windows 2k box (with
SP4) the application simple can't read the database.  I really don't
have a clue about the problem.  I've re-installed the pc with every

I have looked through the newsgroup for an answer to this but haven't
been able to find anything resembling my situation.
What I want to do is relatively simple, I think.  I have a crosstab
query that is bound to a report I am creating.  I would like the

I am trying to locate very small inkjet labels for a project of mine.
I am trying the Avery 8658, 189 per page at 27 x 7. Even they are too
big and I end up cutting them laboriously.
Ideally I need a selection of about 12mm by 3mm, 12mm by 6mm, 16mm by

Hi access gurus,
Is there a way to see what variables are currently in
use/active/declared/...?
so that I can identify where my code my need some cleaning up???

Good day
I am having a problem developing a web application for an on line catalog. I
am using ms access XP on an XP professional platfrom. I have been able to
succesfully develop a web page to query the database to produce a list of