Hi Dave,
After reading your reply i did not made any changes to the end of my subform SELECT statement. Look it is as you have said in your reply.
SELECT CollectionVoucher.ConsignmentNo, [Consignment Number].ExportDocs, CollectionVoucher.Route, CollectionVoucher.ClientCIN, Clients.ClientName, CollectionVoucher.Destination, CollectionVoucher.DeliveryVr, CollectionVoucher.DeliveryVrDate, CollectionVoucher.CartonNo, CollectionVoucher.CartonSuffix, CollectionVoucher.TripNo, CollectionVoucher.UnitOfCarton, CollectionVoucher.ProductNameEnglish, Products.ProductNameRussian, Products.HSCode, CollectionVoucher.BrandName, CollectionVoucher.ProductQty, CollectionVoucher.UnitOfQty, CollectionVoucher.WeightOfCarton, CollectionVoucher.UnitOfGrossWeight, CollectionVoucher.[Net Weight], CollectionVoucher.UnitOfNetWeight, CollectionVoucher.UnitOfValue, CollectionVoucher.Rate, CollectionVoucher.Amount, CollectionVoucher.ID
FROM Products INNER JOIN ([Consignment Number] INNER JOIN (Clients INNER JOIN CollectionVoucher ON Clients.ClientCIN = CollectionVoucher.ClientCIN) ON [Consignment Number].ConsignmentNo = CollectionVoucher.ConsignmentNo) ON Products.ProductNameEnglish = CollectionVoucher.ProductNameEnglish;
Still I am on the same situation, not highlighting any row.
Regards,
Khalid
---In MS_Access_Professionals@yahoogroups.com, <davewillgmale@...> wrote :
Hi Khalid,
I should also have said that you have to add ", CollectionVoucher.ID" (without the quotes) to the end of your subform SELECT statement, before the FROM part. Hope this works.
Regards,
Dave
----- Original Message -----Sent: Tuesday, October 27, 2015 7:34 PMSubject: Re: [MS_AccessPros] Re: Current record or row colour be highlightedHi Dave,
Sorry to say i could not resolve the mystery yet...Regards,Khalid
__._,_.___
Posted by: khalidtanweerburrah@yahoo.com
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (27) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar