Search results

  1. arnelgp

    want to come to an online user group meeting?

    yes, i saw the film today, oh boy... but the position is already defined in the table, so it is not dynamic. try, resizing the chart, if your line will also follow when the form/chart resize?
  2. arnelgp

    Solved How to scan a barcode from a parent form and update the child/subform in MS access

    here test your form. see the code on the "barcode" (main form) Before and After Update event.
  3. arnelgp

    want to come to an online user group meeting?

    you tried to resize the form, but the chart did not resize with the form and so does the marker:LOL: also the position of the marker is predefined and not dynamic.
  4. arnelgp

    Class_Terminate() on project reset?

    when runtime error occors, variables are destroyed.
  5. arnelgp

    Convert acrobat 9.0 PDF to Image .PNG Using VBA Code

    you have another alternative (Tested also). using GhostScript (can be downloaded here: https://github.com/ArtifexSoftware/ghostpdl-downloads/releases) use the "older" version (pic1) and download whichever windows bitness you have. when installed there will be two .exe on the installed folder...
  6. arnelgp

    DEMO: How to display different background colours on a Continuous type form.

    what you can do as band aid so the color stays when you click or enter the control, is to call again the Detail Paint event on: 1. control's Click Event 22. control's GotFocus Event Ms.Gina Whipp has another interesting demo of using Ascii characters (instead of Long Richtext with color...
  7. arnelgp

    Solved Multiple listboxes on main form

    you can "force" Listbox3 to filter (based on Listbox2), by adding additional code ot Listbox1 AfterUpdate event. Private Sub Listbox1_BeforeUpdate(Cancel As Integer) Listbox2.Requery If Listbox2.ListCount <> 0 Then Listbox2 = Listbox2.ItemData(0) End If Listbox3.Requery End Sub
  8. arnelgp

    Convert acrobat 9.0 PDF to Image .PNG Using VBA Code

    it is easy if you have Debenu (Foxit SDK), just small number of lines: Private Sub test() Dim lic As String: lic = "xxxxxxxxxxxxxxxxxxxxxxxxx" Dim iNumPages As Integer Dim sPdf As String, sOut As String Dim qp As DebenuPDFLibrary64AX1811.PDFLibrary Set qp = New...
  9. arnelgp

    DEMO: How to display different background colours on a Continuous type form.

    no problem, what makes you say that?
  10. arnelgp

    Convert acrobat 9.0 PDF to Image .PNG Using VBA Code

    same page Agnes get it's answer.
  11. arnelgp

    Convert acrobat 9.0 PDF to Image .PNG Using VBA Code

    you have exactly the same answer as Agnes AI.
  12. arnelgp

    Convert acrobat 9.0 PDF to Image .PNG Using VBA Code

    https://myengineeringworld.net/2013/03/vba-macro-to-convert-pdf-files-into.html
  13. arnelgp

    DEMO: How to display different background colours on a Continuous type form.

    from the attached pdf: "The simple formula for the calculation is ([UnitsInStock]+20)/20 which produces a floating-point number which is converted to an Integer in the Result Type property. In a ‘real’ application you would probably need a more complex query (or even some VBA code) to create...
  14. arnelgp

    Solved First Record In Subform Calculated Control #Type!

    are you sure you don't have Null values on some of your Fields used by the function?
  15. arnelgp

    Solved First Record In Subform Calculated Control #Type!

    test the function first and see the result, is it numeric or string or date?
  16. arnelgp

    RegExp Added to VBA Library with Office Version 2508

    RegExp can be created late-bound, so i think there is no problem. other application, not ms product also use RegExp, so I don't think it will pulled out from Windows.
  17. arnelgp

    RegExp Added to VBA Library with Office Version 2508

    just believe everything you read. maybe AI wrote those for you to believe.
  18. arnelgp

    Back End Read-Only Issue

    that is another, No, No. as much as possible the shared folder should only be 1 folder depth.
  19. arnelgp

    Solved Conditional formatting without conditional formatting

    use Paint Event of the Detail section to set the color of each Conditions.
  20. arnelgp

    Solved Copy Paste Text Too Long error

    it will always bloat when you store the "data" in a table.
Back
Top Bottom