Search results

  1. J

    Solved get only the 1st Word in Report.

    Hello Sir's & Ma'ams I need Help is there a way to get the 1st word or if i want a specific word to display in Report when i generate it? and btw some of the words are not the same and also in the same page of the report. like for example Car All Types - i only want Car All to Display in Report...
  2. J

    DlookUp Problem

    =Nz(DLookUp("[Date Last Change]","FndLstBatCge20")) & Nz(DLookUp("[Date Last Change]","FndLstBatCge21")) Hi Sir's just want advice from experts the above code works perfectly when there is only 1 record Dates from these Query FndLstBatCge20 & FndLstBatCge21 However if there are 1 records on each...
  3. J

    Solved passing value from 1 form to another form

    Hi Sir's Good Day i Have 2 Forms 1 Main Form and the certificate form what i want to achieve is when i open certificate form from the main form is to pass the value that i typed in the certificate form and display it on the Main form. both form is in 1 table.
    • JRMT
    • Thread
    • Replies: 9
    • Forum: Forms
  4. J

    Solved query Multiple DB

    Hi Sir's Good Day I have a 3 Ms Access DB named DB2019, DB2020 & DB2021 they are all identical in Tables, queries forms, reports etc.. what i want to achieve is it possible to pull out Data, example those 3 DB have a Search Form if im in DB2021 and use that Search Form i can only Search the Data...
  5. J

    Solved Conditional Formatting in a Report

    Hi Sir's Please Help me im having trouble in condtional formatting I have a Report that has Job No, Date Received, Date Completed etc... i want to highlight Red the Maximum Number on the Job No. and highlight also Red the Newest Date in Date Received. how can i highlight also the Vehicle, Reg...
  6. J

    Solved IF statement in a report control source

    Hi Sir's im trying to generate report using this code =if([Inspection Section Remarks]="AWAITING PARTS",[Inspection Section Remarks] & " >> " & [InspRem] & "/ Dmd No " & [DemandNo] & " / Dmd Dt " & [DemandDate],[Inspection Section Remarks] & " >> " & [InspRem]) meaning if i choose awaiting...
  7. J

    MS access login form (2 database, 1 login form)

    Hi Sir/Maám need youre expertise please, here is the scenario i have 2 database ex. database1 and database2 both have login form. when you open database 1 you need to login, after logged in it has a button database2. when i clicked database 2 button it has a batch file that will actually open...
Top Bottom