943,918 Members | Top Members by Rank

Ad:
Apr 13th, 2008
0

How to store a picture or some Equation in a Datafield in access?

Expand Post »
Hi!

I am trying to use MS access to develope a database which can store "Multiple choice questions and options " as input. And out put shold be taken randomly from the database and it should prepare a word file.

But I am a physics lecturer. I have a less knowledge over the data fields of Acess. Which data field will allow me to store Equations and Small BMP pictures as input?

Please help me at <snipped>
Last edited by peter_budo; Apr 17th, 2008 at 11:37 am. Reason: keep It On The Site - Do not post asking for an answer to be sent to you via email or PM.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
mrhard2004 is offline Offline
7 posts
since Apr 2008
Apr 16th, 2008
0

Re: How to store a picture or some Equation in a Datafield in access?

Store pictures in an OLE type field.

Do you want to display the formula, or execute it?
Reputation Points: 730
Solved Threads: 181
Nearly a Senior Poster
MidiMagic is offline Offline
3,314 posts
since Jan 2007
Apr 16th, 2008
0

Re: How to store a picture or some Equation in a Datafield in access?

Hi - I usually don't store images in the database. I find the most effective solution is to store location references in Access, then use ShellExecute in my VB project to boot a slected file (using its Windows file association), or if using my own picture box, or IE, then boot that and load the specific file based on the image location.

I have developed sftware that builds quizzes using random questions from a store of questions. If you want more information about this, just contact me.

Regards
Reputation Points: 10
Solved Threads: 1
Newbie Poster
ROBBOHORT is offline Offline
4 posts
since Apr 2008
Apr 18th, 2008
0

Re: How to store a picture or some Equation in a Datafield in access?

Yes Robohort...
I am trying to develope the software to develope quiz only. It should contain a question in which some times questions along which equations should come inline with the text.
And equation OR picture is just to be displayed. It need not to be solved.


Regards
Last edited by mrhard2004; Apr 18th, 2008 at 9:28 pm. Reason: missing a word
Reputation Points: 10
Solved Threads: 0
Newbie Poster
mrhard2004 is offline Offline
7 posts
since Apr 2008
Apr 18th, 2008
0

Re: How to store a picture or some Equation in a Datafield in access?

Click to Expand / Collapse  Quote originally posted by MidiMagic ...
Store pictures in an OLE type field.

Do you want to display the formula, or execute it?
Thanks for the replay.
I want it to be displayed only. It is not necessary to solve it.

Regards
Reputation Points: 10
Solved Threads: 0
Newbie Poster
mrhard2004 is offline Offline
7 posts
since Apr 2008
Apr 22nd, 2008
0

Re: How to store a picture or some Equation in a Datafield in access?

Use the OLE type to display an image. You can put a one pixel image in for a nonimage question if the process needs an image. Create an image of the equation using Word and Ctrl-PrintScreen. Paste the clipboard into MS paint (in the Accessories folder in Programs).

If you have Access, you have Word. But you might have to install the equation extension, if it wasn't installed when you installed Word. It's on your Office disks.
Last edited by MidiMagic; Apr 22nd, 2008 at 3:25 am.
Reputation Points: 730
Solved Threads: 181
Nearly a Senior Poster
MidiMagic is offline Offline
3,314 posts
since Jan 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS Access and FileMaker Pro Forum Timeline: EPOS
Next Thread in MS Access and FileMaker Pro Forum Timeline: Hello





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC