Recent content by atzdgreat

  1. A

    Solved Code not save when at runtime

    Hi all thank you for your replys and comments.
  2. A

    opening builtin attachments dialog box in access

    Hi All, good day. may i know if possible to open attachment dialog box using command button? something like this: Private Sub BtnAttach_Click() Attachment.Open End Sub
  3. A

    Solved Code not save when at runtime

    hi thank you for your reply. Yes @The_Doc_Man you're right when i implement a code fix then switching to view mode and then close the form, all the code changes are not saving. so currently what i'm doing right now is to close my access and recode before switching to view mode
  4. A

    Solved Code not save when at runtime

    Hi all does anyone experience about losing their codes even though it was already saved once the form runs or even close. it's like once closing the form, its doing undo.
  5. A

    Listview will becomes empty when i disable it

    no worries. thank you.. by the way maybe you can help me out how can i change the fore color of the specific row in listbox?
  6. A

    Listview will becomes empty when i disable it

    i'm sorry but it's a listview control not listbox.
  7. A

    Listview will becomes empty when i disable it

    Hi @bob fitz thank you for your reply. i just used me.Listview3.enabled = false. and the other issue that i encounter is whenever i enable it using me.listview3.enabled = true. the left position will become zero and top position will become zero.
  8. A

    Listview will becomes empty when i disable it

    hi all, may i know why my listview becomes empty when i disabled it. enable disable
  9. A

    how to insert attachment in sharepoint list using ado access vba

    hi all. i dont know how to insert an attachment in sharepoint list using ado. Dim objStream As ADODB.Stream Dim conn As ADODB.Connection Dim rs As ADODB.Recordset Dim pdfPath As String Dim strSQl As String pdfPath = "C:\Users\xxxx\Documents\24-0001.pdf" Set objStream =...
  10. A

    Solved how to create a relationship where columns depends on another column

    OBJECTIVE: To create an entry in table where Business Unit Column will depend on what is inside in Organization Column. Same thing in Business Unit Code, TABLE: Organization BusinessUnit BusinessUnitCode X Org Finance FIN X Org Payroll PYR X Org IT IT X Org Surveillance SRV Y Org...
  11. A

    Solved How to achieve Pivot

    OBJECTIVE: Period Taken is Feb 2024 CY MTD Column is a total amount for Feb 2024 Period CY YTD Column is a total amount from Jan 2024 to Feb 2024 Period PY MTD Column is a total amount for Feb 2023 Period PY YTD Column is a total amount from Jan 2023 to Feb 2023 Period COHN314 and COHN315 are a...
  12. A

    Pivot inside Select Query

    hi everyone. is it possible to union transform query? SELECT * FROM ( TRANSFORM Sum(t0.TotCost) AS SumOfTotCost SELECT t3.HierarchyLine+'.02' AS Hierarchy, t3.HierarchyMain, t3.HierarchyDetails, t0.LedgerDet, t1.ThisPeriod, t2.YTD FROM (([Main Table] AS t0 LEFT JOIN (SELECT LedgerAcct...
  13. A

    Is it possible to change duplicate value to zero in specific column by query?

    Hi @June7 kindly check my attached image. if PO Amount are redundant, when you pivot the data, it will sumup.
  14. A

    Is it possible to change duplicate value to zero in specific column by query?

    Yes Sir. so whenever this would be extracted to excel and user will do a pivot. it's easy for them
  15. A

    Is it possible to change duplicate value to zero in specific column by query?

    OBJECTIVE: To create a Result making duplicate value as zero in PO Amount AVAILABLE TABLES: PO Table Suppliers Table This is what my SQL query so far: SELECT t1.*, t2.* FROM PO_Table t1 LEFT JOIN SI_Table t2 ONE t1.[PO Number] = t2.[PO Number] `
See more
Top Bottom