Hi DBguy,
if this helps,
the sql for the listbox is :
SELECT tblStandardCost.ProductNum AS [Product#], tblStandardCost.Inactive AS Active, tblStandardCost.FinishedWideWidth AS W, tblStandardCost.Description
FROM tblStandardCost
WHERE (((tblStandardCost.Inactive)=False));
Hi DBguy,
if this helps,
the sql for the listbox is :
SELECT tblStandardCost.ProductNum AS [Product#], tblStandardCost.Inactive AS Active, tblStandardCost.FinishedWideWidth AS W, tblStandardCost.Description
FROM tblStandardCost
WHERE (((tblStandardCost.Inactive)=False));
Hi,
Thanks, but this didnt work, i really thought it would too, it made perfect sense to me but it made all fields invalid with type## errors
I will keep trying at it.
Hi,
Control source of listbox is blank, I added a listbox from design view and the wiazrd runs and i choose navigate to a record on my form.
It auto sets up a macro to do such,
The record source for my form is just the table:
tblStandardCost
Hi All,
I have a form that contains a listbox which is used to select a product and the form navigates to the selected record.
I also put 2 radio buttons on the form called Active and disactive. These buttons toggle what the listbox contains:
here is the code for one of the buttons:
Private...
Hello,
I'm having a problem getting the proper value from my calculated field in my table.
Does anyone see the problem here?
my calculated field is:
StdCost = ([R1]*[R1Percentage])+([R2]*[R2Percentage])+([R3]*[R3Percentage])
R1, R2, and R3 are all lookup fields that look to another table and...
Hi,
sorry if I didnt explain this clearly,
Each Resin is a separate record
ResinCode is the field name and some records are single resins, while others are blends made up of single resins within the table.
Hi All,
I could really use some direction on this please!
I'm not sure how to go about it.
I'm thinking it will have to involve multiple queries, not sure at all what i need to do.
I have a table with 5 fields.
ResinCode
R1
R2
R3
R4
There are some ResinCodes that are only comprised of R1 in...
Hello,
Does anyone know how to wrap text in a combobox dropdown?
I set the combobox "can grow" property to YES but it still wont wrap text on items longer than the specified column width.
Any suggestions would be much appreciated.
Thanks,
BJF