Sorry for repost but I haven't see the answer.(Just back
from leave).Below is my problem:
I have a module to sent email from access with attachment
is a pdf Access report.

       I have the below code which copies records from a query to a table
as below which works fine, but I want it in the last line where it copies:
MySet2![DAILY CHARGE] = MySet![Price]
if in the

hey! it's me again! let me rephrase my statement. we were taught of how to
make a database but only the basic ones. i know how to make tables, forms,
queries and reports. we were taught how to make action queries but not on how
to apply them directly in the forms.

Can Some Help me out with my Append Query or help me with a better way
to do what im achieving.
table one is Clients and table two is Suppliers.
to each table i have related table client contacts and

I've got a problem which I don't really know how to tackle.
I've got a table with records which I fill out via a form.
When I add a new record, I'd like some information to be filled in
automatically based upon information available in previous records.

I've got a form where I want to disable the default shortcut menu, but want
to display a custom menu for a listbox on the form.
I've tried a number of settings of the forms shortcutmenu property (Yes/No)
and combinations of other items, but cannot seem to figure this out.

I created a shortcut (poopup) menu for the form.
It works fine when I created and tested.
The shortcut function execute.
For some reason it dees not execute the function any more.

When I create random numbers for an application with the following code, they
do not appear to be truely random.
   Me.RandomNumber = Int(9 * Rnd + 1) ' Random Number 1-9
If I have two users setting side by side, they frequently get the same

I have a dynamically created and amended table which occasionally contains
duplicate records.  These duplicates must be allowed but need to be
flagged-up, when they occur, and marked in the table.  Setting the No
Duplicates property is clearly inappropriate.

I want the button to fill a text box with the data from the table as
selected by which value is selected from the list box.   It shows #Name? in
the text box  Txtblvalues, and when I look at controlsource of the
Txtblvalues it does show the strSQL . I think it is a syntax error ...

I am trying to print just the one record that is being viewed in the form in
report format. The primary key is a text field - "File number".
I have tried to use this code but it doesnt seem to work
Private Sub cmdPrintSummary_Click()

hi! i am a beginner in making a database, and we have this project at school
in making one. can anybody help me out in starting a database?
first of all, i want to ask how to make and where to put codes in my database.
by the way, i'm using ms access 2003.

Hi, in MS Access 2003 I would like to hightlight an entire row in a
continuous subform so that it emulates a selected item in a listbox.
I have searched past posts to this group and the solution seems to be to add
a text box to the form. Then use conditional formatting where ...

at once when i try to edit or open some forms i got such error msg
"There isn't enough memory to perfrom this operation. close unneeded programs
and try the operation again."
I have 1GB Ram so it is sure silly msg !! what to do

Environment:
1. Front-End - MS Access 2003
2. Back-End - SQL Server 2005
3. OS - Windows XP