Hello All,
As my username suggests, I am a complete novice when it comes to access. I am fairly proficient with excel and have been using an excel workbook as a sort of sign up sheet. It has worked well up until recently. I believe the problem is the number of users. When I first developed it, we had 2 to maybe as many as 6 users at a time. Now we can have up to 15 users at a given time, which is causing problems with corrupted files or files being deleted all together. Someone suggested using access to accomplish the same thing so here I am.
Let me first explain what my spread sheet does. The user opens the file, which is in date format, i.e. 12092014.xlsm. This launches a simple user form that displays the users name and 3 buttons. An exit button, and 2 buttons that assign either one 5 minute block of time or two 5 minute blocks of time. The workbook enters the user name, date, and time the block(s) are assigned. I use a MsgBox to display the time values to the user. Once the user clicks ok, the workbook saves and closes. When the last block of the day is assigned (23:55), the next user that requests a block triggers the spreadsheet to create a new file with the next date, i.e. 12102014, clears out all of the cells, and assigns time 00:00. All of this is accomplished using VBA. I know access uses VBA as well but I'm really not sure where to begin. Is my code even usable or should I start from scratch?
Any and all help would be greatly appreciated. I will upload my exsisting spreadsheet so you can see exactly how it works.
Thank You,