

February 18, 2022

Hi All,
I'm using Microsoft 365 and using Windows. I have form like this. each style have different range size. how to make the report more user friendly when adding new data. because there is a lot of size. it's possible using Macro ? and it's possible to update by multi user in the same time ?
1. its there any easier way using macro to entry new data ?
2. and how to used search feature using macro. user can search 2 or more PO's
below is the example file.
https://www.dropbox.com/scl/fi.....c76dcn409s
Thankyou,
Justin R


November 8, 2013

Hi Justin,
For a search form, you can find multiple versions on our site:
https://www.myonlinetraininghu.....nd-display
https://www.myonlinetraininghu.....-user-form
Adding new data with a form (using a vba code) is not difficult, but in a multiuser environment there are a few challenges: conflicts are common, when more than 1 user is editing the same range, therefore the design of the entire process is complex.
You could store the data in Access, each user should send updates to access - this will solve the concurrent changes problem, but your data structure is not fit for access, the structure is not tabular, there are many changes needed. I suggest you hire a consultant to organize the system, if you're not comfortable with macros.

Answers Post
1 Guest(s)
