Including Photos In Database

Mar 4, 2008

I've got a database that tracks name/address/phone, etc for a large group of people. I've recently added the ability to include a person's photo on the forms and reports. I've done that by saving the photos with the naming convention of [firstname]_[lastname].jpg and then using VBA, the database checks to see if there is a file with the corresponding name of the record and displays the picture if so.

It works very well, but I can see where I would have some problems in the future. For example, if someone gets married and changes their name, the corresponding photo must also be renamed to display properly. And if there are any misspellings, that becomes a problem. Also, if James decides he wants to go by Jim, the photo would not be displayed, either.

I'm wondering if anyone has any other ideas on how I might accomplish my goal. I know I could name the photo based on the record ID, but that's not a good option, since I'll be handling the photos, while someone else will be inputting the contact details. So I won't know the recordID easily.

Is there some way to have another field in each record that points to the corresponding photo? Then if James goes by Jim, his first name can be changed, but the corresponding picture name could remain the same.

Is there some great idea that I'm missing that would make this process much simpler and scalable? Or do I just have to deal with the maintenance issues?

Thanks.

View Replies


ADVERTISEMENT

How To Share Access Database Including Forms / Queries

Jun 9, 2015

I have an Acess database (2013). This will be used by several people within one company, they don't have their own server. I would use SharePoint Online, but it seems to me, that you only can "export" the tables. The database I have is quite a complicated system, and it is neccessary to use all the Access tools - forms, reports, queries. Not tables only.

Another idea is to split the database and "store" the backend part (the tables) on Sharepoint (Office 365 online version). And all the users would have their own frontend (forms, queries...) on their own PC, linked to this backend. Would this work? Can everyone add some entries into the database this way? How does it "synchronize" then?

View 1 Replies View Related

Query From (and Including) Date - Thru (and Including) Date

Jun 16, 2006

Access 2000
Hi All.

I am running a select query on a date field.

I populate the table "date" field from a Microsoft Date and Time Picker Control 6.0(SP6).
I havent been able to figure out how to ONLY populate the date portion of the control so my field value containes Date & Time.

When I run the query, I have to select the day after my request to include the records I need. I think this is because of the time in the field
Example, If I want all records thru 6/17/2006 I must select "thru" 6/18/2006. This mucks things up if I have records dated 6/18/2006

Both of these statements give the same bad results:

Between [forms]![freports]![from] And [forms]![freports]![thru]

>=[forms]![freports]![from] And <=[forms]![freports]![thru]

Any ideas?
TIA
Detrie

View 1 Replies View Related

Importing Photos

Jun 10, 2005

Have can I apply individual photo's to members records.
One photo for the one person in each record.

Foxy

View 4 Replies View Related

Photos On Reports

Feb 10, 2008

I want to have the photo of each person in a REPORT.

PEOPLE table has as primary key an ID, and photos are named ID.jpg. For example:

ID NAME
-----------------
7112 John
2322 Lewis
3553 Peter
1222 John
and photos are labelled 7112.jpg, 2322.jpg...

How can I do this?? THANKS!!

View 2 Replies View Related

Photos In A Form

Jun 12, 2006

Hi,
Im looking to place photos into a form. The situation being a members data base and for every member record there is a mug shot to go with there information.
Is it possible to store photos in this way so it is shown on the form as your browsing though them??

Any Help would be fantastic!
Cheers
Phill

View 2 Replies View Related

Linking Photos

Feb 17, 2006

I've linked about 10 photos in my database and the size of it has swelled to alarming proportions. I linked rather than embed to keep the size down but it has still grown quite sizeably.

any ideas as to how I can overcome this kind of growth??

View 10 Replies View Related

Photos Revisited

May 2, 2006

I am a newbie in db creation..what I would like to accompish is this

I frontpage I have created a web site within the web I would liek to disply images similar to the built in display result in FP
but would rather havea DB either imbedded photos or external

photo page

table 2 cells
cell 1 large photo (created a iframe)
cell 2 table 2 cell x 6 cell (total of 12 thumbs

easiest enough to place the thumnails into the second column and edit the image to point to the large image and direct the large image to display in T1 (iframe) works like a charm

however with over 100 images I need an easier way to auto add the thumbnails and large photo to each page

my question

how do I create a DB that either contails both thum and image or asscess from folder...and ultimaley display into front page as per above

yes I ahve seach high and wide which is why I am here..seeing if any of you Access gurus can assist me

thanks in advance
Scott

View 2 Replies View Related

Linking Photos To Publisher

Jan 29, 2006

Hi,
I've got some id card templates in publisher than i want to merge in access.
i can merge the text details into access but i dont know how to link the photos. should i store the file path of the image in the database or should i embed the file.

would this work with publisher or do i need to use some code?

any help on this would be appriciated as i have no experience with pictures in access.

Thanks

View 1 Replies View Related

Pictures/PHotos In MS Acces

Jun 25, 2007

I'm not brilliant at using MS Access - can't use the VBA codes or anything like that.

basically, I want to set up a database of photogrpahs where you store thephotograph in Access, and then run a query to search for specific photos, which brings up a form showing the picture.

I seem to be OK at doing all of this so far except I can't get the photo to appear in the form - it just displays a link which you double click on to get to the photo.

I've tried to look up how to sort this on the web but don't understand the way people speak about access :confused:

can anyone help???

View 12 Replies View Related

Embedding Loads Of Photos

Jan 26, 2007

I am wondering if it is possible to embed all of the photos that I have into my photo table automatically. I have the table set up with all of the data that needs to be there but I have over 1500 photos that need to be embedded and wanted to save myself some time and automate the process somehow. I already know that embedding these photos is going to make my database huge but that isn't an issue for this particular project.

As far as I can tell from this forum, the help and the Northwind database this isn't possible without manually going through every photo but I am pretty new to Access so thought I would throw the question out there.

Thanks

View 14 Replies View Related

Access - Display Photos

Oct 8, 2007

Hi.

How can I select a name from a drop-down box and display the corresponding student's photo that is stored as a JPEG?

Thanks.

View 3 Replies View Related

Showing Photos In An MS Access Form

Aug 5, 2004

Access 2003, Win XP Pro

I have tried to find information on how to do this but everything I try fails.

I have a form on which I want to display JPG photos which are stored in a folder called FCP. The path to each photo is stored in the database table. Each record will have one photo only and the path looks something like this:

C:Documents and SettingsBKALProjectLRFCP4.jpg

Can someone tell me exactly how to design a form picture field that will display the relevant photo?

Thanks!

View 3 Replies View Related

General :: Adding Photos To A Form?

May 6, 2013

I have created a profiling database for my school. Each student can access their own form via the school's admission number - which I use as the primary key for most of the tables on the form. One section of the form shows a photo of the student. I take this photo from the school's SIMS photo file which had all the children's photos. Each photo in the file uses the school's admission number as its filename (for example 000358.jpg ).

I want to update the photos in my table by using a macro or piece of CBA code. Unfortunately, I don't know how to do this. When I set the database up I did each photo one at a time, so it took several hours.

View 5 Replies View Related

Inserting Photos As Records In Access 2003

Sep 6, 2012

I have created a tabel in access 2003 which has information about employees and i have to put even their photos as records so i can see them in a report that i have created too.

View 5 Replies View Related

General :: Adding Photos To Data Sheet From Within The Form

Oct 17, 2012

I have created a DB to store my students records, eg: Student Number, English Name, Chinese Name, Birthdate, Class Number, Age, and exam scores, I also have a photo frame to display the students photo.

In the data sheet I have an ole object field where I add the photos, the thing is it means I need to manually add this to the data sheet, whereas I can add all the other details directly from the form "Add New Record" and also search, delete or edit all from the form.

I have searched and searched but I cannot find any info that accurately explains how I may add the photos to the c where I have placed a button "Add Photo". I assume I need to create a macro and assign it to the button (on click) then this would need to open a search file location box where I can find the photo and select it to be added to the file.

The point is I wish to be able to do all the adding, deleting and editing from within the form and not have to enter into the data sheet at all.

I am using Office 2010

View 6 Replies View Related

Linked Photos Open In IE Not In Default Photo Viewer

Aug 28, 2011

With XP photo linked in Access would open from Access in my default photo viewer. With Win 7 they only open in EI.

How do I fix Access in Win 7 so the links open in my default photo viewer like they did in XP?

View 4 Replies View Related

How To Link Photos To Each Record And Display In Report (Access 2010)

Feb 1, 2013

How can I link multiple images from a folder on my drive to each record without making the database file huge?

Each record is a plant species. I want to link to photos of flower, seed, etc. See attached database example.

I would then like those images to appear on a report for each species. How would I go about doing this, if it is indeed possible?

View 6 Replies View Related

Counting Including 0

Feb 24, 2006

I need to run a query counting how many policies a client cancelled. But I need the query to include zeros. Is this possible?

Here's my SQL Statement currently.

SELECT DISTINCTROW Pqry_CancelledPolicy01.Number, Pqry_CancelledPolicy01.Name, Pqry_CancelledPolicy01.POLICY_STATUS, Count(Pqry_CancelledPolicy01.Number) AS CountOfNumber
FROM Pqry_CancelledPolicy01
GROUP BY Pqry_CancelledPolicy01.Number, Pqry_CancelledPolicy01.Name, Pqry_CancelledPolicy01.POLICY_STATUS
ORDER BY Pqry_CancelledPolicy01.Number;


Thank you in advance for the help.

View 1 Replies View Related

SQL Not Including Records W/ Empty Fld

Jan 9, 2006

Can anyone tell me why this sql is not returning all fldProjectID's for selected fldProvinceID regardless of whether a date exist for that fldProjectID in fldReportRec_D??

SELECT tblProject.fldProjectNo, tblProject.fldTitle, tblProvince.fldProvince, tblReport.fldReportRec_D AS [Monthly Status Report]
FROM (tblProvince INNER JOIN tblProject ON tblProvince.fldProvinceID = tblProject.fldProvinceID) LEFT JOIN tblReport ON tblProject.fldProjectID = tblReport.fldProjectID
WHERE (((tblReport.fldReportTypeID)=1) AND ((tblProvince.fldProvinceID)=[Forms]![Form1]![cboProvince]) AND ((Month([fldReportRec_D]))=[Forms]![Form1]![cboMonths] Or (Month([fldReportRec_D])) Is Null));

thanks in advance

View 1 Replies View Related

Query Not Including All Data

Jul 31, 2006

I currently have a query set up to pull information from 4 linked tables: Event, Readers, Class and School. The Event table contains a ClassID and a ReaderID. If everything has been assigned properly, there's no problem. If there's no reader assigned to ReaderID I still want the event details to be included in the output. Right now it's not. I'm pretty new to Access so if anyone can help, that'd be great. If you need to be try to explain further, let me know.

View 4 Replies View Related

Including End Dates Within Forms

Oct 19, 2007

Hi
I have set up a form to prompt for start and end dates so that users can input their own dates which will return a report that is based on a query. However if they enter 01/04/07 to 30/04/07 it doesn't include the last date.
I have tried putting the following into the query
Between [forms]![formname]![cbostartdate] and CDate[forms]![formname]![cboenddate]+#23:59:59# but I keep getting the following message when trying to access the form.

The expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables.

Can anyone help?
Thanks

View 11 Replies View Related

Sum Of 2 Columns In SELECT Including NULLs

Oct 5, 2005

Hi!
I want to add two columns a and b. However, there are rows in which EITHER a OR b is NULL. This should be handled as if the cell would be zero. Is there any way besides filling in 0s in the tables?

I tried
SELECT a, b,
IIF( a = NULL, b, IIF(b = NULL, a, a+b))
AS c FROM

but this doesn't work.

Any ideas?

Cheers
Tom

View 1 Replies View Related

Displaynig All Records Including Those With Null Value

Sep 18, 2007

I am very much an Access novice, and use the expression builders for my queries. I have a query based on a table and another query. The table lists station names and station numbers. The "base query" includes station numbers plus other data, so I join the two in order to display the station name.

I want to run a query that lists every station by name, then for each station tells how many occurrences of a condition are met in another field for that station. Problem is, if the condition is not met, the station is not listed in the query output, and I need to see the complete list of stations, even those that do not meet the condition.

Here's what i would like to get if there are a total of 3 stations in the population:

Station Name #of Blue Items
Station 1 100
Station 2 1
Station 3 0


Instead, I get:

Station Name #of Blue Items
Station 1 100
Station 2 1

Thanks in advance!
marigny

View 1 Replies View Related

Including Details From Query Calculation

Aug 1, 2006

Part of a database I'm developing stores details of events. Each event is funded from a variety of different sources.

There are three tables involved in making this work:
tblEvents - which stores the main event details
tblFundingOptions - which stores all the possible funding sources
tblEventFunding - which links the two together.

I have created a form to access all of this, with the information from tblEvents at the top and the Funding details on a subform.

I have created a query based on tblEventFunding which adds up the total amount of funding allocated to each event. I want to display this total on the form I've developed.

Can I do this without creating a second subform to pull the details in from the Query? I've tried creating a text box and linking it to the appropriate query, but it just displays #Name! - presumably because it doesn't know which record from the Query it should display, and I don't know how to tell it!!

Is what I'm trying to do possible, or do I need another subform?

Many thank in advance,

Gary

View 1 Replies View Related

I Need To Duplicate A Record Including The Subform

Mar 8, 2006

I want to be able to copy, or duplicate a record including all the associated records of the subform. The structure is the typical, ORDERS, ORDER DETAIL, PRODUCTS. I want to be able to copy a specific ORDER and generate a new one with all associates products. It would be nice to change one field (ORDER NAME), changing the ORDER name would simulate the "Save As.." command.

The end result would be a new Order identical to the first one (including all sub items) but with a different name.

Any suggestions?

Leonardo

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved