Search results

  1. I

    Show pop up message every hour "Not registered..."

    Hi I want to show a pop up message every hour just to remember the client.."Not registered or so..." Any idea how to do it with VBA?
  2. I

    Update table which is already open

    hI I am trying to update a table with Update Query which is already opened by another Select Query. I get an info that table is already opened exclusively by another user or it is already open through the user interface and cannot be manipulated programmatically. Any idea how to update it.
  3. I

    check if there is connection to server

    Thank you...
  4. I

    check if there is connection to server

    In this example: dim token as string token = "&token=sEzwtdFW6v0VIq1c0jIeOzEDNS2xjy" Dim req As New XMLHTTP60 Dim resp As New DOMDocument60 req.Open "GET", "https://api.insure.gov.rs/rest/" & token, False req.send resp.LoadXML req.responseText ....the question is How to check if it is...
  5. I

    Import XML

    ??????????????
  6. I

    Sorting records in a form (subform)

    Thank you a lot for your effort I solved this in this way: on Event dblClick of my field "Artikal"" (cboBox) I put this code "docmd.runcommand acCmdSortAscending" and did the job
  7. I

    Sorting records in a form (subform)

    Hello How to sort entered records in a subform by combo box. Notice combo box has integer value not text. I want to bo sroted by text visibled ASC. The code must be in Command control SORT (See pict enclosed) I have tried something but not very successfull. Please help
  8. I

    Put a value from Totalquery into variable

    Thanks a lot.
  9. I

    Put a value from Totalquery into variable

    Hi I have a query like this SELECT qryBONUS_pre.PACIENT_ID, Sum(qryBONUS_pred.TOTAL) AS SumOfTOTAL FROM qryBONUS_pre.TOTAL GROUP BY qryBONUS_pre.PACIENT_ID; I like SumOfTOTAL to put into a variable How to do it
  10. I

    Output to PDF

    Yes...you gave me idea..back slash ("/") cannot be in the name of the file...I resolved this by changing "146-2014-OI" instead of "146/2014/OI" Thanks a lot...great
  11. I

    Output to PDF

    The Invoice Number can be this format "148/2014/OI" and this is a field in the Report, so I take the filed as title to output .pdf file i.e 148/2014/OI.pdf
  12. I

    Output to PDF

    Thanks Shane...I got this message "The OutputTo Action was cancelled" ..so this is not working
  13. I

    Output to PDF

    DoCmd.OutputTo acOutputReport, "rptINVOICE_PRINT", acFormatPDF, "C:\INVOICES\ " & ME.INVOICE & ".pdf", True Why I can't output to pdf with Invoice number as title to .pdf file Thanks in advance
  14. I

    Implementing SOAP in VBA

    јгдјдфјџдфјдф
  15. I

    FindFirst criteria

    Hi pbaldy I have a special question for you: I use a form to view Web page. After entering email and password (see pic2) I get result as in Pict 3 (blank form with headline Share Point) instead of full Web page as in ( see pic 1 ) How to solve it Thanks
  16. I

    FindFirst criteria

    Thanks a lot pbaldy
  17. I

    FindFirst criteria

    Hello can anybody tell me what is wrong with this criteria... RecSet.FindFirst ("[SomeField] = '" & mMESTO & "'") and ([CheckField] = True) Thanks
  18. I

    format number

    My pleasure...my mail is: irade92@gmail.com ..
  19. I

    format number

    If you want to visit Macedonia just let me know and I will arrange everything for you. Best Mr Rade Ivanoski
  20. I

    format number

    great Paul...thanks a lot and Happy New Year and many regards from Macedonia
Back
Top Bottom