Hi: When i run my query between two dates its not sum WM_Amt on the
basis of two dates
SELECT tbl_WebMail.CRC, Sum(tbl_WebMail.WM_Amt) AS Totamnt,
tbl_WebMail.WM_Date

i have main from and employee form i need to create command buttonin the main
from that when you click on it employee from but with new record and taking
care of nothing dupplicate the old information
could you please help me with it

I am creating a main form in Design View.  It will just contain command
buttons that open other forms.
When I go to design view, it gives me the form canvas and the window that
the form is designed in.  If I wnat the form to be 3" by 4" I can drag the

I've got a form with a button to open up a list of management reports but I
want to allow only users who are members of "Management" to be able to click
the button and open up the list of reports. How do I go about doing that?
Thanks

I have a table with 2 columns, CoName & CoLocation
CoName allows dupes, CoLocation does not.
On my form I will create a drop box to choose the CoName.
I then want to use a drop box to choose the CoLocation while seeing

I recieved an E-Mail about a LOTTORY mail form a company that called himself
one branch of you.
please give and send for me clearly informations about it.
Thank you

Hi: I create a button on my main form. When i click on it the other
form is open in the background of the main form. Can anyone please help
me why it open in the background of the main form.
Thank You.

PLEASE CAN SOMEBODY HELP ME OUT ON THIS PROBLEM
I AM WRITING AND ACOUNTING DATABASE AND I NEED TO GET THE PREVIOUS RECORD
FIELD (WHICH IS SUM( "A" FIELD + "B" FIELD)
E.G

Not sure I have the title right here, but here goes
Thanks to an earlier post I now have my Form with many buttons beautifully
coloured etc. However as I update the information the data on screen becomes
dated ... I have toyed with the idea of storing information about Control

Is it possible to use the values selected in a Multiselect list box to limit
the results in a query (much like using a single value in a combo box or
standard list box)?

I have a button in a form which prints the record in use by clicking on it.
I wrote some code to do that.
However, I would like to replace that button by one comand in a toolbar
attached to that form.

Please somebody help me.
Whatever when I trying to put a calculated control in a text box in a form
design view , I get #Name appear in my sum total box in the form view.  Did
anybody experienced this.

PLEASE CAN SOMEBODY HELP ME OUT ON THIS PROBLEM
I AM WRITING AND ACOUNTING DATABASE AND I NEED TO GET THE PREVIOUS RECORD
FIELD (WHICH IS SUM( "A" FIELD + "B" FIELD)
E.G

Onclick event - copies data from one field on one from into another field on
a different form.
Main Form - Potential
Two subforms in Main Form (using tab control)

Is it possible to assign an On Click event to a label on a subform which will
allow you to sort the records displayed?  For example, the label for the date
field on a subform: click on it the first time and records are sorted
ascending. Click on it a second time, and records sort ...