I am working with a small database that I reference a lot. I am trying
to create a command button where I copy the contents of a field to the
clip board to speed things up.
I expect this is a simple thing... but I can't find any example

My combobox is set to Limit To List.  When there is no match, Access
produces its standard message: "The text you entered isn't...".  To give my
own customized message instead, I use code in the NotInLst event.
Here's my problem.  When there is a 'no match', my customized message ...

Is there any way to requery information in a form without specifing every
field that new information was entered?  I know that as soon as I go into a
new record the information will be updated and appear in the Report.  Can you
get around having to move to a new record they back ...

Hi I need some project in Microsoft access where a user can enter name
of patient, general details like address, phone, age etc etc
is there anyone who has such a working thing ..

I'm using a combo box to perform filters and sorts on a form.   Is there an
easy way to pull the fields in the record source into a combo box?
Thanks
BW

I would like to send emails for accounts stored in access database.
Email may have a word or pdf document as attachment.
How can this be done in Access or if not how can it be done?
Thank you,

Private Sub SetForm_Click()
Dim sqlGroup As String
Dim i As Integer
Set rs = New ADODB.Recordset

I have a function that generates a SQL statement based on selections
(checkboxes) the user makes on the form. I want to have that function be
called whenever any of the checkboxes are changed (afterupdate event).
I know that I can create 23 different AfterUpdate event Subs, one ...

Is there a way to change the color of a forms caption bar without chaning the
overall look of Windows?
I have a form that I am creating for use on a classified system.  I toyed
with changing the background color of the entire form to red, but this is

I am using a search form with text values. when i enter a text string and
hit the search button values corresponding to the selection would be queried
and displayed. This search form works for all the values except for Stock no .
I have a feild called stock no - Input mask ...

I have a form that displays eMail address.  It is displayed in a text box,
the control source is a hyperlink field in my table.
How do I create a new email message, directed to the email address, and
display the email message for further editing by the user?

Could someone please help me with the code I need to add to the below code to
have the fome open in ADD-Mode.
This command button links the forms by "ICNNO" opening the form "f_ProvADD"
It currently opens the from with populated information.  I need to have it

Is there a way to get the main Access window's position and size compared to the screen display?
Thanks in advance for any suggestion.

I have a parent form  and a child form. The child form is filtered to
show only records related to the current record shown on the parent
form.
If I have both forms open, and enter a new record in the parent form,

I have a database that is working perfectly with one exception.
The database is used to store links to pdf files.  The one problem I run
into is that if an image is viewed access' program wants to save the file and
I get an error message that says the file cannot be save (over and ...