InfernoJaffa
Registered User.
- Local time
- Today, 08:51
- Joined
- Feb 11, 2015
- Messages
- 26
Hi Guys,
I have created a shared workbook in Excel and it isn't working very well with constant lock outs and losing data.
I would like to create an access database to replicate what the workbook does but I am having trouble on how to start.
Basically, the workbook tracks and records cycle counts for equipment under test. I have 50 rigs which have 8 bays each, each bay can test 1 unit. The excel sheet displays 1 sheet with 8 rows per "rig" (so 50 rig sheets in total), I can change the values in these rows to suit.
When the equipment under test has completed I can mark a column "yes" click archive and the row will be copied to another archive sheet and then everything apart from the first column is deleted leaving an empty bay for me to use in the future.
I am having trouble replicating this as I am unsure on how to tackle it.
I have set up a datasheet form which displays the 8 units on test.
The problem I am facing is that when I "archive" (I am using check-box on record and re-query to remove the record) it removes the whole row so I cannot use it for another test in the future.
I have attached an example excel sheet to show how the current shared workbook functions.
Any help would be greatly appreciated.
Thanks
I have created a shared workbook in Excel and it isn't working very well with constant lock outs and losing data.
I would like to create an access database to replicate what the workbook does but I am having trouble on how to start.
Basically, the workbook tracks and records cycle counts for equipment under test. I have 50 rigs which have 8 bays each, each bay can test 1 unit. The excel sheet displays 1 sheet with 8 rows per "rig" (so 50 rig sheets in total), I can change the values in these rows to suit.
When the equipment under test has completed I can mark a column "yes" click archive and the row will be copied to another archive sheet and then everything apart from the first column is deleted leaving an empty bay for me to use in the future.
I am having trouble replicating this as I am unsure on how to tackle it.
I have set up a datasheet form which displays the 8 units on test.
The problem I am facing is that when I "archive" (I am using check-box on record and re-query to remove the record) it removes the whole row so I cannot use it for another test in the future.
I have attached an example excel sheet to show how the current shared workbook functions.
Any help would be greatly appreciated.
Thanks
Attachments
Last edited: