Hi there, this is my first post, hopefully not too many more problems i will encounter whilst designing my database.
Anyway I am trying to add some fotos to each of my records, but not having as much luck as i would like. In the tables, i have made the field OLE object. When i try to add the foto (about 97kb) jpg format, all it does is add a picture of the jpg icon on my field. If i double click on the icon my foto will open, but i wish to have the foto showing in my record.
Anyone help me with any ideas? I am using access 2003
:confused: hi guys i'm working on a Personnel Project that get members information & data like Name , F_name , Birth date , place of birth & some other informations , but i want to add a Picture frame that show picture of every member in my form ( each record has a diffrent photo that i can select it from hard and fit it in a for example 3x4 Frame & store it in a access database . and then add that photo in a report with other datas !!! would u please help me doing that ?! thanks
I have a form where I can add a new resident. It runs off a query that shows ID as null and has a button to add the data and refresh the form and query. I used to drop in OLE files but have since changed it to a linked image file. What I want to do is pull the info from the data that I input as a new resident.
Basically it means that any staff member can take a photo of the resident and put it in a folder and the database will point to that file.
The location is..."C:UsersRP"&[First Name]&" "&[Last Name]&".jpeg" First Name and Last Name are in the table already. I have tried using an append and an update query to no avail.
Hi everybody, Recently I created a database for staff details in my company and I used OLE Object in Data type to make it. The problem now there are more than 500 employees in the company so it is very difficult to scan one by one photo. Is there any way that once I click on command button photo will be detected from scanner and saved directly in the field instead of doing it manually.
Does anyone know what command will allow Access to pull Dimensions from Explorer into a Query?
I wish to have a query that will illustrate the exact Dimension of an image file (Jpeg). This will enable me to filter all images which do not meet my internet standard of 100x100 dpi and/or 300x300 dpi.
I have recently learned how to link photos to a database using a form and a table listing the path to each photo. Is there anyway to format the records in the table so that when you click on the path the photo shows up?
I have browsed around past threads and have not found and answer.
I have written a form from a table which holds employees details. This table has a photo field. The form has a control which displays the employee’s photo. It uses the field, photo as the control source. This works okay but if you wish to enter a photo from the form you have to click on insert. Browse for the file etc. The Sample database “Northwind” on the access help has a similar form, but under the photograph there are command buttons to add/change or remove the photo which is obviously a much more professional way of doing it. I have looked at the properties of these control buttons and they seem to work through a visual basic program. As someone who has a very limited knowledge of VB is there a simpler way of doing this or would I be able to cut and paste the code to work on my form somehow (If Legal) Any advice would be greatly appreciated.
Hi all, I have a form of contacts wich I would like to put a photo for every contact, I would like to have a "ADD" button on the form wich will add me a photo in JPG or BMP in a certain field on the form, the photo ar stored in a folder in c: I also would like to have a "DELETE" button!!! Thanks to all Marco
I have a text box that is Hyperlink to a directory that opens fine and gives me access to files that I need. What I want is to place a photo of a particular button I've found (in the form) and on the click event have the hyperlink in the text box activate and open the directory.
1. I can't change the shape of the text box or place a picture within it... 2. I can set the pictures control source as the hyperlink text box but that serves no purpose... 3. Making the text box transparent and all the text white then overlay-ed the picture ...
It worked but I would like the appropriate way to do this.....being at such a critical stage of my access development......
I may be going about this all wrong but I have a text box that is Hyperlink to a directory that opens fine and gives me access to files that I need. What I want is to place a photo of a particular button I've found (in the form) and on the click event have the hyperlink in the text box activate and open the directory.
1. I can't change the shape of the text box or place a picture within it...
2. I can set the pictures control source as the hyperlink text box but that serves no purpose...
3. I lazy manned it buy making the text box transparent and all the text white then overlay-ed the picture ...it worked but I would like the appropriate way to do this.....being at such a critical stage of my access development......
I'm trying to create a many to many table (which I know how to do). But this is a little complicated.
I have several photos that are part of my database, so I have them in their own table which contains:
ID CallName PhotoType Source
Computer Link (to where photos are stored on my hard drive)
The photo type comes from another table, one of the types is People.
So I want to have a many to many table so I can connect people photos to places where they live. That's pretty easy, you just put foreign keys for the photo CallName and for the Place Name.
However, I want the person's photo to show up also (in a container I will put on the form). In order to do this, I need to have a field for computer link that is automatically populated based on which Photo Call Name I choose. Can you do that in a many to many form? How?
I am setting up a database with an image linked to each record. I have installed Photo Editor as required to display jpeg files. However, when I try to insert object in the table field, Photo Editor does not appear as an option under 'Object Type'. How can I use Photo Editor as my OLE server to display jpegs? Or, can someone suggest a better way to display images on forms? I'm a newbie, so although I'll try more advanced programming if required, I will need quite detailed step-by-step instructions :)
I have a database in the database I have products customers orders etc.
In Products table I have productid price etc. I would like to create another table and this table should consist of all product parts for example.
ProductID x uses metalnumber23 stone45 plasticnumber43
so all metalnumber23, stone45, plasticnumber43 will be in Parts (new table that i will create) when i am entering a productid to Product table for that productid i should be able to choose which parts from parts table that it uses.
so in the order table if i customer ordered productID x I should be able to see all the parts that ProductID needs in the parts Parts table. There will be maybe 2000 parts but ProductID x will use only 3 of them. And if I create a query lets say order from z date to y dates I should be able to see parts needed for those products ordered. hope you guys understand and give me a head start i would really appreciete
I have an old database, which is very comprehensive, filled with client names, addresses, and other information.
I have been given a new database, which is more relational and effectient, which splits the client addresses into a seperate table.
I need to add the old data to the new database - so is there a way of doing this whilst maintaining the links between the old addresses and the rest of the old data? What I don't want to have to do is end up going through 3000+ entries sorting out what new CompanyID I should assign...
First let me apologize if I am being stupid, quite new to Access. I am trying to create a database with some pictures in it; I want to design a form that changes the image with each record, (Its for work they want a database of our employees info with a photo of each employee) reading though the help file it seams I need to add a bound image control, I have tried 2 different ways and am still getting the same problem, the first way I tried was to create a text field with the address off the photos (there are .jpg’s) and then add a bound image control on the form and link it to the field. Problem is this just displays the name of the file not the picture (e.g. as you go though the records it shows Mark.jpg, Simon,jpg, Louise.jpg….) I then tried to add a OLE field and add the files that way, if I click on add from file when creating the object I get the same problem just displays the file name, If I click create new bitmap image it works and displays the picture, the problem is the data base file then becomes huge (it was 45 meg with 2 photos, I need to add about 150 in total!. Am I being totaly dumb, is there a way of getting Access to display Jpg’s and ideally have them linked to instead of embedded to keep the size of the database down.
Sorry for rambling! (oh yeh and I am using Access 2003)
Im trying to add 2 new tables to a split and linked database... but no matter which side i add the table to (BE or FE), it wont show up in the linked table manager.. so my question is 1.) is there some trick to getting it to show up in the link manager? or 2.) is there some way to re-merge the database, add the new tables.. and then split it again?
Hi all, can i use a listbox control NOT IN A PROGRAMATICALY way, in a table to allow user choose one of some pre_defined values (for example 1,2,4). This field will be used as a parameter in an communication with HW, that's why its crucial not to let users choose whatever value that they want. Thank you
I have a database with a backend on a network and the front end on each users PC. When I add security in the form of a workgroup it only apllies to the front end and anyone can open up the tables on the backend. How do I secure the whole database. Anyone have any advice on security.