Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Access in Excel ???
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.. -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Access in Excel ???
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 --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Access in Excel ???
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 -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Access in Excel ???
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? : -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Access in Excel ???
Try this for
Attachment filename: form.xls Download attachment: http://www.excelforum.com/attachment.php?postid=59180 -- Message posted from http://www.ExcelForum.com |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Access in Excel ???
... 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 -- Message posted from http://www.ExcelForum.com |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Access in Excel ???
WOw! Anson~ Thanks a lot...
I will try to figure out this... Anyway, it helps me a lot... Thank you : -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically import multiple named-ranges from Excel to Access | Excel Discussion (Misc queries) | |||
Macro to access multiple Excel files | Excel Discussion (Misc queries) | |||
How to import multiple sheet of excel into Access database to a diffrent tables?? | Excel Discussion (Misc queries) | |||
EXCEL, VSTO: Fastest way to access multiple cells | Excel Discussion (Misc queries) | |||
multiple user DB access via Excel (troubleshooting?) | Excel Programming |