• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

Microsoft Access 2007

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
jegajothy
Asked:
jegajothy
  • 4
  • 3
3 Solutions
 
David Johnson, CD, MVPOwnerCommented:
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
 
jegajothyAuthor Commented:
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
 
jegajothyAuthor Commented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
David Johnson, CD, MVPOwnerCommented:
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
 
jegajothyAuthor Commented:
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
 
David Johnson, CD, MVPOwnerCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
jegajothyAuthor Commented:
thank u
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now