Hi Khalid,
That's strange. I tried changing ID to ID1 in my conditional format, and it still worked just the same. My original conditional highlight expression referred to ID, the name of the autonumber field. You have now changed the condition to the name of the ID1 box, which has ID as its control source, and should give the same effect.
In your example below, when IDs was 3026 you must have had the second row selected, and when it was 3025 you had the first row selected as you said, and I hope highlighted at last.
There is another Access user group I look at - comp.databases.ms-access. By amazing chance someone gave an answer three days ago how to highlight rows like you. I see from this that my IDs box could be put in the footer (if there is one) to avoid getting in the way of the record boxes in the Detail section, and also there's no need for my ID1 box, provided you put the name of the ID table field (if it's not 'ID') into the conditional format expression, instead of the box name ID1. Maybe you called your autonumber field ID1 as well as the box.
I'm so glad all is now OK.
Regards,
Dave
----- Original Message -----Sent: Wednesday, October 28, 2015 5:24 PMSubject: Re: [MS_AccessPros] Re: Current record or row colour be highlightedHi 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 IDs1 3025 30262 3026 30263 3027 30264 3028 30265 3029 30266 3030 30267 3031 30268 3032 30269 3033 302610 3034 302611 3035 302612 4644 302613 4645 302614 4646 302615 4647 302616 4648 302617 4649 302618 4650 3026You 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 got1 3025 3025ID1 in the same above order but IDs for all 18 Cartons 3025I 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 -----Sent: Wednesday, October 28, 2015 10:46 AMSubject: Re: [MS_AccessPros] Re: Current record or row colour be highlightedHi 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.IDFROM 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: "Dave Williams" <davewillgmale@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (31) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar