I am currently working on an Outlook automation module in an Access 97
database. All is working well except now the client wants the generic email
body to contain certain sections in red text and others in blue text. Can
this be done? If so how? I understand that I may have to ...

Opening one particular query in design mode shows a blank top half,
where the tables should reside. the bottom half is what I expect to
see with the field names over their table names over the sort and
criteria boxes, but the only way to add new fields or change

I have a form with two sub forms.
I would like a query to use the value in one of the fields of one of
the above mentioned subforms as a parameter for the query.
I've tried to point at the form field from within the query but I'm not

Is there a function to populate a string with say 50 dashes
Something like
astring = function??("-",50)

Hey all!
Here's what I want to do:
I have database A.mdb and database B.mdb.  They are both using SQL
linked tables, and I am utilizing a username/password login reference

I was wondering, is it possible to put a password on a single table. My
reasoning is that i have a 'Master Staff Table' that is the backbone of all
the reports i produce but sneakily other people are going into it and
amending records which causes problems for me. I cant just move ...

I have the following code:
Private Sub cmdDatasheet_Click()
   DoCmd.OpenQuery "qryCourse_Details"
End Sub

I have a list box which I refresh by changing the .rowsource and doing
a requery after adding a record to the table:
QryOrderDetail = "SELECT [TblOrderDetail].[OrderDetailId],
[TblOrderDetail].[LUOrderId], [TblOrderDetail].[OrderDetailQty],

I'm viewing a database that only has the file, window and help toolbar
visible in Access but I would like to view the relationships etc. How can I
view this?
Thanks so much,

I am running a report that is drawing in data from 5 different queries.
The report has five different fields and a sum field to tally up the
values in the 5 different fields.  The data is loaded into the report
based on which business unit/business units is selected via checkboxes;

I am getting an overflow error on the following:
intPercentNotPaid = IIf(intNumberApproved = 0, 0, intNumberNotPaid /
intNumberApproved)
The intNumberapproved is 0, but it is still evaluating the False part

I have to reference a library (DTSPackage.dll), but the other 40 users
do not need the code that refrences this library. And since they don't
have SQL Server loaded on their machine, they don't have this file.
I tried to put the dll on the network, but it won't register.

After creating a new dtabase and system.mdw permissions and security
can be bypassed by opening the database with the default system.mdw for
access 2003. This was not true with access 2000.
Any thoughts

I asked this question in an earlier thread, but I didn't get an answer,
so I'm trying again:
How do I digitally sign an application with Access 2000? (I already
have a certificate; I just need to sign the app with it).

In an Access form, I'd like to show the status on whether an item as
entered in a textbox (and thus in its coupled record field) exists in a
list in another table. I've tried:
 - Making the record source of the form a query, like