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??
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
Have can I apply individual photo's to members records.
One photo for the one person in each record.
Foxy
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!!
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
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
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???
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.
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
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.
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!
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.
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 RelatedI 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
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?
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?
i am new to databases and have developed a ads site
when the user registers they can post ads for free.
i would like to allow one user to post more than one add.
these are my databases
[members]
memberid = autonumber (primary key)
username unique
password
surname
firstname
address
post code
country
[ads]
adid autonumber (primary key)
adtitle
price
picture
contact
date posted
end date
i am guessing i will have to create a one to many database but i am lost at how to do it.
any advice would be appreciated.
hello,
I've got a back-end/front-end Access database. The front end sits on a user's desktop. There's one table she needs to update, but cannot because it's not linked. It's table called Login that contains passwords/users names. The table did not exist in the front-end. I would like to copy it from the back-end to the front-end and link it, but when I try to do that, I don't see it in the list of tables. I do this rarely. How does this work exactly?
thanks-
Is there anyway to link an excel spreadsheet to an existing database table - so that entries into either update each
other?
Question for someone..... I was looking at the "LinkTables" in Access..... I see that I can link one database to another..... When I do this I can add the table to my relationship window... I have not played with this too much.. But looks interesting. Now, all the info I might add to this linked table is stored in the other database??? If this linked table is also linked to other tables in the other DB can I use those in queries? Not much covered (that I can find) in the Access help files on this sort of thing.
Thanks
I have a field on my Form. The form holds all the information about Artists under our record label. I need to be able to attach a copy of each artists contract to their separate form. I just found out that you can't physically attach this. Does anyone have any ideas and how I could play this. Any ideas would be well appreciated.
Thanks
Shane
I use a packaged software program at the dealership I work at. In the past I have been able to pull queries and information out of the database and into Excel. The query builder pulls the data as read-only and thus no fear of changing the main database. I have developed an access database for doing commissions. I want to be able to link my database with the companies database as read-only. This would save typing a lot of the duplicate information (ie customer name, date etc.). I have been able to successfully link the 2 databases but realized quickly that anything I change in msaccess will change on the main database. I don't want to corrupt the main database and really only want to pull the information for viewing. Any comments or help would be greatly appreciated.
Thanks
Rob
I have a Form that refers to two Reports, both of which refer to two query's one for each. the whole lot(1 Form, 2 Reports, 2 Querys) is in one mdb file and the actual database is another mdb file. How do I get my objects to get their data from the main Data Base File? the 5 objects are acting as a small report making application.
View 5 Replies View Related:confused: Does anyone know if there is any way to link to seperate databases so that any information entered in one will update the same information in the other and visevirsa?
Thanks
I want to use the data contained in Access table in an Excell app. What is the best way to link them - preferably in 'real time' - is there a way excell can read directly from the tables? We need to analyse some of the data in the database through Excell....
Any suggestions welcomed...?
I am looking to lonk tables in a database.
I have one table a pc tables which has a list of pc's
the other table is a pc software table which has a list of software
i want to build a form to show the pc's and their software how do i do this