Solved

Microsoft Access 2007

Posted on 2012-04-05
8
289 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 79

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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 79

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 79

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
A Function to parse a text string 4 34
unable to create table-based data macro in MS ACCESS 2013 11 22
Run SQL Server Proc from Access 11 27
aggregate query? 3 27
Introduction If you're like most people, you have occasionally made a typographical error when you're entering information into an online form.  And to your consternation, the browser remembers the error, and offers to autocomplete your future entr…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Google currently has a new report that is in beta and coming soon to Webmaster Tool accounts. This Micro Tutorial will highlight new features for Google Webmaster Tools.

816 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

9 Experts available now in Live!

Get 1:1 Help Now