Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Users in Userform issue
Hi all, I know I'm probably just forgetting something stupid, but here's m issue: I created a small userform to act as a Call Log. It worked fine, but w had some Accumulation issues. So I set it up to have everyone's Userfor to save to the same workbook on the Network drive. Everyone can pull u the userform simultaneously with no issues, but only the first user ca save data to the sheet. I know the issue is probably a "Read-Only" problem, but I can't figur out how to set it up where everyone's userform can write to the shee at the same time (5 users). I had them pulling up the form from a loca script, and tried also directly from the workbook on the network. I'm good with VBA, but by no means great. Any help would b appreciated. - Side Question: How hard would it be to save individual data on eac person's local drive as well as to the main accumulative workbook? -- bigbr ----------------------------------------------------------------------- bigbri's Profile: http://www.excelforum.com/member.php...fo&userid=2221 View this thread: http://www.excelforum.com/showthread.php?threadid=53060 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Users in Userform issue
Hi as far as i'm aware it's like a sharing violation!, if 2 users have the input box open and close it at the same time then both boxes will be attempting to change the same cell, row or column..........excel then wants to know who's changes wins? if they are changing seperate cells or worksheets there shouldnt be too much of a problem! I'm not too good at programming but if your workbook is on a network drive could you write some code to check see if another input box has been called if so then build in a timer before the check is performed again and the all clear message being given...........sounds simple........but i know it would be a nightmare! Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=530601 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Users in Userform issue
I originally thought of that as well. What happens in the form is when the user clicks "submit," it writes all of the data to the next available row, so unless two users click submit at the exact same millisecond, it won't try to write to the same cells, and even if they did, they can just click submit again and it should work. The problem is that all subsequent users can't write to the sheet at all. I originally didn't think there was an issue since everyone could open the form at the same time. -- bigbri ------------------------------------------------------------------------ bigbri's Profile: http://www.excelforum.com/member.php...o&userid=22213 View this thread: http://www.excelforum.com/showthread...hreadid=530601 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Users in Userform issue
I doubt this concept is supportable.
Perhaps put your data in an SQL database. -- Regards, Tom Ogilvy "bigbri" wrote: Hi all, I know I'm probably just forgetting something stupid, but here's my issue: I created a small userform to act as a Call Log. It worked fine, but we had some Accumulation issues. So I set it up to have everyone's Userform to save to the same workbook on the Network drive. Everyone can pull up the userform simultaneously with no issues, but only the first user can save data to the sheet. I know the issue is probably a "Read-Only" problem, but I can't figure out how to set it up where everyone's userform can write to the sheet at the same time (5 users). I had them pulling up the form from a local script, and tried also directly from the workbook on the network. I'm good with VBA, but by no means great. Any help would be appreciated. - Side Question: How hard would it be to save individual data on each person's local drive as well as to the main accumulative workbook?- -- bigbri ------------------------------------------------------------------------ bigbri's Profile: http://www.excelforum.com/member.php...o&userid=22213 View this thread: http://www.excelforum.com/showthread...hreadid=530601 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Users in Userform issue
Just to be complete, you can go into tools=share Workbook and make the
workbook a shared workbook which can be shared/used by multiple users at the same time, but I am not sure you could have a userform in another workbook be the one to share it. It might work, but sounds flaky to me. -- Regards, Tom Ogilvy "bigbri" wrote: Hi all, I know I'm probably just forgetting something stupid, but here's my issue: I created a small userform to act as a Call Log. It worked fine, but we had some Accumulation issues. So I set it up to have everyone's Userform to save to the same workbook on the Network drive. Everyone can pull up the userform simultaneously with no issues, but only the first user can save data to the sheet. I know the issue is probably a "Read-Only" problem, but I can't figure out how to set it up where everyone's userform can write to the sheet at the same time (5 users). I had them pulling up the form from a local script, and tried also directly from the workbook on the network. I'm good with VBA, but by no means great. Any help would be appreciated. - Side Question: How hard would it be to save individual data on each person's local drive as well as to the main accumulative workbook?- -- bigbri ------------------------------------------------------------------------ bigbri's Profile: http://www.excelforum.com/member.php...o&userid=22213 View this thread: http://www.excelforum.com/showthread...hreadid=530601 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sharing excel sheet with multiple users, but other users cant see | Excel Discussion (Misc queries) | |||
UserForm Save Issue | Excel Worksheet Functions | |||
Userform Issue | Excel Programming | |||
muliple users - issue unique session number | Excel Programming | |||
Multiple users using a single userform | Excel Programming |