Hello everybody,
I have been doing vba for a a short amount of time. Just some background info. Skip to the *** if u get bored. I first started in word doing small cuts and pastes to manipulate a template used for sending faxes. I have just begun to use winapi to manipulate other window and mouse clicks and sendinputs. That progressed to using rightfax to send out our own requests.
I then started using excel to track the orders moved for each individual in our department. We would have to do this every hour. It works pretty well but now some lagging issues are beginning to appear. There are more and more users being added. I have searched and seat cheddar and have coke to the conclusion that excel is not for multiple users. Right now the users are grouped in 7 workbook. The 7 is linked to a master. Each user has there own production sheet correlated to one of the 7. The issues stem from too many users trying to save... Which goes and inputs there info onto their specific workbook, using vba, which is then sent to the master once opened via link. Works fine except when multiple users are sending there info. Though i have trapped the issue, by simply asking them to save in a few min, it pretty much, in my opinion inadequate. So now i am going into access which is a different world. Simpl i have already created a table by importing the log in information from excel. They too had to log in so the userform would knoww what row. I assume i can continue that with a password. In visual basic i am pretty sure i can do that. I have been looking thru some code but i guess the reference and properties are slightly different. t's
****
To userforms - login and production
To sheets-(tables) login info and master list.
Is this the best way could 60 + people mess around and send info every hour to the cell that corresponds to their name. Or should each user have their own table that the master goes and gets. Which, if either, is more stable. And could someone show code as to link 1 user to say 6 am to 4pm.

Sorry the version i am using is 2007.

It's not 100% clear to me what we're after, but let me see if I can address at least one of your questions.

You have "already created a table by importing the log in information from excel". That's very seldom an adequate way to build a relational database. VERY seldom.

So, the next step is to try to sort out which tableS you need.

Tell us, in a few simple sentences, what the goal here is. You want to store some data related to faxes? What is that data?

Also more clarity on the following would be helpful:

"To userforms - login and production" Is there a question here?

"To sheets-(tables) login info and master list. " Is there a question here?

"Is this the best way could 60 + people mess around and send info every hour to the cell that corresponds to their name. Or should each user have their own table that the master goes and gets. Which, if either, is more stable. And could someone show code as to link 1 user to say 6 am to 4pm. "

I think the term "mess around" is a bit too vague to be of value. What are people doing in their JOBS?

"Cell" is an Excel term and probably has no use here. Again, what does a person send?

What does " 6 am to 4pm" have to do with anything here?

"should each user have their own table "? Finally a question we can answer straight up. NO. That would be dragging along all of the baggage of the Excel sheets. Not suitable for a relational database.

Again, focus on
a) the data you need to save.
b) How that data needs to be saved.

From there, we ought to be able to pursue a better answer or two.

I appreciate the response. Sorry it was a little vague just wanted to give give some info bout myself. I apologize for for the confusion. I have two sheets. The first is the log in info. One column has the users first and last name and the second column is their employee id. The employee is moving orders. We have to keep a running number per hour on how much an employee moves. Then total everyone. The other sheet is the 'master' sheet that has their user id. The times are from 6am to 4pm. Basically at 7 i want all the users to send their number to the master sheet giving us the 6am total.

The data that needs to be saved is the number of orders moved per hour and the total.

The saved information needs to go to the master so we can see the department and individual numbers. This is done daily.

Thanks again