Place A Photo On A Contact Form
Jul 28, 2006Hi I have a Contact form with all the details of the contacts, I would like to add a photo for each contact, how can I get to this?
Marco
ADVERTISEMENT
Add Photo In Contact List
Jul 16, 2006Hi 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
Forms :: Form That Combines Two Tables With Photo
Oct 13, 2014I'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?
Adding A Personel's Photo In A Database ( In Form & Then Report )
May 23, 2005: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
Printing Image Contact Form
Jun 9, 2007I created a print image form in my project so that when a user opens the form, it cycles through all the images stored in a temp folder and prints them out four images/page at a time until all the images have been cycled through. I am using the below code on the "OnCurrent" event of the form. The problem I am having is trying to close the form with code after the images have been cycled through. I get an error message stating that "this action can't be carried out while processing a form or report event" I guess it is caused by the form still being sent to print. How do I add a code to catch the event when the form has finished printing? Also, when I open the form by itself, it works correctly and prints all of the images. However, when I tried to use a switchboard to open the form, it prints the switchboard form. Please help me in correcting this. Thanks
Private Sub Form_Current()
Dim mysql As String
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim PicPath As String
Dim TotalSet As Integer
Dim CurSet As Integer
Dim SetStart As Integer
Dim RecNo As Integer
Dim PicNo As Integer
Dim RecCount As Integer
Dim RecNoMove As String
Dim PageCount As String
Set rs = New ADODB.Recordset
Set conn = CurrentProject.Connection
mysql = "SELECT tbl_Image.*, tbl_Image.SelectPrint " & _
"FROM tbl_Image " & _
"WHERE (((tbl_Image.SelectPrint)=Yes));"
rs.Open mysql, conn, adOpenKeyset, adLockOptimistic
RecCount = rs.recordCount
TotalSet = (Int(((RecCount) / 5)) + 1)
CurSet = 1
PicNo = 1
SetStart = (((CurSet) * 4) - 4) + 1
rs.MoveFirst
NextSet:
For RecNo = 1 To 4
PicPath = rs("myimagepath")
Me("image" & PicNo).Picture = PicPath
PicNo = PicNo + 1
rs.MoveNext
If rs.EOF Then
If Me.Image1.Picture = "(none)" Then
End
Else
PageCount = "Page " & CurSet & " of " & TotalSet
Me.PageCount_txt = PageCount
DoCmd.PrintOut acPrintAll
GoTo closepage
End If
End
Else
End If
Next RecNo
PageCount = "Page " & CurSet & " of " & TotalSet
Me.PageCount_txt = PageCount
DoCmd.PrintOut acPrintAll
PicNo = 1
CurSet = CurSet + 1
Me.Image1.Picture = "(none)"
Me.Image2.Picture = "(none)"
Me.Image3.Picture = "(none)"
Me.Image4.Picture = "(none)"
GoTo NextSet
End
closepage:
DoCmd.Close acForm, "frm_printimage_4", acSaveNo
End Sub
How To Place A Form Into PowerPoint Using VBA
Sep 3, 2012I have made a powerpoint presentation from inside Access. I have a form that populates the fields based on user input. I would like to put a copy of this form into a powerpoint slide after the data has updated. Is there a way to do this?? I have tried numerous code variations and can't seem to get anything to work.
I am using Office 2003. My supervisors are comfortable with the display of the form the way it is. So I really need to use a picture of the form and not just the info contained in the form (otherwise i would just fill the slide with the data from the query)...
Is It Possible To Place An Animated Gif Image On My Form?
Sep 21, 2006No? Yes? If, so how?
View 2 Replies View RelatedEmail Current Contact On Form/Open Outlook
Nov 3, 2004I've researched all the email topics, but can't find what I am trying to do.
Most of these topics are talking about emailing a record or form or something.
I have a form that contains thousands of contacts address, telephone, email, etc.
I would like to create a button that on click would open Outlook and grab ONLY the
email of the current contact I am looking at on the form at that time and add that
email address to the [To:] box of a new email.
Thanks you guys, I'm learning...slowly, but it's coming.
Forms :: Send Email To Current Contact In A Form?
Jul 19, 2013I am using Access 2010 and I want to be able to open a blank email addressed to the contact I am viewing in my Access form. I have been successful in creating a button which opens Outlook, but I don't know what code to put in the 'To' field of the EmailDatabaseObject page so that it picks up the email address of the contact I am looking at.
View 2 Replies View RelatedModules & VBA :: Add Single Outlook Contact To Access Form
Jan 8, 2014Microsoft has a Desktop Student Database template (Access 2010) that does exactly what I'm trying to do:
open the Outlook Contacts dialog box, select a contact from the GAL, and then programmatically save it to a record in one of my tables.
I've tried simulating the button/coding on my data entry form, but I'm getting the error:
"The command or action 'AddFromOutlook' isn't available now"
I've search high and low but have only found a reference to creating a temp contacts table to import all the contacts.
Forms :: Creating Pop-Up Form That Lists Persons Contact Info
Sep 18, 2014I have a list of people in a list box. In the list box I only have the people names listed. (example below)
1. John
2. Frank
3. Tim
4. Jessica
I want to click on one of the names and have a form pop up on the same screen that lists the persons contact info. If I had a table like listed below, could the info auto populate on a separate form.
[ID] [Name] [Number] [Address]
1. John 456-4567 123 Elm Rd.
2.
I want the Form to pop up and show...
Name: John
Number: 456-4567
Address: 123 Elm Rd.
Modules & VBA :: Place If Statement In AfterUpdate Event On Form
Nov 13, 2014I'm trying to place an if statement in an afterupdate event on a form. The code I have is
Code:
If [Customer] Like "BRO001" And [Inv No] is null Then [Job_Price] = [Shots] * 27.5
this gives me a run time error, object required and highlights
Code:
If [Customer] Like "BRO001" And [Inv No] Is Null Then
I'd like the code to do nothing where the requirements to alter the job price are not met.
General :: Calculation On Form - Force 1 Decimal Place At All Times
May 7, 2014I'm using a calculation on my form that subtracts one number from another and stores the difference between the two in a 3rd field. This works correctly but I want the difference to show 1 decimal place at all times.
So for instance if subtract 35.1 from 35.2 I get a difference of "0.1".
But if I subtract 35.0 from 36.0 I get a difference of "1".
The first case is fine but I need the difference to be "1.0" in the second case.
I've set the number of decimal places in the table from auto to 1 and changed the format on the form to a standard number with 1 decimal place. Neither of these show a difference of 1 as "1.0"
How to force 1 decimal place at all times?
Add Staff Photo
Jan 13, 2007Hi 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.
Thanks and regards
Adding A Photo To My Database?
Jun 12, 2006Hi 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
View 2 Replies View RelatedQuery: Photo Dimensions
Jun 21, 2006Please help!
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.
Your help is much appreciated. :D
Photo Links In Tables
Mar 5, 2008I 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.
Thanks
Auto Insert Photo
Feb 28, 2005I 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.
Photo Name As Attachment To A Record
Apr 3, 2012When you query Photo.name, you get a line for each photo name attached to a record
1 aunt sally a.jpg
1 aunt sally b.jpg
1 aunt sally c.jpg
2 Uncle Joe x.jpg
3 Cousin Bob l.jpg
What I would like is to have it appear like this
1 aunt sally a.jpg; b.jpg; c.jpg
2 Uncle Joe x.jpg
3 Cousin Bob L.jpg
Change Photo Depending On Combo Box Value
May 29, 2013I have a log in form and combo box.
Just want to ask if possible to change photo depends on combo box value?
Here is the link of my database. [URL] ....
Linking Hyperlink (textbox) To A Photo
Dec 1, 2014I 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......
Adding A Different Photo Per Employee Record?
Sep 25, 2014I need to add a persons photo to their employee record and don't know where to start.
View 11 Replies View RelatedForms :: Linking A Hyperlink (textbox) To A Photo?
Dec 1, 2014I 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......
General :: Change Photo Depending On Combo Box Value?
May 29, 2013I have a log in form and user combo box.
I want to add photo of each user in this log-in form.
Just want to ask if possible to change photo depends on combo box value?
How To Link Images With Photo Editor In Access 2003?
Mar 22, 2007I 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 :)
Thanks!
Reports :: Adding A Bitmap Photo To Table / Report?
Aug 13, 2014I am wanting to store a bitmap photo in an access table and then want to include it in a report.
View 5 Replies View Related