Rabu, 28 Oktober 2015

Re: [MS_AccessPros] Re: Current record or row colour be highlighted

 

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 PM
Subject: Re: [MS_AccessPros] Re: Current record or row colour be highlighted

 

Hi 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