I have over 5000 thumbnail pictures of size 5kb each. I would like to
able to load all 5000 pictures and view 50 per page using
mysql_data_seek(). I would like to know what are the advantages and
disadvantages of using a MySQL blob field rather than reading the
images directly from the file? How does one insert an image into a
blob field? Can it be done dynamically?
Thank you
John 7 7025
You do not want to use mysql_data_seek. You will be fetching 24Mb of data
100 times if you do it that way (you will be fetching the entire result on
each page (100 of them), and then seeking to picture 50, 100, whatever.
Limit the results in your query, for the love of god. (Look up LIMIT in the
mysql docs - e.g. SELECT pic FROM pictures LIMIT 1,50 etc.)
As for storing in the database vs. storing filenames in the database - the
database will give you a better chance for sequential disk I/O, and will
reduce overhead most likely (i.e. storing a lot of small files that are
around 5kb will likely mean you are using up 2 4kb clusters for each file,
which is a huge waste of space. The database will likely have some wasted
space as you have variable-length records, but at least the table will be in
one physical file, leaving the specifics up to the database.)
As for inserting binary data into a blob field, search the newsgroup or the
web, there are plenty of examples and tutorials.
My $.02
// Ian Fette
// Proponent comp.lang.php
John wrote: I have over 5000 thumbnail pictures of size 5kb each. I would like to able to load all 5000 pictures and view 50 per page using mysql_data_seek(). I would like to know what are the advantages and disadvantages of using a MySQL blob field rather than reading the images directly from the file? How does one insert an image into a blob field? Can it be done dynamically?
Thank you John
Thank you very much Agelmar for the detail information. I have tried
implementing using blob field but I am having a problem displaying the
images. I read from other articles in the newsgroup that in order to
display the image one need to also store the filetype and then use
header() to show the image. But this can only work if one is
displaying only one image and where the image has to be displayed
before any other output is displayed in the browser, otherwise one
would get the dreaded header error. My application is a catalog that
displays 50 products per page with each product having its own image
and information. Is there not a simpler way to show the images? My
images are only jpeg files.
Thank you
John
"Agelmar" <if**********@comcast.net> wrote in message news:<bs************@ID-30799.news.uni-berlin.de>... You do not want to use mysql_data_seek. You will be fetching 24Mb of data 100 times if you do it that way (you will be fetching the entire result on each page (100 of them), and then seeking to picture 50, 100, whatever. Limit the results in your query, for the love of god. (Look up LIMIT in the mysql docs - e.g. SELECT pic FROM pictures LIMIT 1,50 etc.)
As for storing in the database vs. storing filenames in the database - the database will give you a better chance for sequential disk I/O, and will reduce overhead most likely (i.e. storing a lot of small files that are around 5kb will likely mean you are using up 2 4kb clusters for each file, which is a huge waste of space. The database will likely have some wasted space as you have variable-length records, but at least the table will be in one physical file, leaving the specifics up to the database.)
As for inserting binary data into a blob field, search the newsgroup or the web, there are plenty of examples and tutorials.
My $.02 // Ian Fette // Proponent comp.lang.php
John wrote: I have over 5000 thumbnail pictures of size 5kb each. I would like to able to load all 5000 pictures and view 50 per page using mysql_data_seek(). I would like to know what are the advantages and disadvantages of using a MySQL blob field rather than reading the images directly from the file? How does one insert an image into a blob field? Can it be done dynamically?
Thank you John
John - you are correct about the header bit, but you are incorrect about its
limitations. What you would do is something like:
<img src="showimage.php?imageid=2428" alt="whatever">
and then showimage.php has header("content-type: whatever...."); at the top,
followed by the something that spits out the data for the image. Thus it
sends the header information for each image. (The "header before any output"
rule is still observed, because you are sending the header before any output
for the page in question. Yes, data will have already been sent for your
overall page, but for showimage.php?imageid=2428 (your source for the
image), you will be sending the header before any output for *that* data
request.) http://www.sum-it.nl/en200319.php3 has a tutorial that at least shows the
general idea (jump down to the "Show Thumbnail" section. They should not be
using stripslashes() on the result from the mysql_query unless
magic_quotes_runtime or whatever is on (not gpc, but runtime or sybase), but
you get the general idea.
Hope this helps clarify things a bit...
John wrote: Thank you very much Agelmar for the detail information. I have tried implementing using blob field but I am having a problem displaying the images. I read from other articles in the newsgroup that in order to display the image one need to also store the filetype and then use header() to show the image. But this can only work if one is displaying only one image and where the image has to be displayed before any other output is displayed in the browser, otherwise one would get the dreaded header error. My application is a catalog that displays 50 products per page with each product having its own image and information. Is there not a simpler way to show the images? My images are only jpeg files.
Thank you John
"Agelmar" <if**********@comcast.net> wrote in message news:<bs************@ID-30799.news.uni-berlin.de>... You do not want to use mysql_data_seek. You will be fetching 24Mb of data 100 times if you do it that way (you will be fetching the entire result on each page (100 of them), and then seeking to picture 50, 100, whatever. Limit the results in your query, for the love of god. (Look up LIMIT in the mysql docs - e.g. SELECT pic FROM pictures LIMIT 1,50 etc.)
As for storing in the database vs. storing filenames in the database - the database will give you a better chance for sequential disk I/O, and will reduce overhead most likely (i.e. storing a lot of small files that are around 5kb will likely mean you are using up 2 4kb clusters for each file, which is a huge waste of space. The database will likely have some wasted space as you have variable-length records, but at least the table will be in one physical file, leaving the specifics up to the database.)
As for inserting binary data into a blob field, search the newsgroup or the web, there are plenty of examples and tutorials.
My $.02 // Ian Fette // Proponent comp.lang.php
John wrote: I have over 5000 thumbnail pictures of size 5kb each. I would like to able to load all 5000 pictures and view 50 per page using mysql_data_seek(). I would like to know what are the advantages and disadvantages of using a MySQL blob field rather than reading the images directly from the file? How does one insert an image into a blob field? Can it be done dynamically?
Thank you John
Agelmar
I have implemented as you have explained, but the code <img
src="showimage.php"> is not calling the PHP file. Only an empty X icon
is showing on the browser.
John
"Agelmar" <if**********@comcast.net> wrote in message news:<bs************@ID-30799.news.uni-berlin.de>... John - you are correct about the header bit, but you are incorrect about its limitations. What you would do is something like:
<img src="showimage.php?imageid=2428" alt="whatever">
and then showimage.php has header("content-type: whatever...."); at the top, followed by the something that spits out the data for the image. Thus it sends the header information for each image. (The "header before any output" rule is still observed, because you are sending the header before any output for the page in question. Yes, data will have already been sent for your overall page, but for showimage.php?imageid=2428 (your source for the image), you will be sending the header before any output for *that* data request.)
http://www.sum-it.nl/en200319.php3 has a tutorial that at least shows the general idea (jump down to the "Show Thumbnail" section. They should not be using stripslashes() on the result from the mysql_query unless magic_quotes_runtime or whatever is on (not gpc, but runtime or sybase), but you get the general idea.
Hope this helps clarify things a bit...
John wrote: Thank you very much Agelmar for the detail information. I have tried implementing using blob field but I am having a problem displaying the images. I read from other articles in the newsgroup that in order to display the image one need to also store the filetype and then use header() to show the image. But this can only work if one is displaying only one image and where the image has to be displayed before any other output is displayed in the browser, otherwise one would get the dreaded header error. My application is a catalog that displays 50 products per page with each product having its own image and information. Is there not a simpler way to show the images? My images are only jpeg files.
Thank you John
"Agelmar" <if**********@comcast.net> wrote in message news:<bs************@ID-30799.news.uni-berlin.de>... You do not want to use mysql_data_seek. You will be fetching 24Mb of data 100 times if you do it that way (you will be fetching the entire result on each page (100 of them), and then seeking to picture 50, 100, whatever. Limit the results in your query, for the love of god. (Look up LIMIT in the mysql docs - e.g. SELECT pic FROM pictures LIMIT 1,50 etc.)
As for storing in the database vs. storing filenames in the database - the database will give you a better chance for sequential disk I/O, and will reduce overhead most likely (i.e. storing a lot of small files that are around 5kb will likely mean you are using up 2 4kb clusters for each file, which is a huge waste of space. The database will likely have some wasted space as you have variable-length records, but at least the table will be in one physical file, leaving the specifics up to the database.)
As for inserting binary data into a blob field, search the newsgroup or the web, there are plenty of examples and tutorials.
My $.02 // Ian Fette // Proponent comp.lang.php
John wrote: I have over 5000 thumbnail pictures of size 5kb each. I would like to able to load all 5000 pictures and view 50 per page using mysql_data_seek(). I would like to know what are the advantages and disadvantages of using a MySQL blob field rather than reading the images directly from the file? How does one insert an image into a blob field? Can it be done dynamically?
Thank you John
Would you mind posting your code for showimage.php?
"John" <jk*****@yahoo.com> wrote in message
news:f6*************************@posting.google.co m... Agelmar
I have implemented as you have explained, but the code <img src="showimage.php"> is not calling the PHP file. Only an empty X icon is showing on the browser.
John
"Agelmar" <if**********@comcast.net> wrote in message
news:<bs************@ID-30799.news.uni-berlin.de>... John - you are correct about the header bit, but you are incorrect about
its limitations. What you would do is something like:
<img src="showimage.php?imageid=2428" alt="whatever">
and then showimage.php has header("content-type: whatever...."); at the
top, followed by the something that spits out the data for the image. Thus it sends the header information for each image. (The "header before any
output" rule is still observed, because you are sending the header before any
output for the page in question. Yes, data will have already been sent for your overall page, but for showimage.php?imageid=2428 (your source for the image), you will be sending the header before any output for *that* data request.)
http://www.sum-it.nl/en200319.php3 has a tutorial that at least shows
the general idea (jump down to the "Show Thumbnail" section. They should not
be using stripslashes() on the result from the mysql_query unless magic_quotes_runtime or whatever is on (not gpc, but runtime or sybase),
but you get the general idea.
Hope this helps clarify things a bit...
John wrote: Thank you very much Agelmar for the detail information. I have tried implementing using blob field but I am having a problem displaying the images. I read from other articles in the newsgroup that in order to display the image one need to also store the filetype and then use header() to show the image. But this can only work if one is displaying only one image and where the image has to be displayed before any other output is displayed in the browser, otherwise one would get the dreaded header error. My application is a catalog that displays 50 products per page with each product having its own image and information. Is there not a simpler way to show the images? My images are only jpeg files.
Thank you John
"Agelmar" <if**********@comcast.net> wrote in message news:<bs************@ID-30799.news.uni-berlin.de>... > You do not want to use mysql_data_seek. You will be fetching 24Mb of > data 100 times if you do it that way (you will be fetching the > entire result on > each page (100 of them), and then seeking to picture 50, 100, > whatever. > Limit the results in your query, for the love of god. (Look up LIMIT > in the > mysql docs - e.g. SELECT pic FROM pictures LIMIT 1,50 etc.) > > As for storing in the database vs. storing filenames in the database > - the > database will give you a better chance for sequential disk I/O, and > will > reduce overhead most likely (i.e. storing a lot of small files that > are > around 5kb will likely mean you are using up 2 4kb clusters for each > file, > which is a huge waste of space. The database will likely have some > wasted > space as you have variable-length records, but at least the table > will be in > one physical file, leaving the specifics up to the database.) > > As for inserting binary data into a blob field, search the newsgroup > or the > web, there are plenty of examples and tutorials. > > My $.02 > // Ian Fette > // Proponent comp.lang.php > > John wrote: >> I have over 5000 thumbnail pictures of size 5kb each. I would like >> to >> able to load all 5000 pictures and view 50 per page using >> mysql_data_seek(). I would like to know what are the advantages and >> disadvantages of using a MySQL blob field rather than reading the >> images directly from the file? How does one insert an image into a >> blob field? Can it be done dynamically? >> >> Thank you >> John
OK John - I whipped up a quick example. You will obviously want to add error
checking and more features, but this should get you going. Three files:
addpic.php, getpic.php, and pic.html (which calls getpic.php)
This is tested with php 4.3.4 and mysql 4.0.12 (yeah I know I should upgrade
to 4.0.17 but I haven't found the time) :-)
The structure of pics is as follows:
id, which is an int and primary key and auto_increment
pic, which is blob
With that:
addpic.php:
<html>
<body>
<form name="addpic" method="post" action="addpic.php"
enctype="multipart/form-data">
<input type="file" name="pict">
<input type="submit" value="add pic"></form>
<?php
if (isset($_FILES['pict']))
{
echo "Adding picture to DB";
$MySQL_Link = mysql_connect("localhost", "ian", "my_password");
mysql_select_db("ian");
$file = fopen($_FILES['pict']['tmp_name'], "r");
$pic = fread($file, 1000000); // this will read up to 1MB... change if you
like
mysql_query("INSERT INTO pics VALUES (NULL,
\"".mysql_escape_string($pic)."\")", $MySQL_Link);
}
?>
</body>
</html>
getpic.php: (You definitely want to add error checking, this is just a
crappy example)
<?php
header("Content-type: image/jpeg");
$MySQL_Link = mysql_connect("localhost", "ian", "my_password");
mysql_select_db("ian");
$pic = mysql_query("SELECT pic FROM pics WHERE id = '{$_GET['id']}'",
$MySQL_Link);
$data = mysql_fetch_array($pic);
echo $data['pic'];
?>
pic.html:
<html>
<body>
<p>blah blah</p>
<p><img src="getpic.php?id=2"></p>
<p><img src="getpic.php?id=1"></p>
</body>
</html>
"Agelmar" <if**********@comcast.net> wrote in message
news:bs************@ID-30799.news.uni-berlin.de... Would you mind posting your code for showimage.php?
"John" <jk*****@yahoo.com> wrote in message news:f6*************************@posting.google.co m... Agelmar
I have implemented as you have explained, but the code <img src="showimage.php"> is not calling the PHP file. Only an empty X icon is showing on the browser.
John
"Agelmar" <if**********@comcast.net> wrote in message news:<bs************@ID-30799.news.uni-berlin.de>... John - you are correct about the header bit, but you are incorrect
about its limitations. What you would do is something like:
<img src="showimage.php?imageid=2428" alt="whatever">
and then showimage.php has header("content-type: whatever...."); at
the top, followed by the something that spits out the data for the image. Thus
it sends the header information for each image. (The "header before any output" rule is still observed, because you are sending the header before any output for the page in question. Yes, data will have already been sent for
your overall page, but for showimage.php?imageid=2428 (your source for the image), you will be sending the header before any output for *that*
data request.)
http://www.sum-it.nl/en200319.php3 has a tutorial that at least shows the general idea (jump down to the "Show Thumbnail" section. They should
not be using stripslashes() on the result from the mysql_query unless magic_quotes_runtime or whatever is on (not gpc, but runtime or
sybase), but you get the general idea.
Hope this helps clarify things a bit...
John wrote: > Thank you very much Agelmar for the detail information. I have tried > implementing using blob field but I am having a problem displaying
the > images. I read from other articles in the newsgroup that in order to > display the image one need to also store the filetype and then use > header() to show the image. But this can only work if one is > displaying only one image and where the image has to be displayed > before any other output is displayed in the browser, otherwise one > would get the dreaded header error. My application is a catalog that > displays 50 products per page with each product having its own image > and information. Is there not a simpler way to show the images? My > images are only jpeg files. > > Thank you > John > > "Agelmar" <if**********@comcast.net> wrote in message > news:<bs************@ID-30799.news.uni-berlin.de>... >> You do not want to use mysql_data_seek. You will be fetching 24Mb
of >> data 100 times if you do it that way (you will be fetching the >> entire result on >> each page (100 of them), and then seeking to picture 50, 100, >> whatever. >> Limit the results in your query, for the love of god. (Look up
LIMIT >> in the >> mysql docs - e.g. SELECT pic FROM pictures LIMIT 1,50 etc.) >> >> As for storing in the database vs. storing filenames in the
database >> - the >> database will give you a better chance for sequential disk I/O, and >> will >> reduce overhead most likely (i.e. storing a lot of small files that >> are >> around 5kb will likely mean you are using up 2 4kb clusters for
each >> file, >> which is a huge waste of space. The database will likely have some >> wasted >> space as you have variable-length records, but at least the table >> will be in >> one physical file, leaving the specifics up to the database.) >> >> As for inserting binary data into a blob field, search the
newsgroup >> or the >> web, there are plenty of examples and tutorials. >> >> My $.02 >> // Ian Fette >> // Proponent comp.lang.php >> >> John wrote: >>> I have over 5000 thumbnail pictures of size 5kb each. I would like >>> to >>> able to load all 5000 pictures and view 50 per page using >>> mysql_data_seek(). I would like to know what are the advantages
and >>> disadvantages of using a MySQL blob field rather than reading the >>> images directly from the file? How does one insert an image into a >>> blob field? Can it be done dynamically? >>> >>> Thank you >>> John
Also - I should mention - for getpic.php: the very first line of getpic.php
should be <?php (no blank spaces and/or blank lines before it) and the very
last bit should be ?> (no blank spaces / lines afterwards)
"Agelmar" <if**********@comcast.net> wrote in message
news:bs************@ID-30799.news.uni-berlin.de... OK John - I whipped up a quick example. You will obviously want to add
error checking and more features, but this should get you going. Three files: addpic.php, getpic.php, and pic.html (which calls getpic.php)
This is tested with php 4.3.4 and mysql 4.0.12 (yeah I know I should
upgrade to 4.0.17 but I haven't found the time) :-)
The structure of pics is as follows:
id, which is an int and primary key and auto_increment pic, which is blob
With that: addpic.php:
<html> <body> <form name="addpic" method="post" action="addpic.php" enctype="multipart/form-data"> <input type="file" name="pict"> <input type="submit" value="add pic"></form>
<?php if (isset($_FILES['pict'])) { echo "Adding picture to DB"; $MySQL_Link = mysql_connect("localhost", "ian", "my_password"); mysql_select_db("ian"); $file = fopen($_FILES['pict']['tmp_name'], "r"); $pic = fread($file, 1000000); // this will read up to 1MB... change if
you like mysql_query("INSERT INTO pics VALUES (NULL, \"".mysql_escape_string($pic)."\")", $MySQL_Link); } ?> </body> </html>
getpic.php: (You definitely want to add error checking, this is just a crappy example) <?php header("Content-type: image/jpeg"); $MySQL_Link = mysql_connect("localhost", "ian", "my_password"); mysql_select_db("ian"); $pic = mysql_query("SELECT pic FROM pics WHERE id = '{$_GET['id']}'", $MySQL_Link); $data = mysql_fetch_array($pic); echo $data['pic']; ?>
pic.html: <html> <body> <p>blah blah</p> <p><img src="getpic.php?id=2"></p> <p><img src="getpic.php?id=1"></p> </body> </html>
"Agelmar" <if**********@comcast.net> wrote in message news:bs************@ID-30799.news.uni-berlin.de... Would you mind posting your code for showimage.php?
"John" <jk*****@yahoo.com> wrote in message news:f6*************************@posting.google.co m... Agelmar
I have implemented as you have explained, but the code <img src="showimage.php"> is not calling the PHP file. Only an empty X icon is showing on the browser.
John
"Agelmar" <if**********@comcast.net> wrote in message news:<bs************@ID-30799.news.uni-berlin.de>... > John - you are correct about the header bit, but you are incorrect about its > limitations. What you would do is something like: > > <img src="showimage.php?imageid=2428" alt="whatever"> > > and then showimage.php has header("content-type: whatever...."); at the top, > followed by the something that spits out the data for the image.
Thus it > sends the header information for each image. (The "header before any output" > rule is still observed, because you are sending the header before
any output > for the page in question. Yes, data will have already been sent for your > overall page, but for showimage.php?imageid=2428 (your source for
the > image), you will be sending the header before any output for *that* data > request.) > > http://www.sum-it.nl/en200319.php3 has a tutorial that at least
shows the > general idea (jump down to the "Show Thumbnail" section. They should not be > using stripslashes() on the result from the mysql_query unless > magic_quotes_runtime or whatever is on (not gpc, but runtime or sybase), but > you get the general idea. > > Hope this helps clarify things a bit... > > John wrote: > > Thank you very much Agelmar for the detail information. I have tri
ed > > implementing using blob field but I am having a problem displaying the > > images. I read from other articles in the newsgroup that in order
to > > display the image one need to also store the filetype and then use > > header() to show the image. But this can only work if one is > > displaying only one image and where the image has to be displayed > > before any other output is displayed in the browser, otherwise one > > would get the dreaded header error. My application is a catalog
that > > displays 50 products per page with each product having its own
image > > and information. Is there not a simpler way to show the images?
My > > images are only jpeg files. > > > > Thank you > > John > > > > "Agelmar" <if**********@comcast.net> wrote in message > > news:<bs************@ID-30799.news.uni-berlin.de>... > >> You do not want to use mysql_data_seek. You will be fetching 24Mb of > >> data 100 times if you do it that way (you will be fetching the > >> entire result on > >> each page (100 of them), and then seeking to picture 50, 100, > >> whatever. > >> Limit the results in your query, for the love of god. (Look up LIMIT > >> in the > >> mysql docs - e.g. SELECT pic FROM pictures LIMIT 1,50 etc.) > >> > >> As for storing in the database vs. storing filenames in the database > >> - the > >> database will give you a better chance for sequential disk I/O,
and > >> will > >> reduce overhead most likely (i.e. storing a lot of small files
that > >> are > >> around 5kb will likely mean you are using up 2 4kb clusters for each > >> file, > >> which is a huge waste of space. The database will likely have
some > >> wasted > >> space as you have variable-length records, but at least the table > >> will be in > >> one physical file, leaving the specifics up to the database.) > >> > >> As for inserting binary data into a blob field, search the newsgroup > >> or the > >> web, there are plenty of examples and tutorials. > >> > >> My $.02 > >> // Ian Fette > >> // Proponent comp.lang.php > >> > >> John wrote: > >>> I have over 5000 thumbnail pictures of size 5kb each. I would
like > >>> to > >>> able to load all 5000 pictures and view 50 per page using > >>> mysql_data_seek(). I would like to know what are the advantages and > >>> disadvantages of using a MySQL blob field rather than reading
the > >>> images directly from the file? How does one insert an image into
a > >>> blob field? Can it be done dynamically? > >>> > >>> Thank you > >>> John
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: NotGiven |
last post by:
I am researching the best place to put pictures. I have heard form both
sides and I'd like to know why one is better than the other.
Many thanks!
|
by: Rajesh Kapur |
last post by:
Hello All,
We are building an application that will dynamically choose and pre-pend
short underwriting messages to the audio streamed over the web. We will use
SMIL files. We need to decide if...
|
by: ssp |
last post by:
Dear all,
I'm dealing with a very tricky problem and can't seem to find the
answer with google. the problem is: i want to store huge data
(binaries) inside a mysql databases blob - to later...
|
by: Roberto Castro |
last post by:
I have some problems with the way I am showing the BLOB fields in the
Image web controls. It does work on my localhost though sometimes I
need to hit Refresh for the images to load properly....
|
by: Ken |
last post by:
Hello,
I'm trying to read a Blob from Oracle and then write it to an audio
file(.AU). I'm using Visual Studio.Net 2003 (VB). I can't seem to get my
code to work. Will someone take a look at it...
|
by: Ken |
last post by:
Hello,
I'm trying to read a Blob from Oracle and then write it to an audio
file(.AU). I'm using Visual Studio.Net 2003 (VB). I can't seem to get my
code to work. Will someone take a look at it...
|
by: Peter Proost |
last post by:
Hi I got this code to read in a file to the database, if use it to save a
image from a picturebox to the database it works ok, but now I use it to
directly save a file to the database without...
|
by: Nau |
last post by:
How can I display BLOB(Oracle) data in asp page
|
by: Bishman |
last post by:
Hi,
Can someone suggest the best technique / method of opening a Word ( or any
other ) Document from an SQL BLOB ?
I have the process of saving and retrieveing the file from an SQL Binary...
|
by: Aliciasmith |
last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
|
by: tracyyun |
last post by:
Hello everyone,
I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
|
by: giovanniandrean |
last post by:
The energy model is structured as follows and uses excel sheets to give input data:
1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
|
by: Teri B |
last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course.
0ne-to-many. One course many roles.
Then I created a report based on the Course form and...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM)
Please note that the UK and Europe revert to winter time on...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
|
by: isladogs |
last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, Mike...
|
by: GKJR |
last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
| |