Search results

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...

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...

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

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

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] `

hi @theDBguy thank you for your reply. i have thoughts on converting my access to sharepoint list but unfortunately i cannot find any solution on connecting sharepoint list using excel vba ado.

OBJECTIVE: to access database in MS Teams using excel vba macro. CODE: Dim DataStr As String Dim connStr As String DataStr = "https://xxxx.sharepoint.com/sites/TRF/Shared Documents/General/database.accdb" connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & DataStr & ";" _...

Thank you for your answer

TABLE: Table_Test OBJECTIVE: to consolidate employee according to their time in, time out, and roster type. RESULT: EXPLANATION: If Employee was not on leave nor late nor early out. The Rostered Type to be retrieved is always Start and End. If Employee was Late. The Rostered Type to be...

hi @ebs17 i already saw your sample. thank you so much for this. this is a very big help for me.

hi @ebs17 my apology for not getting back to you sooner. i will now check today and get back to you soonest. advance blessed new to all of you. thank you.

Hi @ebs17 and @jdraw thank you for your reply and my apology for my post was not clear. with @ebs17 both question, its Yes. as an example to my post, let say the vendor has 4 pcs. of apple, 6 pcs of Banana, 4pcs of Mango and 0 orange. these are the available items in the inventory. now the...

hi @mike60smart thank you for your reply. i already updated my post.

AVAILABLE ITEM: itm_bundle column represents the item (per piece) included in the bundle). OBJECTIVE: To create a correct query for an inventory item per piece and per set. In order to produce an item set, the smallest qty of item piece will the basis: Example for Set A: a combination of 1...

because next year we're planning to migrate in windows 10 32bit

yes since i am at is with listview than listbox.. but do you think windows 32 it will?:(:(:(

yes i tested it in textbox and it works fine. but in listview it doesnt. hmmm maybe because listview is not part of access? unlike in excel? since we need to declare the listview first like... Dim LV As MSComctlLib.ListView im not so sure with this.

hi sir arnel, thank you for your reply. i tried keypress event but still no luck. i dont know why only vbkeydown=vbkeyreturn or keyascii=13 cannot be catch. the rest keys are fine. i tried changing the option/Client Settings/ Move after enter to Dont move or next field as well

hi may i know why it wont catch the enter key in listview control in access. Private Sub lvCMAList_KeyDown(KeyCode As Integer, ByVal Shift As Integer) Dim DirFile As String Dim NewCtr As Integer Dim BOk As Boolean Dim msg Dim LV As MSComctlLib.ListView Set LV =...

if ever i am going to reconstruct my data table, is there any possible i can achieve the report? thanks