I have a list of dates corresponding to department transfers and
terminations.  The list for a given employee may look something like
this:
1/1 - Dept A

Error 3035 is "System Resource Exceeded"
I'm throwing this error in a procedure that creates a pass through
query.  The procedure has worked tried and true for many years, first in
A97 and now in A2003, but for this particular use of it, I'm throwing

I created an access database and digitally signed it.
I then gave a copy of this Database to a friend.
A few months later he wanted me to make some changes to it so i took an
up-to-date copy from him and opened it on my computer..... but it tells

I am writing a java application that connects to a MS Access databse
with two fields , Date  and amount. I can insert into this datbase
using the application.
Now , I need to retrieve weekly totals(of the amount column) from the

Hi all, i have an input box that i need the user to put in a password
and just wondered if it is possible to just show a * as he types in the
letters as per the normal password inputbox ?
any help is much appreciated.

I created a form based on a query, likewise the i also have a subform
based on query, How do I create new records, allowing users to enter
the data in the main form and subform together? Can this be done or
must it be done independently?

I have two tables
table1:
id  state
-----------------

I have some unbound forms that I want to use transaction wrappers on when
updating the table. My question is on the scope of what transaction
processing will do. I'm going to keep it simple with the following code:
Code:

Can anyone recommend a piece of VBA code I could attach to a button in
a MS Form form that will close the current form and bring the
switchboard to foreground. I'm trying to integrate a form of buttons
into the way the switchboard gets used.

Greetings Gurus,
In a mainform's header, I have a combobox named comboStudents.  The
rowsource for this combobox is:
SELECT -999 As StudentID, "<Add New Student>" As FullName, "aaa" As

Am trying to import 20,000+ lines of text in a file
FTP'd from a UNIX platform to windows via FTP
session in a DOS box. About 2000 records have
multiple lines in them separated by CRLF's.

I have a string that varies in length  ie ABCDEFGH or ABCDEFGHI
what i want to do is read from the left 6 Characters and discard the
leftleaving only the right of th string
ie GH  or GHI

My application is split into a front end and back end. Each user has their
own copy of the front end.
There are a few forms I only want to be open for one user at a time. So I've
implemented the following strategy:

I am completely new to VBA.  I am trying to update a yes/no box in a
subform based on a value that I call from the main form into the
subform.  Below is the if /then statement i am using:
If (Me.[BalanceDue] = 0) Then

I have a bibliographic report, author, title, abstract etc which always have
data, and another field, ISBN, which can be blank.
How can I format my report to delete the ISBN field and label, and move the
line up to a position underneath the new last field (given that the ISBN