Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Trying to figure out how to setup access tables as a setup checklist for devices.

Posted on 2012-09-10
9
Medium Priority
?
237 Views
Last Modified: 2012-09-24
For the life of me I can't seem to figure out how to set up these tables.  Basically I have 3 tables.

1) tblDevice: DeviceID(primary key), DeviceName
2) tblChecklist: SeqNum(Primary key), Task
3) tbldeviceChecklists: DeviceID, SeqNum

I want to be able to pull up a list of all my devices and have it tell me which tasks have been completed and which still need to be done. The main problem I'm having is that if I want to add or remove tasks i don't know how to push that to the tblChecklist so that those tasks show up on all the devices.

Any ideas or anyone know of a template hanging around somewhere?

Thanks for any advice and help on this one!
0
Comment
Question by:SeyerIT
  • 4
  • 4
9 Comments
 
LVL 2

Author Comment

by:SeyerIT
ID: 38386300
I'll get into that this morning and get back to ya!

Thanks!
0
 
LVL 3

Expert Comment

by:Oliver Wastell
ID: 38386404
Will all the tasks in tblChecklist always apply to all devices?  If this is the case then the solution would involve listing all tasks in tblChecklist for any selected device.  When a task is completed for the selected device, a checkbox for the task is ticked which then creates a link record in tblDeviceChecklists (a rename might be appropriate to tblDeviceTaskComplete).  

The tricky bit is getting the checkbox to appear against the list of tasks, and to have these checkboxes checked if there is a link record in tblDeviceChecklists (or the renamed version).  I'm happy to help with the VB code if I have interpretted your requirement correctly.

Oliver
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 2

Author Comment

by:SeyerIT
ID: 38414073
Oliver, you nailed it.. That's exactly what I'm trying to do.. Just couldn't get the queries setup to handle it and get it working.. I'm extremely sorry for just getting back to this question. I don't normally get pulled away for that period of time but another hot project came up that needed to be tended to 100%.. In any case If you could help me through this a bit that would be greatly appreciated!
0
 
LVL 3

Expert Comment

by:Oliver Wastell
ID: 38415440
Hi Seyer, no problem.  I'll happily help you with it.  I'm taking a look now.
0
 
LVL 3

Accepted Solution

by:
Oliver Wastell earned 2000 total points
ID: 38415801
Hi, try the attached database.  Just double click a task for the device (or use the button under the listbox) to complete it.  If you complete a task by mistake, you can un-complete using the other button under the listbox.  If you need clarification on anything I have done and why, please don't hesitate to ask.

Form ScreenshotData StructureDeviceTaskManagement.accdb
0
 
LVL 2

Author Comment

by:SeyerIT
ID: 38428261
Sorry I'm really being bad about this question.. Looking at this right now and I'll get back within the hour! Thanks for your patience!
0
 
LVL 2

Author Comment

by:SeyerIT
ID: 38428312
This will get the job done! Thanks a bunch!
0
 
LVL 3

Expert Comment

by:Oliver Wastell
ID: 38428338
Pleasure ;-)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question