Hello all,
So let me preface this by saying I have no Access experience other than setting up a couple tables and linking relationships in my computer literacy class.
My problem is that my boss wants to create an interactive database that will be used as a request log database. Basically she wants used to be able to open the database, which will open a switchboard and they will click the submit a request button. She wants that to open a form, and fill out the form and submit it.
I have the switchboard and form created with all the appropriate tables. My problems are…
1) How to make certain fields required? For instance if the user selects the “Denied” request button, she wants the “Comments” box to be required.
2) How do I create a report of all the pending requests?
3) Is there a way to link Access with Outlook and have an email sent to the person who the request is assigned to?
4) How can I set up a box to be auto generated with the date that the form is being submitted?
5) How do I make the database go “Live”? In other words, she wants it so when the users click on the icon which will be located on their desk top, the only option they will have is “Submit a Request” or “Exit”. She doesn’t want them to be able to get into all of the information that’s in the database.
I realize these are a lot of questions, but frankly my manager told me that the information is out there on google, I just have to find it. Now let me also say that I have done some research and what it seems is that most of these things require writing code, which might as well be in Chinese because I have absolutely no idea how to do that. Any help or suggestions that can be given are more than appreciated.
Thank you.
Chris.
So let me preface this by saying I have no Access experience other than setting up a couple tables and linking relationships in my computer literacy class.
My problem is that my boss wants to create an interactive database that will be used as a request log database. Basically she wants used to be able to open the database, which will open a switchboard and they will click the submit a request button. She wants that to open a form, and fill out the form and submit it.
I have the switchboard and form created with all the appropriate tables. My problems are…
1) How to make certain fields required? For instance if the user selects the “Denied” request button, she wants the “Comments” box to be required.
2) How do I create a report of all the pending requests?
3) Is there a way to link Access with Outlook and have an email sent to the person who the request is assigned to?
4) How can I set up a box to be auto generated with the date that the form is being submitted?
5) How do I make the database go “Live”? In other words, she wants it so when the users click on the icon which will be located on their desk top, the only option they will have is “Submit a Request” or “Exit”. She doesn’t want them to be able to get into all of the information that’s in the database.
I realize these are a lot of questions, but frankly my manager told me that the information is out there on google, I just have to find it. Now let me also say that I have done some research and what it seems is that most of these things require writing code, which might as well be in Chinese because I have absolutely no idea how to do that. Any help or suggestions that can be given are more than appreciated.
Thank you.
Chris.