Search results

  1. S

    Replace the ReachText tool bar?

    I'm trying to use the following code It will fail for the last 4 elements (Font colors and size). I guess they have wrong numbers. Where can I find the correct ones? I looked in here https://bettersolutions.com/vba/ribbon/face-ids-2003.htm Sub CreateRichTextShortcutMenu() Dim cmbRightClick...
  2. S

    Replace the ReachText tool bar?

    It's not in the ribbon when you select a text in a RichText box it load a floating ribbon I want to replace (Or remove) this one
  3. S

    Replace the ReachText tool bar?

    Thanks Will try I do use custom ribbons
  4. S

    Replace the ReachText tool bar?

    It's a long text so I prefer it to be a Rich one
  5. S

    Replace the ReachText tool bar?

    Thanks, I'll try will it hide the original RichText menu and the RightClick one ?
  6. S

    Replace the ReachText tool bar?

    Is it possible to replace the ReachText toolbar for a field ? I want to create my own toolbar adding the Copy, Paste, Cut buttons and removing some of the text formatting existing in the default toolbar. I also want to disable the right click toolbar for this field
  7. S

    Weird query issue

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

    Weird query issue

    Not what I hoped, but this one work
  9. S

    Weird query issue

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

    Weird query issue

    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].*...
  11. S

    running a code from Button is slower then from label

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

    running a code from Button is slower then from label

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

    Limit slidebar to details?

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

    Limit slidebar to details?

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

    Limit slidebar to details?

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

    Limit slidebar to details?

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

    Limit slidebar to details?

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

    Limit slidebar to details?

    Sorry, the scrolbar
  19. S

    Limit slidebar to details?

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

    Another Query assist

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