Picture Not Linking Cont.

Aug 20, 2005

hopefully the attachment will be here

sorry did not notice a 2mg limit I had to omit all the pictures but you should get the jest of it.

Thank You again

roborro

View Replies


ADVERTISEMENT

Picture Linking Subform

Nov 17, 2006

I'm having a problem with my sub forms and the sample linking image code.

Top subform is in data view and the bottom in form. Sync'd with a textbox.

notes show individual data per record as you click on them, and the picture updates the location the same.

Problem I am having is that the picture does not display even though the path is there.

View 10 Replies View Related

Linking OLE Objects Picture

Aug 31, 2006

hi,
I am doing a project in vb6, ado(adodc) with backend access
2000 in which a field is ole object i.e. picture of employee. the problem is I could not link this field from vb form. Pl guide me
the methods,procedures and codes (this is my first project) I can
extract other fields such as name,address,telno etc. thanks-rk

View 1 Replies View Related

Linking To Picture In Text Field

Nov 7, 2014

I have created an inventory database that tracks all of the assets in our company over the last few days. IT is functional, but now its time to fluff it up. I am going to add the display pics that we have for all employee on the form that displays their information and what assets are assigned to them. I want it to display their picture on this form as well. I have it working, but am wondering if there is an alternate method to copy and pasting the local URL to the picture.

View 1 Replies View Related

Looping Cont

Mar 16, 2007

Hello all, thanks to Dennisk and Paul, I am able to move through my recordset and create a directory with each individual name. Now, I am attempting to "FileCopy" an excel template into each directory with the directories name.xls------got this fine.

Now I am attempting to copy and paste each individual's records by looping through the recordset RST1 and place that information into the appropriate directory/directory.xls file; close; and then save all workbooks.

Could someone point me in the right direction? Currenlty, the code is dumping all of the information into my first directory, and doing nothing for the rest of my recordsets.

Do I need another loop here? Example Do Until EOF RST1?

Here is the code:



Dim rst As DAO.RecordSet
Dim DIRName As String
Dim folder As String
Dim Dir As String
Dim strnewname As String
Dim stroldname As String
Dim Pause As Boolean
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Dim blnExcelOpen As Boolean
Dim strMacro As String
Dim mysheetpath As String
Dim rst1 As DAO.RecordSet
Dim objdb As Database

Dir = Me.Combo19
folder = "H:" & Dir & ""

'DoCmd.OpenForm "frmWait"
'DoCmd.RepaintObject acForm, "frmWait"

Set rst = CurrentDb.OpenRecordset("tblofficers")
Set rst1 = CurrentDb.OpenRecordset("tbl_Q1")

Do Until rst.EOF
DIRName = folder & rst!OFFICERS_NAME
stroldname = "H:Asset Verification Template.xls"
strnewname = folder & rst!OFFICERS_NAME & "" & rst!OFFICERS_NAME & ".xls"


' Processing each officer and creating a directory
MkDir DIRName


Sleep 10
FileCopy stroldname, strnewname
'Name stroldname As strnewname
Sleep 10
mysheetpath = strnewname
blnExcelOpen = IsExcelRunning()
If (blnExcelOpen) Then
Set xlApp = GetObject(, "Excel.Application")
Else
Set xlApp = CreateObject("Excel.Application")
End If

Set xlBook = xlApp.Workbooks.Open(mysheetpath, False, False)
Set xlSheet = xlBook.Worksheets("Sheet1")

'Transfer the data to Excel
xlSheet.Range("A2:r10000").ClearContents

xlSheet.Range("A2:r10000").CopyFromRecordset rst1
'rst1.Close
xlBook.Save

' back to the top...

xlApp.CutCopyMode = False





rst.MoveNext


Loop
' if we started Excel, then close it now…

If (Not blnExcelOpen) Then
xlApp.Quit

End If

' clean up...
Set rst1 = Nothing
Set objdb = Nothing

Set xlSheet = Nothing
Set xlBook = Nothing
Set xlApp = Nothing

View 3 Replies View Related

Cont Form With Combo Boxes

Oct 24, 2005

I have a continous form that once the combo box filters are selected, shows the applicable records. Included in records, I've put a bound combo box that allows the user to fill in that particular field. This works with the first record but when you attempt to select the other records, all the combo boxes disappear. What am I doing wrong here??

View 12 Replies View Related

Highlight Row On Cont. SubForm With Mouse Move Evemt

May 18, 2005

Using MS Access2003

Does anybody know of a way that I can highlight a row or change colours of all the text fields on a continuous subform when the mouse MOVES over a particular row.

Conditional Formatting seems the way to go and I've also tried the 'Stephan Lebans' method but that seems to require a 'row number' stored in a table in order for it to work, which is not very practical.

Many Thanks

View 2 Replies View Related

Picture

Oct 20, 2005

I'm just wondering, is it possible to put a graphics in the code? the reason I want to know is that I will put a sad face on each customer every time they call. so if they will call me 5 times i will see a 5 sad smiley face on the customer information. Can you please help me with this one. or if you know any way to do just let me know. thank you so much.

View 6 Replies View Related

Picture Box

Jan 24, 2006

Here is my situation. I have a database with a table in which contains all of the names and members of our club. Every member in our club has a rank, the rank is held in a field called "rank". I also have a form which is used to add and edit the information into this table. The form that i have create is a bog standard form with nothing special on it. What i would like to be able to do is when the form loads and the information from the table populates it, i would like a picture box to hold a picture that represents there position like an avatar. I have tried doing this myself however my attempts just resulted in errors about not have the form focus. I use the code editor to do this. I know this is possible to do as i have seen it on some other projects.

If any one has any idea or hints about how i can do this please reply.
As an added thing i would prefer if it was done in the code editor as the machine it has to run on has macros disabled.

View 3 Replies View Related

Picture Advice/help

Aug 23, 2005

Hi guys.

I have been told to make my database look 'sexier' but I am a bit worried that the pictures may slow it down or increase it's size unneccesarily.

Speed is an issue because we have some offices that dial in and access it that way and as such are limited to their connection speed.

So what I want to do is created a few images, link to them, and put in code that can 'turn them on'.

The question is how?

I have created a new image object. Changed it's properties to linked.

Now I need some code that reads:

If myvalue = "Yes" then
myImage.visible = true
Else
'code to delete image
End If

I am a bit worried because that means that the images will always be there on load up, so loading the form will be just as slow because the images are there.

Or maybe I can do

If myvalue = "Yes" then
'code to create image
End If

Please help.

Edit - Part two to this question is: How do I use relative links for images? I have a folder of images and I want them to work no matter where the database sits.

Edit again - Just another question: Is it possible to have Images appear and disappear depending where the mouse is?

View 3 Replies View Related

Insert A Picture

Feb 27, 2005

Have a database that stores information about jewelry. The user wants each record to have a picture of the item. No matter what I try I can’t put a picture field in my table. All help is appreciated. tillessal@yahoo.com :confused:

View 1 Replies View Related

Form With No Picture

Aug 29, 2005

I have a form which brings up another form like this


Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmImage"

stLinkCriteria = "[ProductID]=" & "'" & Me![txtProductID] & "'"
Me.Visible = False
DoCmd.OpenForm stDocName, , , , , , "SELECT ProductID, Description, Path FROM tblProducts WHERE " & stLinkCriteria & ";"

However, on the frmImage there is also an ImageControl that may or may
not have a picture. The name of the path and filename is stored in a field
in a table (not OLE).

I do not want the frmImage to open at all if no image can be found under the path and name specified. The file/picture name is exactly the same as the ProductID in the link criteria above.
Perhaps a message to say that no image was found.
At the moment the form opens up regardless.

By the way, the Me.Visible = False refers to the form that opens the
frmImage form, so will have to become True if no image found.

Thanks

View 1 Replies View Related

Need Some Help On Displaying Picture

Sep 14, 2005

I have set up a bound object frame on a form, everything works good, only problem i have is the picture doesn't display but the name of the picture does, ie...picture.jpg. if i click on this the picture is displayed in microsoft office picture manager, I think I'm close..maybe just a shove away..

Please help if you can,,
Thanks,
Jerry

View 2 Replies View Related

Update Of Picture

Sep 27, 2005

I need very very urgent help in database forms. I have 2 pictures. Active and Inactive. How do I go about where when there is no record, the inactive pictures shows, but when there data is entered into the db, the active pictures appear. Can someone please help me??

View 6 Replies View Related

What Is The Best Way To Store A Picture??

Jan 12, 2005

In everyones opinion what is the best way to handle picture uploads in an Access database?

One picture for one employee, where should I store the pictures. I know that keeping pictures in the database eats up space and really can slow ya down. Make a new folder just for pictures??

Thanks fellas and ladies.

View 2 Replies View Related

Picture Name As A Field Name

Jan 2, 2005

i have a folder called photos and i have all the pictures named properly, and i would like to be able to creat a table with each picture in this folder and have there picture name be the fields unique Id. im not sure how to import so many pictures and how to give there name.

View 14 Replies View Related

Adding A Picture To The Body Only

Jun 28, 2005

I have searched (not knowing what to search for), tried Access help and most importantly experimented, but alas no luck.

I have a header section and body/main section of a form.

I want the background image to fill the body/main section only, but instead it seems to cover the whole form, including the header section.

Is it possible to limit an image to the body section of a form only.

Thank you in advance

View 2 Replies View Related

Invalide Use Of Null & Picture

Oct 21, 2005

Hello.

Please help.

In form I want to see picture from another table and In form On Current i put sub:

Dim picPhotoString As Variant
Dim str1 As String
picPhotoString = Me!txtBox.value

sstr1= DLookup("[Field] ", "table", "[ID]= ' " & picPhotoString & " ' ")
Me!ObjectBoundFrame.value = str1
Me!ObjectBoundFrame.Requery

When table contain Photo, it shows, when no - I recieve error: "Invalide Use of Null".

Where is mistake?

View 2 Replies View Related

Picture On Tabulated Form

Jun 17, 2005

I was unable to find a satisfactory answer to this problem in the forum plz answer asap:
How can I add different pictures as background on different pages of a tabulated form such that each tab if clicked loads a new page with a different bkgrnd pic?
i m able to do this for entire forms but not each tabulated page portion
Please reply fast

View 4 Replies View Related

Combo Box /Sub Form /Picture

Dec 12, 2005

I was wondering if anyone could let me know how to do the following:

I have a form with a subform in it. I based the subform on a combo box that gets its info from a table seperate from the form(This works fine) when an item is selected from the combo box it retrieves the correct subform accordingly. I need to know if it is possible if when a selection is made from the combo box it could select the correct picture from the tab folder i have on the form aswell as the correct subform. The picture of my form I have attached may explain better than i can.

I appreciate any feedback whatsoever.

Thank you

View 9 Replies View Related

Importing Picture To Form

Feb 7, 2006

I have a form that is part of an auction application, and displays a picture of an item when the record is retrieved (OnCurrent event).
That works fine, but (presumably when the server is slow) I get a popup box informing me that it is "Importing Picture", often flashing too quickly to be read, let alone cancelled.
How can I turn this warning off?

View 3 Replies View Related

Importing Picture To Form

Feb 7, 2006

If this is a duplicate posting, my apologies - my machine's playing up.

I have a form that is part of an auction application, and displays a picture of an item when the record is retrieved (OnCurrent event).

That works fine, but (presumably when the server is slow) I get a popup box informing me that it is "Importing Picture", often flashing too quickly to be read, let alone cancelled.

How can I turn this warning off?

View 1 Replies View Related

Picture As Background Problem

Jun 22, 2006

I have created a db with a picture linked to every form as a background.
The mdb file and the jpeg file are on the server but if it is open and someone else tries to open it it will give an error and the bg won't be linked to the forms.
If the picture is embedded the db becomes sooo large (from 700 kb to 43 mb!!!!) so that's also not the solution.
Hope that someone can help.

Wendi:)

View 2 Replies View Related

Picture Or Object Problem

Jul 28, 2006

Is there a way to merge a picture or object to the background so i can put fields over it.

Here's is what I'm doing, I have a picture of a tool and need to measure it in certain spots. I have my pic, but when I try to put my fields in place they disappear to underneath the pic. I need an suggestions

View 2 Replies View Related

Assigning Picture On Selection

Aug 22, 2006

Hey to all. I have this form in which I need according to a user selection to assign a picture and display it on the same form. Is this possible? How do I do this? Or can I display the picture to another form or a report based on the first form?

Thanks in advance.

View 2 Replies View Related

Delete Picture From A Form

Aug 26, 2006

Hi, I have finally managed to create a button wich add a photo with the code below, what I need now is to create a button DELETE wich will remove the photo I have loaded !

Private Sub cmdBrowse_Click()
On Error GoTo err_cmdBrowse

Me![txtPicture] = GetOpenFile_CLT("C:Documents and SettingsMarcoDocumentiB MedCrew SchedulerPhotos", "Select the File")
Me![txtPicture] = LCase(Me![txtPicture])
Me!Picture.Picture = Me!txtPicture

exit_cmdBrowse:
Exit Sub

err_cmdBrowse:
MsgBox Error$
Resume exit_cmdBrowse

End Sub

View 3 Replies View Related







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