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
Hello,
I want to hide or show a column on a subform thats in datasheet view by pressing a button on the main form.
Here is the code that I tried so far on the button but neither of the code below are not working...
Thanks Issac, it was tricky and I was not positive if it was a windows clipboard problem or destination program problem or Access issue but i have experienced before where my pc did not behave the same as someonelses that was testing on the forum here so i couldnt be sure but all you guys...
Finally got it to work - thank you everyone for your suggestions and getting me to poke around more.
I made a form displayed in datasheet view and set the unit price field format on the form to GENERAL NUMBER with 3 decimal places and it pastes correctly in my Outlook emails. Didnt even work...
I tried, but its not that, its actually rounding when i paste and i have to actually go into excel formatting and tell it to be 3 decimal places which then displays correctly so the info is stored but its rounding up. for example .057 is pasted as .06