Search results

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, The code is in an embedded macro it uses a where condition: ="[ProductNum] = " & "'" & [Screen].[ActiveControl] & "'"

Not sure how to go about that?? My record source for the form is just tblStandardCost, no query just the table

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...

Thanks very much for the response. I will go o we it again and see if I can work a query into it to achieve what I am looking for. Thanks, BJF

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...

Thanks for this response Plog, I will have to think about this and make sense of it before i do anything else.

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...

ok, thank you for the responses, i will check into DBguys suggestion. Im not familiar with writing functions but ill try.

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, Is it possible to reference columns of a combobox in a query on another form? Thanks for any information, BJF

Thank you!

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