Multiple Access in Excel ???

[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..

 

[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

 

[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

 

[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? :

 

[Anson]

Try this for

Attachment filename: form.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=59180

 

[Anson]

... and this database. I kept this very simple since I am not gettin
paid for this

Attachment filename: database.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=59181

 

[unplugs]

WOw! Anson~ Thanks a lot...

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