Solved

Microsoft Access 2007

Posted on 2012-04-05
8
292 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 81

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
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!

 
LVL 81

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
 

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 81

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

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In threads here at EE, each comment has a unique Identifier (ID). It is easy to get the full path for an ID via the right-click context menu. However, we often want to post a short link within a thread rather than the full link. This article shows a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Shows how to create a shortcut to site-search Experts Exchange using Google in the Chrome browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch the Search Engine Menu: In chrome, via you…

738 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