If column is not empty

[Alhakeem1977]

I am sorry, that's because of my limited English knowledge.

I mean when I press the Update button which stopped running the code with a
message box saying " 2 records in the selected date range will be deleted."
I want to get the [ID]'s of those records in a text box in the same form "frmHolidays" like:

* [ID] 07 of [DDate] 14-Jan-18
* [ID] 11 of [DDate] 15-Jan-18

I don't know if this conveys my need.

Please don't bother about it if it consumes from your time.

thanks for your kind patience.

 

[isladogs]

OK - because you asked so nicely ....

I've done it by modifying the message box instead

This also gives users another chance to cancel
I've left the 6 records in the attached so you can easily test it

Hopefully this is OK for you now.
Busy doing other things for the rest of today

Good luck with your project

 

[Alhakeem1977]

Waw, what did you do for me, I really really thank from my heart, I do not know how to thank you for all this.
I really love from you to answer all my questions in the future, actually, this site made a lot for me.

Appreciate your kind efforts to have these features you provided to me in my application.

I will try in the nearest future to utilize the Barcode in other MS Access db any idea how to achieve that is there in Access an Add-Ins or Reference library to get the barcode?

I would like to thank you again for all your kind efforts.

 

[isladogs]

Thanks very much - glad I could help
The forum doesn't operate like that and rightly so.
Anyone who feels able to answer a question can do so.
If someone else can see a better way, they may add their own solutions.

When you are ready to work with barcodes, post a new thread.
However you may be pleased to know that importing barcode data into Access is easy - its treated like normal keyboard input
No special reference library needed