• ** 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

    not sure why, as I calculate it for a specific Product (ProductID) in any case I have no other option as I must do some calcs based on all data I don't want to calc Q1 for all records but my main question is how should my query looks like O r should I make Q1 outside the record source ? Thanks
  2. S

    form based of recuresive query

    this is the first part (Q1) CalcQtyML...
  3. 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 ?
  4. S

    Connecting to MySQL table

    Please talk to me in a language I can I understand :LOL: What ODBC driver? How do I link to the MySQL db ?
  5. 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?
  6. 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 ?
  7. S

    CreateObject("MSXML2.ServerXMLHTTP") not working

    How do I update my Crypto API ?
  8. S

    CreateObject("MSXML2.ServerXMLHTTP") not working

    I get the same error, on .Send :(
  9. S

    Cut a part of long text

    Mid() was what I'm looking for :) Thanks
  10. S

    Cut a part of long text

    I'll clarify
  11. S

    CreateObject("MSXML2.ServerXMLHTTP") not working

    Though at the end process I will need to download files, reading the content will be great :) It's a simple one short line content with a version number
  12. 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...
  13. S

    CreateObject("MSXML2.ServerXMLHTTP") not working

    RunTime error -2147012739 Error support the secured channel (Translated from Hebrew)
  14. 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...
  15. S

    Export to PDF will result with blank sub reports :(

    Even if it won't fix the problem the user will see the PDF just a sec before he send it. Hopefully he won't send bad PDFs
  16. S

    Export to PDF will result with blank sub reports :(

    As for now I decided to set the acPreview to true so the user can see the PDF file just before it attached to email
  17. S

    Export to PDF will result with blank sub reports :(

    Yes, All db is local too As I said the report is visible before I export it to PDF
  18. S

    Export to PDF will result with blank sub reports :(

    I show the report first Next the user can click a ribbon to export to PDF and send by email
  19. S

    Export to PDF will result with blank sub reports :(

    I create the PDF on a local machine
  20. 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 ?
Top Bottom