Search results

Hi @plog and @The_Doc_Man thank you for reply. so this is a sample of my raw data KPI_qryMain KPICodeKPICode1KPITaskChildKPICodeChildKPICode1 SRSMRT01SRSMRT01Washing PlatesSRSMRT02SRSMRT02 SRSMRT02SRSMRT02Cleaning Bedroom SRSMRT03SRSMRT03Laundry KPI...

i tried to change the my query to LEFT JOIN KPI AS t3 ON (t3.UserID = t1.UserID) AND (t3.KPICode = t1.KPICode)) but still gets the same error. the specified field 't1.UserID' could refer to more thn one table. @Eugene-LS thank you for your reply. i'm not sure how the query outputs 'UserID'...

HI @MajP thank you for your reply. i'm not quite sure but i already specify the table which is KPI_qryMain as t0.

Hi i would like to ask for your assistance why i'm getting error. "JOIN expression not supported." Code: SELECT t2.KPICode1 AS OrigCode, t0.KPITask AS OrigTask, t2.ID AS TimID, t2.Score AS OrigScore, t3.ID AS AccID, t3.Score AS DepScore, t1.KPICode AS DepCode...

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

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

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

thank you @Pat Hartman

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

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

Hi all thank you for your replys and comments.

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

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

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.

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?

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

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.

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

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

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