Rabu, 28 Oktober 2015

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

 



Khalid,
 
I tried your SQL below in my query, and highlighting still works.
 
Did you see my second posting about fault finding? What do the D1 and Ds boxes show?
 
Regards,
Dave
 
 
----- Original Message -----
Sent: Wednesday, October 28, 2015 10:46 AM
Subject: 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: "Dave Williams" <davewillgmale@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (28)

.

__,_._,___
Diposting oleh di

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)