Multiple Access in Excel ???

U

unplugs

After I finished create the user form and all the function used t
calculate the working hours, I get stuck on this issue.. Is it th
spreadsheet with userform are multi-accessed by users?

Can I know who can answer my question?

Case 1:
Employee A and Employee B open the spreadsheet, filling up th
userform. The entries in userform will straight away pass t
spreadsheet behind the userform. If Employee A saved the fil
first...and Employee B still making the entries, is it when Employe
save the file later will overwrite the previous file that Employee
had saved?

Case 2:
Employee A access the file first, make some entries inside.... The
employee B comes in and make some entries(In the spreadsheet alread
have some entries that A made).... After that employee B saved the fil
before employee A do so. The entries that the employee A made withi
the period of B comes in and leave will lost or not ?

Can Excel handle multiple access? The shared workbook works... but I
juz allow 1 user make entries each time.

So, is it any possible solution for this... if juz using Excel? I'
getting headache man..
 
N

NooK

Why not create a new WorkBook for the user input, this way they will be
both saving in different workbooks and no data will be overwritten.

Another thing I think you can do is to create a temporary workbook for
the user data and when the user save it, check if there is some data
there already and if so save it in a new worksheet otherwise just save
in the activeworksheet behind the user form.

Just some ideas, I am new to VBA so I belive I can't help much more
than that.

Best Regards

NooK
 
U

unplugs

Thanks for reply...

The database that u mean is spreadsheet? Create another workbook ju
for store the data or act as a main database? How I'm goin to do ta
using macro?

How about Access? Is it can link to Access? Use Access to store thos
data? If can... How to do so
 
U

unplugs

THanks for ur time replying my msg... ~ x...

Perhaps u can attach a file here? So that I can used it as
reference..? Is it ok? It seems too much....izzit? :
 
U

unplugs

WOw! Anson~ Thanks a lot...

I will try to figure out this... Anyway, it helps me a lot...
Thank you
:
 
Top