AssignedEquipmentType and AssignedEquipment are text data type. Both are unique
five character codes. I have both fields in a continuous form. The database
requires that if an Equipment type is entered, an equipment item must also be
entered. I have the following code' to handle the ...

I have a field that has two first names with + in between them.. I'm
trying to run a query to substitute + with & . The update query
doesn't work because it deletes all the data field and puts "&"
instead.

Hello,
Firstly, I fill in a form for each record, which contains things like
name, date from, date to etc.
I have a list form in my database, which when opened displays certain

Greetings once more,
I was wondering if someone figured out the difference between attributes and
properties.
I noticed that things like fields have a number of properties, but also

Is there a way to cancel a change in an option group? The option group still
changes to the option clicked on when clicking on the NO button with the
following code in the BeforeUpdate event of the option group.
If MsgBox("Change?", vbYesNo) = vbNo Then

I have an application that has a back end and a front end. I need to add a table which is
identical to one in the back end, and then use it for a temporary holing place form some
records. I have done the following:
.    Copied the table in the back end and given the copy a new name

I have a textbox on a report that show the contents of a note field which
stores Memo data.
Quite alot of text can be typed by the user here but if it exceeds a certain
amount the textbox does not expand fully to show what was typed in.

Would like to know if there is a book out there on stored procedures
that takes you step by step on how to create them.  Have a book now
that shows examples of stored procedures but doesn't explain the code
very well and doesn't explain why you use certain code or exactly what

i have three columns
hrs_due, hrstaken, and totalhrsneeded
i need the default value of hrs_due to = totalhrsneeded - hrstaken
the data type of all is number>long integer, and i try to key =[totalhrsneeded]-[hrstaken] into the default value of hrs_due but it

Hello and TIA for guidance.
I am building a reusable search procedure (thanks go to Graham Thorpe
for his example that set me on my way).  Everything works up until the
2nd match is found, the command doesn't go to the third match, it

Please help,
below is my problem. Let's say I have 2 tables, a Products table and a
Colors table that go as follow:
Table Products

I am using
the Internet Data Transfer Library to ftp files to another server:
http://www.mvps.org/access/modules/mdl0037.htm
it works fine ftping to another server, but I cannot ftp from any server.  I

This is probably a simple thing to do, but I can't find how in the help
files or the manual I have.
I'm using Access 2000.  I have three tables joined by a common field, and
I'm using one form to enter data into all of them.  The form was created

As an alternative to DAPS and ASP, some of us who are not yet up to speed
with .NET, access Databases using HTML and ActiveXObjects.
I am considering doing this for some small utilities. But I cannot
guarantee users will have up-to-date ADODB and OLEDB on their machines

 Using VBA, I would like to be able to examine a report in design
mode and determine its page orientation (landscape or portrait).
 I do not want to change the orientation.
 I'm fine with getting to the point of having an Access.Report