473,587 Members | 2,320 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Best way to let users input picture/drawing to each record?

I'm fairly new to access (using 2002) and am setting up a DB for work.
along with each record the user also needs to make a flow diagram
(previously, these reports were composed in word and they used the
autoshapes to create this diagram). I was wondering what the best way
to incorporate this into the DB. I have read about how saving them as
pictures in the DB bloats the size, which is unacceptable, but it
needs to be easy to do (not making separate word file and have them
type in the path...) Is there an easy way to allow users to create
flow diagrams and link (or embed a small file) to the record?
Thanks in advance!

(I dont know much vb, but im willing to try it if i need to)
Nov 13 '05 #1
20 2382
ch******@umbc.e du (Greg) wrote in message news:<f2******* *************** ****@posting.go ogle.com>...
I'm fairly new to access (using 2002) and am setting up a DB for work.
along with each record the user also needs to make a flow diagram
(previously, these reports were composed in word and they used the
autoshapes to create this diagram). I was wondering what the best way
to incorporate this into the DB. I have read about how saving them as
pictures in the DB bloats the size, which is unacceptable, but it
needs to be easy to do (not making separate word file and have them
type in the path...) Is there an easy way to allow users to create
flow diagrams and link (or embed a small file) to the record?
Thanks in advance!

(I dont know much vb, but im willing to try it if i need to)


What if you were to use the OpenFile API to prompt the user to find
the file and then just write the path into your table? Then you could
just show it as a hyperlink in your form...

http://www.mvps.org/access/api/api0001.htm
Nov 13 '05 #2
"Greg" wrote
along with each record the user also
needs to make a flow diagram
(previously, these reports were composed
in word and they used the
autoshapes to create this diagram).
There's no built-in way to use to create flow diagrams in Access. But,
Access can start another application that you use to create the flow
diagrams and store the image. I'd suggest the appropriate version of Visio
or, perhaps, a more general imaging software tool that "plays well" with
Access.
I was wondering what the best way
to incorporate this into the DB.


The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

In these samples, the Windows Common Dialog is displayed for the user to
_select_ an image file, so the user does not have to type in the path and
filename.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zi p is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #3
Thank you both for your help!
a few more questions have come up. I have decided the bloat is
unacceptable, so the OLE picture embeding is not an option anymore.
however, the BLOB might work. I tried copying the code (and form) for
importing an image as a BLOB, but i am getting errors every time it
runs: "compile error, sub or function not defined" and highlights the
word "ahtAddFilterIt em" in the code. i looked around in the sample db
code but couldn't seem to see what i was missing. Might it be
something like an #include in c++?
i have changed a little bit in how the image is stored, just using the
OLE for the data and text field for extension (actually copied the
fields from the sample), since there will only be 1 per record.
Very new to VB still, so any help in that area is greatly appreciated!

Thanks again!
-Greg
"Larry Linson" <bo*****@localh ost.not> wrote in message news:<3q******* ************@nw rddc03.gnilink. net>...
"Greg" wrote
> along with each record the user also
> needs to make a flow diagram
> (previously, these reports were composed
> in word and they used the
> autoshapes to create this diagram).


There's no built-in way to use to create flow diagrams in Access. But,
Access can start another application that you use to create the flow
diagrams and store the image. I'd suggest the appropriate version of Visio
or, perhaps, a more general imaging software tool that "plays well" with
Access.
> I was wondering what the best way
> to incorporate this into the DB.


The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

In these samples, the Windows Common Dialog is displayed for the user to
_select_ an image file, so the user does not have to type in the path and
filename.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zi p is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP

Nov 13 '05 #4
Thank you both for your help!
a few more questions have come up. I have decided the bloat is
unacceptable, so the OLE picture embeding is not an option anymore.
however, the BLOB might work. I tried copying the code (and form) for
importing an image as a BLOB, but i am getting errors every time it
runs: "compile error, sub or function not defined" and highlights the
word "ahtAddFilterIt em" in the code. i looked around in the sample db
code but couldn't seem to see what i was missing. Might it be
something like an #include in c++?
i have changed a little bit in how the image is stored, just using the
OLE for the data and text field for extension (actually copied the
fields from the sample), since there will only be 1 per record.

Thanks again!
-Greg
"Larry Linson" <bo*****@localh ost.not> wrote in message news:<3q******* ************@nw rddc03.gnilink. net>...
"Greg" wrote
> along with each record the user also
> needs to make a flow diagram
> (previously, these reports were composed
> in word and they used the
> autoshapes to create this diagram).


There's no built-in way to use to create flow diagrams in Access. But,
Access can start another application that you use to create the flow
diagrams and store the image. I'd suggest the appropriate version of Visio
or, perhaps, a more general imaging software tool that "plays well" with
Access.
> I was wondering what the best way
> to incorporate this into the DB.


The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

In these samples, the Windows Common Dialog is displayed for the user to
_select_ an image file, so the user does not have to type in the path and
filename.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zi p is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP

Nov 13 '05 #5
Thank you both for your help!
a few more questions have come up. I have decided the bloat is
unacceptable, so the OLE picture embeding is not an option anymore.
however, the BLOB might work. I tried copying the code (and form) for
importing an image as a BLOB, but i am getting errors every time it
runs: "compile error, sub or function not defined" and highlights the
word "ahtAddFilterIt em" in the code. i looked around in the sample db
code but couldn't seem to see what i was missing. Might it be
something like an #include in c++?
i have changed a little bit in how the image is stored, just using the
OLE for the data and text field for extension (actually copied the
fields from the sample), since there will only be 1 per record.
Very new to VB still, so any help in that area is greatly appreciated!

Thanks again!
-Greg
"Larry Linson" <bo*****@localh ost.not> wrote in message news:<3q******* ************@nw rddc03.gnilink. net>...
"Greg" wrote
> along with each record the user also
> needs to make a flow diagram
> (previously, these reports were composed
> in word and they used the
> autoshapes to create this diagram).


There's no built-in way to use to create flow diagrams in Access. But,
Access can start another application that you use to create the flow
diagrams and store the image. I'd suggest the appropriate version of Visio
or, perhaps, a more general imaging software tool that "plays well" with
Access.
> I was wondering what the best way
> to incorporate this into the DB.


The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

In these samples, the Windows Common Dialog is displayed for the user to
_select_ an image file, so the user does not have to type in the path and
filename.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zi p is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP

Nov 13 '05 #6
sorry for multiple posts, google said it didnt go through the first time :-/
Nov 13 '05 #7
ch******@umbc.e du (Greg) wrote in message news:<f2******* *************** ****@posting.go ogle.com>...
Thank you both for your help!
a few more questions have come up. I have decided the bloat is
unacceptable, so the OLE picture embeding is not an option anymore.
however, the BLOB might work. I tried copying the code (and form) for
importing an image as a BLOB, but i am getting errors every time it
runs: "compile error, sub or function not defined" and highlights the
word "ahtAddFilterIt em" in the code. i looked around in the sample db
code but couldn't seem to see what i was missing. Might it be
something like an #include in c++?
i have changed a little bit in how the image is stored, just using the
OLE for the data and text field for extension (actually copied the
fields from the sample), since there will only be 1 per record.
Very new to VB still, so any help in that area is greatly appreciated!

Thanks again!
-Greg

Greg,
I hate to sound repetitive, but I still think prompting the user for a
path to the file is your best bet. You can use the FileOpen API call
and then just grab the full path to the file and save it in the
database. So what the user will see is this:
1. user clicks on button or enters blank text field.
2. OpenFile dialog opens up, prompting the user to browse for a file.
3. user finds file, clicks OK.
4. FileOpen API passes path back to database and writes the browsed
path into the table.

Seems intuitive to me... you could even put a title on your OpenFile
dialog that gave the user instructions...

HTH,
Pieter
Nov 13 '05 #8
> but i am getting errors every time it
runs: "compile error, sub or function
not defined" and highlights the
word "ahtAddFilterIt em" in the code.
No, it is not like an Include, it is part of the code to use the Windows
Common Dialog directly, that came from http://www.mvps.org/api/api0001.htm.
However, it is in the example somewhere, or the example would exhibit the
same compilation error. My guess is that you did not copy the code module
for using the Windows API to choose a file into your database.
i looked around in the sample db
code but couldn't seem to see what
i was missing.


When "looking around", in the module window (aka the Visual Basic
Environment, VBE), use Edit | Find and set to the broadest search, e.g.,
"Current Project".

Larry Linson
Microsoft Access MVP
Nov 13 '05 #9
Ok, i see what you're saying about linking to the file would be best.
unfortunately, we don't have any good flow diagram software here,
except a single license of visio i think...so they probably will just
use autoshapes in word

What I'm trying to do is make this easiest for the user. these arent
premade diagrams, they will most likely be creating them at the same
time they are inputting the rest of the data.

I guess what I'm trying to ask is there a (close to) foolproof way of
letting them open word (or whatever software), create the diagram, and
then save it somewhere so the db could be linked? I am afraid if i
just let them make it, save it, then "browse" for it, the images will
end up being on everyones individual hd rather then a folder on the
server. (and several other issues with people forgetting where they
saved it, saving wrong doc type, etc...) I have seen that you can use
a button to load an app, like word, but as for saving in the right
place and right file type, i dont know how to enforce that.

(if its unclear, this is a db used by a group of users, each from
his/her own workstation...)

Thanks again!
-greg

pi********@hotm ail.com (Pieter Linden) wrote in message news:<bf******* *************** ****@posting.go ogle.com>...
ch******@umbc.e du (Greg) wrote in message news:<f2******* *************** ****@posting.go ogle.com>...
Thank you both for your help!
a few more questions have come up. I have decided the bloat is
unacceptable, so the OLE picture embeding is not an option anymore.
however, the BLOB might work. I tried copying the code (and form) for
importing an image as a BLOB, but i am getting errors every time it
runs: "compile error, sub or function not defined" and highlights the
word "ahtAddFilterIt em" in the code. i looked around in the sample db
code but couldn't seem to see what i was missing. Might it be
something like an #include in c++?
i have changed a little bit in how the image is stored, just using the
OLE for the data and text field for extension (actually copied the
fields from the sample), since there will only be 1 per record.
Very new to VB still, so any help in that area is greatly appreciated!

Thanks again!
-Greg

Greg,
I hate to sound repetitive, but I still think prompting the user for a
path to the file is your best bet. You can use the FileOpen API call
and then just grab the full path to the file and save it in the
database. So what the user will see is this:
1. user clicks on button or enters blank text field.
2. OpenFile dialog opens up, prompting the user to browse for a file.
3. user finds file, clicks OK.
4. FileOpen API passes path back to database and writes the browsed
path into the table.

Seems intuitive to me... you could even put a title on your OpenFile
dialog that gave the user instructions...

HTH,
Pieter

Nov 13 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1627
by: finchum | last post by:
here is what i want to do: i have a database that has records of properties i list to sell and then eventually sell. I have a Word document with pictures embedded into it for each property. What i want to do is be able to, within the input form i've created, click a button and have the Word document for that property open up. Each record...
2
1149
by: Eduardo Biano | last post by:
I am a python newbie and I have a problem with writing each record read to a file. The expected output is 10 rows of records, but the actual output of the code below is only one row with a very long record (10 records are lump into one record). Thank you in advance for your help. Here is the code: **************************************** ...
0
1328
by: Marcelo | last post by:
Hi, I have the following need: I list a table from an access database but cannot interact with each record. At the html page I display all records, one field (field1) from and 3 buttons for each record so to: Button 1) Accept: Sets 1 on field 2 on that record Button 2) Reject: Sets 0 on field 2 on that record Button 3) Delete: Deletes that...
1
5539
by: new | last post by:
I have data for each week in a single table. I need to export this data to a separate flat file for each week. Any ideas? DB2 SQL Query export to flat files as a function of data on each record
6
2667
by: slider | last post by:
Hey all i am using Access 2003 on Win Xp and i have been trying to make this code send emails to the users stored on each record. So far is works, except in the body of the email i need it to say a number of things, such as Dear (user), your current quota is (quota), and so on. So far i can send the emails to multiple users but when it comes...
3
3419
by: bluez | last post by:
I want to design a webpage where user can search the data from the database and list out the related records. Each of the record got a delete button which allow user to delete the record. Filename : search_student.php <?php include("../user_access/user_access_control.php"); include("../Database/database.php"); $searchStudentControl =...
4
2151
by: QntmPg | last post by:
Hi all, I have read through what I could find on previous questions regarding using the OpenArgs property, but I'm still not able to get my form to open correctly. I'm not sure exactly where the problem is, so I'll try to describe what I'm doing in as much detail as I can. Any help is greatly appreciated! I am building a database in...
3
1648
by: adonis2008 | last post by:
Hi, I have to write a Thesis, where my appendix has more than 1,000 pictures. I am not an expert (little vb code, I understand). So, how can I make a mdb (Access 2003) with records that can show on reports images. The images will appear in each record (in the reports or forms) through paths. The paths will be text in one column (table), but...
47
3700
by: Arli | last post by:
I have a database that is running with Access 2003. The Database is used to track orders and for putting time stamps on those orders. I need to put a pop up message on the database that alerts the operators when specific order #s come through. The problem is that there are 350 different order #s that require the pop up message. I think the...
0
8206
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8340
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
6621
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5713
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5392
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3840
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3875
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1452
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1185
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.