• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Search results

  1. S

    form based of recuresive query

    I have a form that is based on a query The first query will calculate amount of material in product (AmountOfProduct * PercentOfMaterial) The second will take the first one and calculate the price and weight. (Query1 * MaterialPrice, Query1 * MaterialWeight) How can I do that ?
  2. S

    Connecting to MySQL table

    How do I connect to MySQL table ? Never worked with MySQL Is it possible to temporary connect to the table or do I need to create a permanent connection?
  3. S

    Access Menu and ToolBar (Custom) disappear when opening Excel or Outlook

    One of my users have a big issue with this whenever he open Excel or Outlook the App Menu and ToolBar (Custom) disappear :( Any idea ?
  4. S

    Cut a part of long text

    How can I copy a part of long text ? I know the start and end points I want to copy it into another place *** Edit *** The text I'm looking for is part of field data, not on form What I'm looking at the end is for any "FontStyle" other then Bold, Underline or Italic. They all should be...
  5. S

    CreateObject("MSXML2.ServerXMLHTTP") not working

    I'm using CreateObject("MSXML2.ServerXMLHTTP") for long time to automatically download files from my server recently I can't download getting an error with secured channel I get the error on .Send it does not netter if I send the file to get as HTTP or HTTPS the files are public so no need...
  6. S

    Export to PDF will result with blank sub reports :(

    I'm exporting reports to pdf using DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF, strPDFfile After exporting the report is sent by email sometimes the end user get the report with blank sub reports The report looked OK before exporting and sending :( Any idea ?
  7. S

    Paste as Plain Text msoControlButton

    I'm using a right menu click menu Since the field is a rich text one I want to limit the users to paste a plain text only, but can't find the correct msoControlButton button ID :( Is there another option, If there is no special ID for it ? Thanks ' Create the PlainText menu. Set...
  8. S

    Solved is it possible to alter an hyperlink in the backstage part of the Ribbon?

    I want to customize a Hyperlink I already have in the BackStage part of the Ribbon. I use getLabel/setLabel, getStyle/setStyle.... to change things in VBA I'm trying to do the same with getTarget/setTarget to alter the target of an Hyperlink, with no success :(
  9. S

    Removing font styles from Rich text

    How can I remove all Font Styles from a rich Text field in table. I want to leave only the <B>, <U> and <I> styles font styles will start with <Font.... > and end with </Font>
  10. S

    What method is better and faster

    If I need to update only a field or two for a specific record in table. What method is better, faster, cleaner.... ? Open a recordset or use an Update query ?
  11. S

    HTTPS Secured channel error

    I'm using VBA to download files from my domain (A Sub Domain) I'm getting an error that there is a problem with the secured channel. This will happen if I try to Download the file using HTTPS address but will not if I use unsecured HTTP addres The domain do have SSL, and I have no problem...
  12. S

    Outlook express cause Access to hang

    I have a problem that Outlook Express cause my Access App to hang :( Anyone else has this problem ? Just to clarify - I don't connect to outlook or use outlook in my App in any way. I do send mail using CDO
  13. 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
  14. 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].*...
  15. 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...
  16. S

    Limit slidebar to details?

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

    Another Query assist

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

    Out of stack space error

    I get this error on one end user's machine. I don't have this error on my machine nor any other machine the application installed on. Is there any way to identify where this error come from ? Thanks
  19. S

    Adding blank empty field to Continuous Form

    How do I add a blank empty field to all records on Continuous Form. This field will be used to calculate another field, using the AfterUpdate event. As I read here the only solution is to add the field to the table :( Is it really? Thanks
  20. S

    Google cloud assist

    After giving up with GDrive (Almost) I want try using Google cloud for automatic backups I'm trying this code but I gen an "AccessDenied", "Anonymous Caller does not have storage objects" What is wrong with the keys ? With xmlHTTP .Open "GET", "https://storage.googleapis.com/MyBucket"...
Top Bottom