I created a button on a form to open my email program & would like to
automatically insert the records email address in the to: box.
How can i do this.
Thanks in advance

I did a search of this newsgroup and MS's knowledge base and couldn't
find an answer. I need to hi-light the active row (the one with the
arrow or pencil) in a table in design view in Access 2003.  I have a
large db with 35 fields and I'm continually entering data in the wrong

I just installed Office 2K3 Pro (except for Outlook, Publisher, and
PowerPoint) on the same computer with Office 2K.  With macro security
set to Medium, I get the infamous "unsafe expressions are not
blocked..." dialogs; but when I tried to make sense out of what I'm

On my form I have a tab control that contains 12 subforms.  The
child/master field that links the main form to each subform is
IncidentNo.  Each subform is used to record a corrective action that
needs to be taken when an incident occurs.  The user must enter the

Which msAccess SQL guru can help my out here?
i would like a list of sales(count) per day per customer
end result, something like:
distinct(date), customer, cnt(ItemsSold)

I have a form that allows a user to choose a [unique] specific field value.
The form calls a second, datasheet, form using a different field in
the selected record as a filter [also unique]. This second form has a
subform that lists information for all values of the field where ...

Hi all, i am a total newbie to this game and have a tblCounter with a
field of counter that i need to incriment by one when a certain form is
opened, please could somebody come to my assistance
Tempy

I have changed 3 fields in a table from text to number with 2 decimal places
and access has chopped all of decimal numbers so I only have whole figures
such as 21 or 51, not 21.25 or 51.22.
Is there a way to restore this data? and why did access chop it off??

I need a database to record students names etc and also to record their
levels at six times during the year for a range of subjects.  Obviously
there can only be one entry per student subject per time period.
I have some of the design figured but am a bit stuck. Can someone point

I am using Access 2002 and have two tables (Main and Actions) linked
(in Relationships) on one field "CAL_ID" (primary key in Main Table).
Main Table is a list of equipment.  Actions Table lists actions
performed on these pieces of equipment (calibration, cleaning, etc.) so

I need to export all data that was despatched on a specified date to an
excel file.
I tried creating a query but I am stuck?
Thanks...

I have added some VBA code to a form's OnCurrent event,
intending to retrieve information about the record that I am
scrolling _to_. Instead, this code is retrieving information
about the record that I am scrolling _away_ from.

hello have the following in access
1 peter 2434 1781
1 peter 2434 1666
2 paul 2987 1234

I have the following code in my load event, i've tried it under other
events as well, but no matter what, the code runs, but then access just
completely freezes and hangs until I kill the task, anyone have any
ideas why it would do that?

I'm working on a proposal for migrating a set of MS Access applications
over to an Application Server setup. We would want to be capable of
running things in parallel for a bit. The idea is to migrate the
database schemata and actual data over to a different, more scalable