Customize Auto Numbering in Ms Access

[@ezekiel4011]

Thanks for this presentation.

[@EdcelleJohnGulfan]

You're welcome

[@BiHsinalco]

Love what you do, thank you.

[@EdcelleJohnGulfan]

Thank you so much.

[@ByteBrigade6275]

Thank you sir.👍

[@EdcelleJohnGulfan]

You're welcome and thanks for watching.

[@ByteBrigade6275]

@@EdcelleJohnGulfan galing mo sir, almost 1 year ndin ako nag start ng ms access. dami kong ntutunan sayo. wag k sana sir mag sawa gumawa ng mga gantong videos.

[@EdcelleJohnGulfan]

Hangga't kaya pa at maraming pang nanonood, tuloy pa rin ako.

[@williamtrident6979]

How can I get seq.number on a subform for items in an order. Your video helped with seq for order number, but I want to number each line item. Then it resets to 1 in the next order

[@EdcelleJohnGulfan]

This will be the PART 2. Thanks for asking.

[@saeedbaryal8723]

Hello sir, hope you are fine. How can I make Access databse work only in one computer. Means in a company it should only work in specific PC if it is copied to another computer it shouldnt work.

[@EdcelleJohnGulfan]

Ahhh!!! just like having a license key. I will create a video about that soon.

[@EdcelleJohnGulfan]

By the way sir, thanks for watching!

[@saeedbaryal8723]

@@EdcelleJohnGulfan Yes, I am waiting, please my dear sir make it as soon as possible.

[@numero_trese]

Paano po pag every month po mag reset ng number series?

[@EdcelleJohnGulfan]

Na sa video po or click nyo lang ang link. kzbin.info/www/bejne/jl6rlp98nLxolc0

[@numero_trese]

​​@@EdcelleJohnGulfan thank u po. Paano naman po if 3 digits ung qlast? Like 001. Di po kasi nagana

[@EdcelleJohnGulfan]

Add this to last code. Me.InvoiceNo = "INV-" & format(Date, "yyyy-mm-dd") &"-" & format(me.SeriesNo,"000")

[@พงษ์ศิริสอนลี-ฒ5ถ]

Numbers are not automatic +1