Solved

Microsoft Access 2007

Posted on 2012-04-05
8
287 Views
Last Modified: 2012-04-10
My OS is win 7 prof 64 bit and I use Office 2007.  I ask tons of questions in this EE forum and would like to download my question and also the replies to a database so that I could have them for easy access on my desktop.   Some Q have a file attached, or a code snippet, which I would like to save too.  Has anyone done something on this line in Access that could share the design?  Thank u.
0
Comment
Question by:jegajothy
  • 4
  • 3
8 Comments
 
LVL 78

Accepted Solution

by:
David Johnson, CD, MVP earned 334 total points
ID: 37815782
Manually it is a snap, automating it might be a bit harder. This site does allow you to 'save' the question to your knowledge-base? Have you tried that?
0
 

Author Comment

by:jegajothy
ID: 37815815
Saving to knowledge base?  I think I did that always, but how do I see what is in there. thank u.
Also how does one do it manually.  Hope u can show me the steps by step process.  thank u.
0
 

Author Comment

by:jegajothy
ID: 37815821
My response, sorry about that.  I see the 'My Knowledge Base' selection.  But I would like to file it to my desktop, and then see which is easier to retrieve.  Thank u.
0
 
LVL 78

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 334 total points
ID: 37816360
please note I am not a dba by any stretch of the imagination:

create your database
question table:
uniqueid, Question string
answered: boolean
attachments: boolean

answers: table
link to answers based on question id string
accepted solution boolean

attachments table
link to question id string

question one to many answers, attachments relation
answers: many to one question relation
attachments: many to one relation

Even better use the issues database template as supplied by Office.com

now its just a copy and paste


http://office.microsoft.com/en-us/access-help/video-use-the-issues-web-database-template-VA101794585.aspx
Issues-web-database.accdb
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

Author Comment

by:jegajothy
ID: 37817986
In response to ve3ofa, thank u.  But it is a bit too heavy for me.  Since my Access is 2007 I downloaded the Issues table, and probably have to modify the table to its bare min for a single user.
How can one extract the details from the Knowledge Base relating to myself.  Is there any feature here on EE that allows to download first and then import to a db.  Or would I be able to download my Knowledge Base, if Yes, what are the steps.  Thank u.
0
 
LVL 78

Expert Comment

by:David Johnson, CD, MVP
ID: 37818043
I have no idea.. I'm guessing probably not. perhaps there is some way of automating it via a web scraper but I leave vba to the vba guy's pretty much.
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 166 total points
ID: 37824153
Here is what I do:

Create a folder on your desktop called "EEQuestions'

Then simply drag and drop the question address (via the "Icon" in your webbrowser's address bar) into this folder.

In other words you can't really "Download" the question/thread, but you can create an internet shortcut to it..
;-)

Jeffcoachman
0
 

Author Closing Comment

by:jegajothy
ID: 37827796
thank u
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
This Micro Tutorial will demonstrate how to add subdomains to your content reports. This can be very importing in having a site with multiple subdomains.

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now