chr$()
especially chr$(10) & chr$(13)
and where do i find info on other chr$()
Thanks

I would like to compact a database with a macro as part of
a series of actions in that macro.  I would like to do
this as if I had selected the Tools -> Database Utilities-

 I have a list of words with definitions and references on a Word document. The words are in bold, the definition are normal and the references are in italic (you can see an example at the bottom). I wonder if there is a way that a macro can, automatically, copy individually ...

Is it possible to un-set the "confirm record changes" option in a macro?
Can somebody please post the command to do this?
Thanks,
Don

I want to display the value of one cell IF the value of another cell is within a particular range, but I am apparently making a mistake in the format. For example
IF(G9=30:59, G12, "") which I thought would display the value of G12 if the value in G9 was between the values of 30 ...

H
From an assigned command button ie. [yes] i want to update the relevant record in a field in a table (ie. with a 1 or a 'yes'), close the current form and open another form. The closing and opening i have no problem with - but i cannot get the table to update from my macro
can ...

I want to clear a textfield when a button is pressed the second time
Does anyone know how to do this
-----------------------------------------------
~~

How do you open a specific word file from access?

Anyone know a way to get the result from a formula that resides in a
calculated field on a form back in a table.  Result will be currency form.
Any help would be greatly appreciated
MTHarris

Is there a way to set a condition within a macro that will
identify whether I am coming from Form A (Add Screen) or
Form B (Modify Screen)?   I have information that I need
to pass from one or the other of these forms to Form C and

Thanks Bryan,
I'm not familiar w/ how to use the Excel Object model.  Could you brief me
or give me a location to study up on it?
Melanie

I have a project database which has the following fields:
StreetName (this has number and street)
City (this has city)(State is always FL)
I want to create a macro that opens a URL

I am trying to use sendobject from Access to Outlook to
send e-mails that are marked as high
importance/confidential.  I've attempted to set these
marks of high importance/confidential via my Outlook

I am working with two very simple databases.  I have
created a macro in the first one that links a table in
the second one and then appends that data into a table.  
The transfer itself works fine, but I'm not sure how to

Is there a way in Access to put the user's name in a msgbox.  I know i
Excel you can just write
MsgBox "Good Afternoon " & Application.UserName & "."
However, I've found in Access it's not the same.  Any sugestions?