Search results

  1. S

    Upload files to FTP or WEB Disk

    Hi I'm looking for code to upload files to FTP or WEB disk (I can create them both) If it's a WEB disk I don't want to map it in any way, just put the files in it Thank you
  2. S

    can you explain this loop ?

    Can you explain this loop, in the attached video ? Error in open db The path for the strFileName is wrong I run this routine only. I made it as a SUB to run it directly. Not calling it Here is the VBA code Public Sub TEST_XXX() On Error GoTo errHere Dim strFileName As String Dim...
  3. S

    Constantly repeating MsgBox

    I have a function that I put some MsgBox in it trying to trap an "Out of stack space" error Public Function fnGetDbVersion(strFileName, strFilePassword) As String On Error GoTo errHere fnGetDbVersion = 0 MsgBox "_fnGetDbVersion - 1" Set DataDB = OpenDatabase(strFileName, False, False, "MS...
  4. S

    Access 2016 to Office 365

    Im developing in AC2016 and need the app to run on office365 Are there any limitations I should be aware of?
  5. S

    ConditionalFormat in VBA

    I want to color the background of a text box, in a continuous form, based on the color codes stored in the text box itself. I know ConditionalFormat is the only way, as this is a continuous form How can it be done? I want it to be done on the "FormOpen" event. Thanks
  6. S

    number of "top" records in a continuous form

    how can I know the number of "top" (hidden) records in a continuous form, when I scroll the records ?
  7. S

    Applying format to objects on report

    Is there any quick way to apply format (ForeColor) for all objects in a specific section on a report? Something like: for each Object in me.Section1 ... .... Next Object
  8. S

    Solved Round result ???

    How can it be ? :oops: Round(me.Field1, 1) + Round(me.Field2, 1) = 100.00000375
  9. S

    read a text file from HTTPs not using CreateObject("MSXML2.ServerXMLHTTP.3.0")

    Is it possible to read a text file from HTTPS not using CreateObject("MSXML2.ServerXMLHTTP.3.0") ? though it might work well for HTTP files it will fail for HTTPS. What I actually need is reading a small TXT file that include a version number. reading a small and simple XML file can be an...
  10. S

    Solved Open a form as dialog with no borders. Is it possible ?

    I open a form from a function (It has to be a function to be run from an .OnDblClick event) I want the form to be opened and halt the remaining code from running. This form should have no borders. If I open the form in acWindowNormal the form will look as I expect but code will continue to run...
  11. S

    Solved how to Find a record on another form

    Hello I need to find a specific record on another open form. I want to select the "RecordName", based on the "RecordID" How can I do that ? Thanks
  12. S

    Solved Is VBA.Hex(lColor) give a wrong color code ?

    is it possible that VBA.Hex(lColor) give a wrong color code ? Seems I have to take it like Last2 - Middle - First2 :rolleyes:
  13. S

    Solved Function error

    Hi I'm using this code, but it will fail on Me Me.ProductPercent1.OnDblClick = "=fnCalcPercentFromQty_Click(Me, 'ProductPercent1')" This how the function looks like, so Me as Form should not be a problem Public Function fnCalcPercentFromQty_Click(frm As Form, strControlName As String) It...
  14. S

    Out of stack space error :(

    I get this error for 2 different end users :( Both are using Office 365 2 different Apps One of them is an old user who had no problem till yesterday :( He's using Office 365 16.0.1.2527.21230 Is it something wrong with Office 365 ? Missing file ?
  15. 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 ?
  16. 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?
  17. 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 ?
  18. 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...
  19. 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...
  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