https://neowiki.neooffice.org/index.php?title=Creating_a_Table_and_a_Form_to_Store_Images&action=history&feed=atom
Creating a Table and a Form to Store Images - Revision history
2024-03-29T12:21:50Z
Revision history for this page on the wiki
MediaWiki 1.10.1
https://neowiki.neooffice.org/index.php?title=Creating_a_Table_and_a_Form_to_Store_Images&diff=14371&oldid=prev
Lorinda: /* External Links */ correcting formatting of link
2008-10-10T13:33:13Z
<p><span class="autocomment">External Links -</span> correcting formatting of link</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 13:33, 10 October 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 102:</strong></td>
<td colspan="2" align="left"><strong>Line 102:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Other tutorials and links</td><td> </td><td style="background: #eee; font-size: smaller;">Other tutorials and links</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">[<del style="color: red; font-weight: bold; text-decoration: none;">url=</del>http://sheepdogguides.com/fdb/fdb1imag.htm<del style="color: red; font-weight: bold; text-decoration: none;">]</del>Sheepdog Guides tutorial<del style="color: red; font-weight: bold; text-decoration: none;">[/url</del>]</td><td>+</td><td style="background: #cfc; font-size: smaller;">[http://sheepdogguides.com/fdb/fdb1imag.htm Sheepdog Guides tutorial]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Créer une Table et un Formulaire pour Stocker des Images|Français]]}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Créer une Table et un Formulaire pour Stocker des Images|Français]]}}</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Creating_a_Table_and_a_Form_to_Store_Images&diff=14370&oldid=prev
Lorinda: /* External Links */ add link to sheepdog guides
2008-10-10T13:32:40Z
<p><span class="autocomment">External Links -</span> add link to sheepdog guides</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 13:32, 10 October 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 100:</strong></td>
<td colspan="2" align="left"><strong>Line 100:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[http://www.oooforum.org/forum/viewtopic.phtml?t=56115&highlight=import+images+base+table OpenOffice.org Forum thread on images in Base]<br></td><td> </td><td style="background: #eee; font-size: smaller;">[http://www.oooforum.org/forum/viewtopic.phtml?t=56115&highlight=import+images+base+table OpenOffice.org Forum thread on images in Base]<br></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=34631#34631 Trinity thread on using images in Base]</td><td> </td><td style="background: #eee; font-size: smaller;">[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=34631#34631 Trinity thread on using images in Base]</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">Other tutorials and links</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">[url=http://sheepdogguides.com/fdb/fdb1imag.htm]Sheepdog Guides tutorial[/url]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Créer une Table et un Formulaire pour Stocker des Images|Français]]}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Créer une Table et un Formulaire pour Stocker des Images|Français]]}}</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Creating_a_Table_and_a_Form_to_Store_Images&diff=12440&oldid=prev
Lorinda: /* Notes */ add external links
2007-10-24T00:51:05Z
<p><span class="autocomment">Notes -</span> add external links</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 00:51, 24 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 95:</strong></td>
<td colspan="2" align="left"><strong>Line 95:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*:[http://student.tcu.edu/jweaks/files/GetURLpath.zip A droplet application]</td><td> </td><td style="background: #eee; font-size: smaller;">*:[http://student.tcu.edu/jweaks/files/GetURLpath.zip A droplet application]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*:[http://student.tcu.edu/jweaks/files/PasteFileURL.scpt.zip A Quicksilver plug-in]</td><td> </td><td style="background: #eee; font-size: smaller;">*:[http://student.tcu.edu/jweaks/files/PasteFileURL.scpt.zip A Quicksilver plug-in]</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">==External Links==</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">Information in these links was used to create this article.</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">[http://www.oooforum.org/forum/viewtopic.phtml?t=56115&highlight=import+images+base+table OpenOffice.org Forum thread on images in Base]<br></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=34631#34631 Trinity thread on using images in Base]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Créer une Table et un Formulaire pour Stocker des Images|Français]]}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Créer une Table et un Formulaire pour Stocker des Images|Français]]}}</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Creating_a_Table_and_a_Form_to_Store_Images&diff=12418&oldid=prev
Lorinda: /* Test Data */ correct bird name
2007-10-20T13:31:48Z
<p><span class="autocomment">Test Data -</span> correct bird name</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 13:31, 20 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 81:</strong></td>
<td colspan="2" align="left"><strong>Line 81:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:Field Trip ID: 0</td><td> </td><td style="background: #eee; font-size: smaller;">#:Field Trip ID: 0</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:Male</td><td> </td><td style="background: #eee; font-size: smaller;">#:Male</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#Bird Pictured: <del style="color: red; font-weight: bold; text-decoration: none;">Red</del>-breasted Grosbeak</td><td>+</td><td style="background: #cfc; font-size: smaller;">#Bird Pictured: <ins style="color: red; font-weight: bold; text-decoration: none;">Rose</ins>-breasted Grosbeak</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:[[Image:RBGrosbeak.jpg]]</td><td> </td><td style="background: #eee; font-size: smaller;">#:[[Image:RBGrosbeak.jpg]]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:Date: 06/13/1900</td><td> </td><td style="background: #eee; font-size: smaller;">#:Date: 06/13/1900</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Creating_a_Table_and_a_Form_to_Store_Images&diff=12414&oldid=prev
Jgd: botlangbar -> Fr page
2007-10-20T09:39:20Z
<p>botlangbar -> Fr page</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 09:39, 20 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 95:</strong></td>
<td colspan="2" align="left"><strong>Line 95:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*:[http://student.tcu.edu/jweaks/files/GetURLpath.zip A droplet application]</td><td> </td><td style="background: #eee; font-size: smaller;">*:[http://student.tcu.edu/jweaks/files/GetURLpath.zip A droplet application]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*:[http://student.tcu.edu/jweaks/files/PasteFileURL.scpt.zip A Quicksilver plug-in]</td><td> </td><td style="background: #eee; font-size: smaller;">*:[http://student.tcu.edu/jweaks/files/PasteFileURL.scpt.zip A Quicksilver plug-in]</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">{{botlangbarEN|[[Fr:Créer une Table et un Formulaire pour Stocker des Images|Français]]}}</td></tr>
</table>
Jgd
https://neowiki.neooffice.org/index.php?title=Creating_a_Table_and_a_Form_to_Store_Images&diff=12411&oldid=prev
Lorinda: /* Notes */ add info about getting file urls
2007-10-19T15:54:29Z
<p><span class="autocomment">Notes -</span> add info about getting file urls</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 15:54, 19 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 91:</strong></td>
<td colspan="2" align="left"><strong>Line 91:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*You cannot view images in the tables, only in forms.</td><td> </td><td style="background: #eee; font-size: smaller;">*You cannot view images in the tables, only in forms.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*As mentioned above, keeping lots of images--or even a few large image files--in your odb file can cause bloat and instability. If images are an needed in a database, make sure that the file size for each image is as small as possible. I used the free [http://www.xtralean.com/index.html ImageWell] to quickly resize my photos for this article. Doubtless there are other utilities that can do so as well.</td><td> </td><td style="background: #eee; font-size: smaller;">*As mentioned above, keeping lots of images--or even a few large image files--in your odb file can cause bloat and instability. If images are an needed in a database, make sure that the file size for each image is as small as possible. I used the free [http://www.xtralean.com/index.html ImageWell] to quickly resize my photos for this article. Doubtless there are other utilities that can do so as well.</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">*If you want to add file locations now, you may want to check out the following three scripts by Joe Weaks for getting the url of a file. For instructions for their use and more information, see [http://www.accordancebible.com/forums/index.php?showtopic=1510 this thread in the Accordance forums]</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">*:[http://student.tcu.edu/jweaks/files/FileDialogGetURL.scpt.zip Using a file picker dialog]</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">*:[http://student.tcu.edu/jweaks/files/GetURLpath.zip A droplet application]</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">*:[http://student.tcu.edu/jweaks/files/PasteFileURL.scpt.zip A Quicksilver plug-in]</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Creating_a_Table_and_a_Form_to_Store_Images&diff=12410&oldid=prev
Lorinda: /* Test Data */ add some notes
2007-10-19T14:08:22Z
<p><span class="autocomment">Test Data -</span> add some notes</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 14:08, 19 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 86:</strong></td>
<td colspan="2" align="left"><strong>Line 86:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:FIeld Trip ID: leave blank</td><td> </td><td style="background: #eee; font-size: smaller;">#:FIeld Trip ID: leave blank</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:Male</td><td> </td><td style="background: #eee; font-size: smaller;">#:Male</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">==Notes==</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">*Once you have imported an image with the form, that image will probably show up in design view, even though no other field content does. This does not affect the design or use of the form.</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">*You cannot view images in the tables, only in forms.</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">*As mentioned above, keeping lots of images--or even a few large image files--in your odb file can cause bloat and instability. If images are an needed in a database, make sure that the file size for each image is as small as possible. I used the free [http://www.xtralean.com/index.html ImageWell] to quickly resize my photos for this article. Doubtless there are other utilities that can do so as well.</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Creating_a_Table_and_a_Form_to_Store_Images&diff=12409&oldid=prev
Lorinda: /* Entering Data */ finish steps for data entry
2007-10-19T13:48:11Z
<p><span class="autocomment">Entering Data -</span> finish steps for data entry</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 13:48, 19 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 72:</strong></td>
<td colspan="2" align="left"><strong>Line 72:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Button|Design Mode On/Off}} button to turn off design mode and shift to data entry mode</td><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Button|Design Mode On/Off}} button to turn off design mode and shift to data entry mode</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#To test the data, enter the pictures below along with their accompanying data into the form.</td><td> </td><td style="background: #eee; font-size: smaller;">#To test the data, enter the pictures below along with their accompanying data into the form.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">##Bird Pictured: House Finch</td><td>+</td><td style="background: #cfc; font-size: smaller;">#<ins style="color: red; font-weight: bold; text-decoration: none;">: You will need to right-click or control-click on the images and choose the {{Menu|Save Image As}} or similar command to download them to your computer. The images are each less than 30 kb. They were taken by the original author of this article, and may be freely used for any non-commercial purpose. </ins></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">#</del>#:[[Image:HouseFinch.JPG]]</td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#To enter a picture, double click on the empty picture field in the form. An {{Window|Open}} dialog appears. Navigate to the location of the picture, select it, and click {{Button|Open}}</ins></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">#</del>#:Date: 01/01/1900</td><td>+</td><td style="background: #cfc; font-size: smaller;"> </td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">#</del>#:Field Trip ID: 0</td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">===Test Data===</ins></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">#</del>#:Male</td><td>+</td><td style="background: #cfc; font-size: smaller;">#Bird Pictured: House Finch</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">#</del>#Bird Pictured: Red-breasted Grosbeak</td><td>+</td><td style="background: #cfc; font-size: smaller;">#:[[Image:HouseFinch.JPG]]</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">#</del>#:[[Image:RBGrosbeak.jpg]]</td><td>+</td><td style="background: #cfc; font-size: smaller;">#:Date: 01/01/1900</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">#</del>#:Date: 06/13/1900</td><td>+</td><td style="background: #cfc; font-size: smaller;">#:Field Trip ID: 0</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">#</del>#:FIeld Trip ID: leave blank</td><td>+</td><td style="background: #cfc; font-size: smaller;">#:Male</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">#</del>#:Male</td><td>+</td><td style="background: #cfc; font-size: smaller;">#Bird Pictured: Red-breasted Grosbeak</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">#:[[Image:RBGrosbeak.jpg]]</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">#:Date: 06/13/1900</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">#:FIeld Trip ID: leave blank</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">#:Male</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Creating_a_Table_and_a_Form_to_Store_Images&diff=12408&oldid=prev
Lorinda: /* Entering Data */ adding test data; NOTE: this page not yet finished.
2007-10-19T02:50:04Z
<p><span class="autocomment">Entering Data -</span> adding test data; NOTE: this page not yet finished.</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 02:50, 19 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 71:</strong></td>
<td colspan="2" align="left"><strong>Line 71:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Now it's time to test the form we have made.</td><td> </td><td style="background: #eee; font-size: smaller;">Now it's time to test the form we have made.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Button|Design Mode On/Off}} button to turn off design mode and shift to data entry mode</td><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Button|Design Mode On/Off}} button to turn off design mode and shift to data entry mode</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#</td><td>+</td><td style="background: #cfc; font-size: smaller;">#<ins style="color: red; font-weight: bold; text-decoration: none;">To test the data, enter the pictures below along with their accompanying data into the form.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">##Bird Pictured: House Finch</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">##:[[Image:HouseFinch.JPG]]</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">##:Date: 01/01/1900</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">##:Field Trip ID: 0</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">##:Male</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">##Bird Pictured: Red-breasted Grosbeak</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">##:[[Image:RBGrosbeak.jpg]]</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">##:Date: 06/13/1900</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">##:FIeld Trip ID: leave blank</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">##:Male</ins></td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Creating_a_Table_and_a_Form_to_Store_Images&diff=12403&oldid=prev
Lorinda: /* Create A New Table */ Add fields for Male, Female, and Juvenile
2007-10-19T02:11:25Z
<p><span class="autocomment">Create A New Table -</span> Add fields for Male, Female, and Juvenile</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 02:11, 19 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 12:</strong></td>
<td colspan="2" align="left"><strong>Line 12:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:DateTaken - Date - Entry Required: Yes; Format Example: as you desire I reccommend a YYYY format.</td><td> </td><td style="background: #eee; font-size: smaller;">#:DateTaken - Date - Entry Required: Yes; Format Example: as you desire I reccommend a YYYY format.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:BirdPictured - Text [VARCHAR] - Entry Required: Yes;</td><td> </td><td style="background: #eee; font-size: smaller;">#:BirdPictured - Text [VARCHAR] - Entry Required: Yes;</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">#:Pic_Male - Yes/No [BOOLEAN] - Default Value: No; (this will reduce NULL issues)</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">#:Pic_Female - Yes/No [BOOLEAN] - Default Value: No;</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">#:Pic_Juvenile - Yes/No [BOOLEAN] - Default Value: No;</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:Picture - Image [LONGVARBINARY] - Entry Required: Yes</td><td> </td><td style="background: #eee; font-size: smaller;">#:Picture - Image [LONGVARBINARY] - Entry Required: Yes</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:PicFieldTripID - Integer - AutoValue: No; Entry Required: No</td><td> </td><td style="background: #eee; font-size: smaller;">#:PicFieldTripID - Integer - AutoValue: No; Entry Required: No</td></tr>
</table>
Lorinda