Search results

  1. A

    Pivot Query cant get the correct result

    Hi all im trying to achieve the below result with my pivot query but it seems not correct. TO ACHIEVE: KPIScore UserID KPICode July 2024 June 2024 $4.50 XXX000035 FRACRT04 $4.00 $5.00 $0.00 XXX000172 FSACRT01 $0.00 $0.00 $0.00 XXX000172 FSACRT07 $0.00 $0.00 CODE: TRANSFORM...
  2. A

    Filter Properties cannot be empty.

    yes you are right. i dont know the reason why it doesnt delete the filter at runtime.
  3. A

    Filter Properties cannot be empty.

    Hi everyone. have you ever encountered that your filter properties in continuous form cannot be empty even though you already created code to empty filter. i experienced this when my form encountered error and the last query will automatically saved in filter properties. Private Sub Form_Load()...
  4. A

    How to have sub total and grandtotal of Pivoted SQL Query

    thank you @Pat Hartman
  5. A

    How to have sub total and grandtotal of Pivoted SQL Query

    hi @theDBguy and @Pat Hartman. thank you for your reply. header will be the cost center that has been pivot. meaning there's no specific columns for this. depends on user's search. i already got the pivot table of cost centers. knowledge has been learned from other sources. what i want to do...
  6. A

    How to have sub total and grandtotal of Pivoted SQL Query

    TO ACHIEVE: Dept = total amt of cost center per dept Div = total amt of department per division BU = total amt of Div per BU TABLE: BU Div Dept CostCenter Amt Corporate Finance Financial Control XXFC0101 1,500.00 Corporate Finance Financial Control XXFC0102 1,000.00 Corporate Finance...
  7. A

    Solved Code not save when at runtime

    Hi all thank you for your replys and comments.
  8. 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
  9. 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
  10. 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.
  11. 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?
  12. A

    Listview will becomes empty when i disable it

    i'm sorry but it's a listview control not listbox.
  13. 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.
  14. 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
  15. 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 =...
  16. 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...
  17. 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...
  18. 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...
  19. 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.
  20. 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
Back
Top Bottom