Would you use a macro or VBA code with MS-Access? -

i new access 2013. have warehouse management project create access - many users @ same time different locations.

i have couple of basic questions, if don't mind. better code using macros or vba preferred choice? or combination better approach? if so, sort of functions code in each modality?

the next question has data entry. going using bar-code scanners in few locations.

i terminal or wireless receiver in ready mode time next scan, of course happens @ random times throughout day.

i assume create loop stopped @ point called input text box. how keep program 'active' letting operators scan without them having refresh anything. hope questions aren't vague or elementary.

some additions paulo wrote:

i don't know how many "many users" are, if it's more few, should think using sql server express (the free version) backend instead of access file. more robust. , if "different locations" means wan connections involved, can away lower bandwidth requirements access backend.

don't think macros, use vba. 1 of many reasons can find lots of vba (here , elsewhere), not macros.

afaik, bar-code scanners behave keyboard - send text/numbers scan if entered hand. if textbox has focus receive input, can react afterupdate or onchange event of textbox, no need endless loop.