I am having some trouble to just to populate two list boxes vendors and
products I generate the code, the computer don't like it.
Me.Products.RowSource = "SELECT ProductName FROM"
"Products WHERE VendorID= " &
Me.Categories
_ "ORDER BY ProductName" Me.Products = Me.Products.ItemData (0)
can u please help me
thanks
Mikevds
--- On Fri, 4/3/09, L Tumbulu <l.tumb...@sdvmalawi.com> wrote:
From: L Tumbulu <l.tumb...@sdvmalawi.com>
Subject: Re: [ms_access] Sum formula not working in the Control Source
To: ms_access@yahoogroups.com
Date: Friday, April 3, 2009, 3:29 PM
Dawn
You seem to be getting quite weird problems with your database. If the formula
is in the control footer or the report footer and the control source is valid
the formula should work i.e. If Num_Unit_Facility_ 01 is a valid control source
(check the underlying table) and the formula is placed in the
Num_Unit_Facility_ 01 footer you should get the correct answer unless there is
something wrong with your Access.
Looking at your question again you say that you have created the formula in the
Control Source of your Sum_Num_Unit_ Facility_ 01 field. This is not clear at
least to me. You place the formula in the control's footer on the report and
not in the Control Source. Perhaps I don't understand the question.
Regards
Liveson
----- Original Message -----
From: dawnmahc
To: ms_acc...@yahoogrou ps.com
Sent: Thursday, 02 April, 2009 19:55 PM
Subject: [ms_access] Sum formula not working in the Control Source
Hello everyone,
I'm pretty new to MS Access. I've created the following formula in the Control
Source of my Sum_Num_Unit_ Facility_ 01 field:
=Sum([Num_Unit_ Facility_ 01])
I'm getting the #Error message. I cannot figure out why this would be
happening. It seems like this would be the easiest formula in the world.
Can someone please help me?
Thank you in advance.
Dawn
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
