Search results

Sir Arnel Thank you so much Sir this solves my problem thank you very much!

How can i do that Sir?

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

Still the Same Sir it Display two Date Values 1 in query FndLstBatCge20 and 1 in FndLstBatCge21 :(

Sir How Can i use the Dmax()? can i just replace the DlookUp in my current code?

Im Sorry Sir but i dont want to return 1 value in my 2 queries Sir. i just want to display the latest date last changed in a form even if they Both have values using Dlookup Sir.

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

thanks to Sir Arnelgp he fixed my problem.

Problem Is that when i open the certificate form and type a value it does not show the Current ID of the Main form. example in my main form the ID is now 500 when i open Certificate form its always in ID 1. what i want to is whatever ID number i am in Main form when i open the certificate...

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.

Thank you so much Guys i just temporarily solve this problem of mine by linking the previous DB tables from the current DB then use a Union query. i appreciate all your help if have another question please help me again hehe thanks again take care be safe always God Bless!

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

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

This Solved my problem Thank you so Much Sir Arnel

Yes Sir i want the same output whether it is awaiting parts or transfer. if i choose awaiting parts and put values on it, it will show on the report and same as transfer.

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

Hi i also have the same problem im trying to generate report using this =if([Inspection Section Remarks]="AWAITING PARTS انتظار قطع الغيار",[Inspection Section Remarks] & " >> " & [InspRem] & "/ Dmd No " & [DemandNo] & " / Dmd Dt " & [DemandDate],[Inspection Section Remarks] & " >> " &...

Im so sorry Sir im just a newbie in Access can you tell me how am i actually do that Sir?

same database both have table login with all information and also same form login Sir.

Thank you also Sir but we dont have formal domain and both db1 and db2 have their own login form and table login.