Search results

Thanks, but I'm not sure I understand what you mean In my case I have an unordered query for the form. Clicking a button on the form will recreate the Form's record set based on the sort I ask. Do you mean using the Form.OrderBy Property ? Does it apply also for Filtering the Form rather then...

Not what I hoped, but this one work

Public Function fnEssentialOilsShow(byEssentialOilsCalc As Byte, intEssentialOilsQty, intBaseMaterialsQty, bytEssentialOilsPercent) As String Select Case byEssentialOilsCalc Case 1 fnEssentialOilsShow = intEssentialOilsQty & " Drops / " & intBaseMaterialsQty & "ml" Case 2, 3, 4...

Hi can anyone tell me why this query won't work and will ask for the [EssentialOilsShow] for the ORDER BY clue ? It will work perfectly If I remove this field from the ORDER BY It will sort perfectly for any other field [ProductName], [ProductPrice]... Thanks SELECT [Products].*...

I noticed it after I replaced a label with a button (I wanted the button Hoover effect) It happen in more then one place. They both run exactly the same code. It doesn't netter if the code is a form's subroutine or a function run by .OnClick event. It does happen when the record set is updated

I recently noticed that running the exact same code from a button click is by far slower then running it from a Label click :eek: I noticed that if run a sort it will load the turning wheel at the end of the run after all data is sorted and set, while running it from a button. This action alone...

Thank you :HUG & KISS: I never tried to change the shape of a button :eek: Regarding the Scroll bars I don't like the way they go on the sides of the Header/footer.

In your example they also go over the Header and footer. I guess going with a sub form will be the best option. I have another question for you In your example you use a line of buttons on top row (Or aren't they buttons?) How do you make them square without the round corners? Thanks

Im talking about scroling the records in a continuous form. I will never ask users to scroll the window itself.

Ok I found an older thread asking the same question. Unfortunately, its not possible :(

Sure, i can have a subform. Hoped i can void that

Sorry, the scrolbar

Is it possible to limit the slidebar to the detail section of form?

Thank Normally I won't point to another form in a query. In this case it's a form that opened by another form, so it must be opened. In Any case, I send it to the Query def as a string, and not asking the query to go into the form to read it. This is how I prefer doing it.

I won't trust Access to be that smart to read it only once, and not for every record if I put a DLookup() or DCount() into the query :D I prefer having it outside the query def and make sure I get it as a single value into the query def

Yes, sure. I will replace the Form's thing with a variable (It will be sent to the sub), and use the sane technique. Even if it was a function I would do the same to make sure it will be read once only, and not for every record.

Thanks, Adam This db is for Aromatherapy I need all materials that are not in a specific product The Products_Matetials is a Many to Many table, that hold the productID and MayetialDB

Yrs, i do talk VBA What do you mean by resolving the form refernce outside of SQL?

Thanks Can I also use strQ1 = .... And put into the query as ...) LEFT JOIN (" & strQ1 & ") AS Q1 ON...

I have this Query SELECT Materials.MaterialID, Materials.MaterialName, MaterialType_Table.MaterialTypeName FROM (MaterialType_Table INNER JOIN Materials ON MaterialType_Table.MaterialTypeID = Materials.MaterialTypeID) LEFT JOIN Q1 ON Materials.MaterialID = Q1.MaterialID WHERE Q1.MaterialID) Is...