|
|
|
developing microsoft access database template Creating a visitor log based on a specific date out of date ranges
|
|
|
My office would like to keep track of visitor access into our building and many of the visitors we have tend to visit over a period of days and sometimes are recurring on a monthly or yearly basis. I have been asked to help the office transition from a shared excel file to access data_base_. On my main table with visitor information I have [Arrival Date] and [Departure Date] headings to keep track of the visitor's stay. For example, John Smith arrived on June 16 and will leave at the end of the week on June 20. However, when I create the report for the guard at the main desk, John Smith only shows up on June 16th's Visitor Access Report - and he needs to show up on June 17, 18, 19 and 20th's Access Reports in order to enter the building. Do I need to create a separate table for multiple dates and how do I encorporate that into my main table, the forms I created for employees in the building to submit their visitor's access request, and the reports for my office and the guard at the main desk? To throw in another wrench in to the multiple-days of entry situation, we have several visitors who perform maintenance and need access every other Monday. They all so need to show up on the access lists for those Mondays and I would hate to enter or update their visitor's arrival and departure dates in the table every other week. Please let me know what additional information you need. Since I am not as familiar with Access as I would like to be, I'd appreciate any help or suggestions in trying to resolve this conundrum.
|
|
|
|
|
|
|
The administrator has disabled public write access. |
|
|
|
developing microsoft access database template Creating a visitor log based on a specific date out of date ranges
|
|
A log is similar to a diary in that it records what has already happened. You seem to be seeking a program generated daily list of authorized visitors. That's a whole different kettle of fish! If you are able to develop applications with Access then you might try starting with one of the many templates that Microsoft offers and modify it to suit. The unpaid volunteers who respond to issues in these Access newsgroups do so in the spirit of peer support. That usually comes down to a single technical issue per thread although it might also concern a concept or a strategy. If you are seeking a complete solution to the issues you have started to list then you should be seeking it via paid assistance. If you intend to pursue the design yourself then I recommend lurking: microsoft.public.access.tablesdesign and microsoft.public.access.gettingstarted a terrific site to visit for Access lore is www.mvps.org/access HTH |
|
|
|
|
|
|
The administrator has disabled public write access. |
|
|
|
developing microsoft access database template Creating a visitor log based on a specific date out of date ranges
|
|
|
many of the visitors we have tend to visit over a period of days and sometimes are recurring on a monthly or yearly basis. I have been asked to help the office transition from a shared excel file to access data_base_. On my main table with visitor information I have [Arrival Date] and [Departure Date] headings to keep track of the visitor's stay. For example, John Smith arrived on June 16 and will leave at the end of the week on June 20. However, when I create the report for the guard at the main desk, John Smith only shows up on June 16th's Visitor Access Report - and he needs to show up on June 17, 18, 19 and 20th's Access Reports in order to enter the building. Do I need to create a separate table for multiple dates and how do I encorporate that into my main table, the forms I created for employees in the building to submit their visitor's access request, and the reports for my office and the guard at the main desk? To throw in another wrench in to the multiple-days of entry situation, we have several visitors who perform maintenance and need access every other Monday. They all so need to show up on the access lists for those Mondays and I would hate to enter or update their visitor's arrival and departure dates in the table every other week. Please let me know what additional information you need. Since I am not as familiar with Access as I would like to be, I'd appreciate any help or suggestions in trying to resolve this conundrum.
|
|
|
|
|
|
|
The administrator has disabled public write access. |
|
|
|
developing microsoft access database template Creating a visitor log based on a specific date out of date ranges
|
|
|
I assume your main table has a list of visitors with their start and finish dates? You need a table called visitors which I call tbl_visitors. Your input form has the visitor's name with their arrival date and departure date, make this an unbound form. When the entry is saved you will need, using code, add a record for each day of the visit to tbl_visitors. For this you will need the date, determine the day of the week if it is Saturday or Sunday do not add record. For multiple entries you will need check boxes for each day of the week, then use similar coding to check that the day of the date is the same as the checked box so that the record can be added. I have done something similar but not for ypur visitors scenario. Allan AgentCopyKat <
This e-mail address is being protected from spam bots, you need JavaScript enabled to view it
wrote in message My office would like to keep track of visitor access into our building and many of the visitors we have tend to visit over a period of days and sometimes are recurring on a monthly or yearly basis. I have been asked to help the office transition from a shared excel file to access data_base_. On my main table with visitor information I have [Arrival Date] and [Departure Date] headings to keep track of the visitor's stay. For example, John Smith arrived on June 16 and will leave at the end of the week on June 20. However, when I create the report for the guard at the main desk, John Smith only shows up on June 16th's Visitor Access Report - and he needs to show up on June 17, 18, 19 and 20th's Access Reports in order to enter the building. Do I need to create a separate table for multiple dates and how do I encorporate that into my main table, the forms I created for employees in the building to submit their visitor's access request, and the reports for my office and the guard at the main desk? To throw in another wrench in to the multiple-days of entry situation, we have several visitors who perform maintenance and need access every other Monday. They all so need to show up on the access lists for those Mondays and I would hate to enter or update their visitor's arrival and departure dates in the table every other week. Please let me know what additional information you need. Since I am not as familiar with Access as I would like to be, I'd appreciate any help or suggestions in trying to resolve this conundrum.
|
|
|
|
|
|
|
The administrator has disabled public write access. |
|
|
|
developing microsoft access database template Creating a visitor log based on a specific date out of date ranges
|
|
|
I assume your main table has a list of visitors with their start and finish dates? You need a table called visitors which I call tbl_visitors. Your input form has the visitor's name with their arrival date and departure date, make this an unbound form. When the entry is saved you will need, using code, add a record for each day of the visit to tbl_visitors. For this you will need the date, determine the day of the week if it is Saturday or Sunday do not add record. For multiple entries you will need check boxes for each day of the week, then use similar coding to check that the day of the date is the same as the checked box so that the record can be added. I have done something similar but not for ypur visitors scenario. Allan AgentCopyKat <
This e-mail address is being protected from spam bots, you need JavaScript enabled to view it
wrote in message My office would like to keep track of visitor access into our building and many of the visitors we have tend to visit over a period of days and sometimes are recurring on a monthly or yearly basis. I have been asked to help the office transition from a shared excel file to access data_base_. On my main table with visitor information I have [Arrival Date] and [Departure Date] headings to keep track of the visitor's stay. For example, John Smith arrived on June 16 and will leave at the end of the week on June 20. However, when I create the report for the guard at the main desk, John Smith only shows up on June 16th's Visitor Access Report - and he needs to show up on June 17, 18, 19 and 20th's Access Reports in order to enter the building. Do I need to create a separate table for multiple dates and how do I encorporate that into my main table, the forms I created for employees in the building to submit their visitor's access request, and the reports for my office and the guard at the main desk? To throw in another wrench in to the multiple-days of entry situation, we have several visitors who perform maintenance and need access every other Monday. They all so need to show up on the access lists for those Mondays and I would hate to enter or update their visitor's arrival and departure dates in the table every other week. Please let me know what additional information you need. Since I am not as familiar with Access as I would like to be, I'd appreciate any help or suggestions in trying to resolve this conundrum.
|
|
|
|
|
|
|
The administrator has disabled public write access. |
|
|
|
developing microsoft access database template Creating a visitor log based on a specific date out of date ranges
|
|
|
suggestions in trying to resolve this conundrum.
|
|
|
|
|
|
|
The administrator has disabled public write access. |
|
Favoured: 0
