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

Rabu, 28 Oktober 2015

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

Hi Dave,

Yes, your method of investigating gave us the error.

I checked it opening the Form "Collection Voucher". My way of data entry is that first on main form user selects a "ConsignmentNo" from a combo box "ConsignmentNo" drop down list. Then from the sub form, Form Header he selects from "cmbClient" ClientCIN, Row Source of cmbClient is:

SELECT Clients.ClientCIN, Clients.ClientName, Consignee.ConsigneeName FROM Consignee INNER JOIN Clients ON Consignee.ConsigneeID = Clients.ConsigneeID;

and there are 5 more unbound controls on Form Header. Then on the Detail Section for the specific ConsignmentNo and ClientCIN Consignment is entered goods are received in the shape of Cartons.

I checked for ConsignmentNo 2015-B-07 for ClientCIN 3, which is displaying as follows i am not showing other fields on the Detail Section:

CartonNo ID1 IDs

1 3025 3026

2 3026 3026

3 3027 3026

4 3028 3026

5 3029 3026

6 3030 3026

7 3031 3026

8 3032 3026

9 3033 3026

10 3034 3026

11 3035 3026

12 4644 3026

13 4645 3026

14 4646 3026

15 4647 3026

16 4648 3026

17 4649 3026

18 4650 3026

You can see that IDs is not matching ID1 and for all 18 Cartons is the same 3026.

In Condition 1 Expression is ([IDs]=[ID]) Or (IsNull([IDs] And IsNull([ID])))

I thought may be ID should be replaced ID1, after changing the above to:

Condition 1 Expression is ([IDs]=[ID1]) Or (IsNull([IDs] And IsNull([ID1])))

Then on the first record/Carton i got

1 3025 3025

ID1 in the same above order but IDs for all 18 Cartons 3025

I hope my clarifications might give you some clue the error at my end.

Thanks once again for being with me.

Regards,

Khalid

---In MS_Access_Professionals@yahoogroups.com, <davewillgmale@...> wrote :

Khalid,

Sorry, here is my second posting that I sent to myself by mistake!

To investigate further, make all three textboxes Visible. On the continuous form view, the ID1 boxes should show a different ID for each record. The IDs boxes should all show the same number, put there by my OnCurrent event code to be ID for the record you happen to have currently selected. It will change when you select a different record. Only on the selected record will the numbers in the two boxes be equal, switching on the conditional formatting of the Highlight box.

Regards,

Dave

----- Original Message -----
From: khalidtanweerburrah@... [MS_Access_Professionals]
To: MS_Access_Professionals@yahoogroups.com
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 -----
From: khalidtanweerburrah@... [MS_Access_Professionals]
To: MS_Access_Professionals@yahoogroups.com
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