Search results

Dear Paul, My requirement is like that. i need to fill the data in the form, once i reach welderA the code/dlookup start comparing the data in the form based on the data in tb example: if i put 2 in pipe dia after welder update the code shall check if the value is within the range of Dai Max...

Dear Paul, here is sample database of my DB for your Referance.

Dear Pr2-eugin i try to use DLookup/DCount but it seems it will be very long Dear Jems i did not get you? but as far as i see in the forum there is selcet case in VBA with may solve this problem

Dear All, first of all, i would say this the best forum of ms access for biginners. my issue is i have multilble text box in my form & based on change in one of this text box i need the code to compare between data in the form & table & returm Msg if it is not matching. attached screen FYI. i...

Dear Namliam, i was thinking the same think however i try to fill the record set with Qry & tab but same problem did not work?:banghead:

Dear Namliam, thanks for replay the issue was that i can filter with spool N but the code did not allow me to filter with joint N & that was my issue (see red highlighted). not that ISO N was only mistake from me. Private Sub cmdJointN_AfterUpdate() Dim geog As Integer, fnd As Boolean Dim...

Dear JHB, i already delete the duplicate from General forum the same time you inform me this is FYI.

Dear JHB, i did comment with thanks button :D

Dear JHB, let me first thank you for the great change you made in the DB. for the forum rules i will have your advice in a future consediration. the forum is very useful for MS access users. thanks again:)

Dear All, i am new in this forum & would like some help. attached DB is filtering Spool N but not working for joint N Need your URGENT replay. thanks in adavnce :banghead:

thanks JHB, i was just trying to solve my problem asap

Dear JHB, thanks for the info. i was just trying to have my problem solved.

any one around can help?:(

Hi, this is 2nd time i am posting in the forum & i hope my problem will be solved, i attached database & would like to filter the data by ISO N & Joint N. the first filter is working but there is small problen in filter joint N. please see the VBA to refer to the problem. thanks in advance

Hi, this is 2nd time i am posting in the forum & i hope my problem will be solved, i attached database & would like to filter the data by ISO N & Joint N. the first filter is working but there is small problen in filter joint N. please see the VBA to refer to the problem:banghead:. thanks in...

Hi, this is 2nd time i am posting in the forum & i hope my problem will be solved, i attached database & would like to filter the data by ISO N & Joint N. the first filter is working but there is small problen in filter joint N. please see the VBA to refer to the problem. thanks in advance

Dear Sir, Many thanks it works but still did not gave me a result (Rows empty) it shall give me last update with other information for each DWG

no i have also date for each record do you have any suggestion will be much appreciate

Please i need help DRW N Action 400 RTO 400 Send to RT 400 RTO 400 RTO[/color] 500 RTO 500 Send to RT 500 RTO 500 Send to RT i want to test the rows & get the latest Row Action for each DRW N (400 = RTO - 500=Send to RT) Please note that i have many DRW N duplicated in my Table...