Picture Link

Appreciate some help here and thanks in advance.

I link my pictures to the following folders

C:\Documents and Settings\MyName\Desktop\Picture.jpg
C:\Documents and Settings\MyName\My Documents\Picture.bmp

My code:
If Me!pic1a = "X" Then
Forms!startpg!fmpPic!Img.Picture = ""
Else
Forms!startpg!fmpPic!Img.Picture = Me!pic1a
End If

It works on my PC but when I copied the program to another PC, it does not 
work.

This is because of "MyName" and the other PC has a different name. Is there 
a way  to ignore "MyName" for any PCs

Regards
0
Utf
3/19/2008 3:26:00 AM
access.formscoding 7493 articles. 0 followers. Follow

1 Replies
1164 Views

Similar Articles

[PageSpeed] 17

"ChoonBoy" <ChoonBoy@discussions.microsoft.com> wrote in message 
news:FA25AACB-DB88-447C-BF58-EE0A7FCB5A52@microsoft.com...
> Appreciate some help here and thanks in advance.
>
> I link my pictures to the following folders
>
> C:\Documents and Settings\MyName\Desktop\Picture.jpg
> C:\Documents and Settings\MyName\My Documents\Picture.bmp
>
> My code:
> If Me!pic1a = "X" Then
> Forms!startpg!fmpPic!Img.Picture = ""
> Else
> Forms!startpg!fmpPic!Img.Picture = Me!pic1a
> End If
>
> It works on my PC but when I copied the program to another PC, it does not
> work.
>
> This is because of "MyName" and the other PC has a different name. Is 
> there
> a way  to ignore "MyName" for any PCs
>
> Regards


There's code to retrieve the location of these and other folders at the 
following URL ...

http://www.mvps.org/access/api/api0054.htm

It's a lot of code, but you just need to copy and paste it into a standard 
module. Once you've done that, calling the code is easy ...

? fgetspecialfolderlocation(csidl_personal)
C:\Users\Brendan Reynolds\Documents
? fgetspecialfolderlocation(csidl_desktopdirectory)
C:\Users\Brendan Reynolds\Desktop

-- 
Brendan Reynolds 

0
Brendan
3/19/2008 10:49:12 AM
Reply:

Similar Artilces:

picture is not showing up in Excel
I have a picture that is in an Excel worksheet. I can see the handles and if I move the handles some, the picture will show up. However, it will not show up in print preview at all or page break preview. I can open the same file on another computer and it will show up fine. Any help would be appreciated. thanks. Check Tools -> Options ->General Do you have "Show All" selected for Objects? "cab58" wrote: > I have a picture that is in an Excel worksheet. I can see the handles > and if I move the handles some, the picture will show up. However, it > will...

combo box linked subform values
I have created a subform and a combo box. When the user selects a value in the combo box such as unit4, they should be able to see only unit4 details in the subform. This is my trouble. Does anybody know how to get a combo value to determine the subform data? I have created numerous queries and functions but can't get this to work. Please help. Thanks, Mitchell -- Message posted via http://www.accessmonster.com Without knowing all your specifics, the general solution is similar to the following: (the subform has a sql string to load records) Private Sub cboUnits_AfterUpdate() Dim st...

Problems Printing a Linked Word document
I am having trouble printing a word document that has linked excel tables in it. When I print the document, some of the linked excel tables get skewed and distorted. However, they look normal on screen. What causes this? How can I fix it? -- jc ...

Embedded pictures
Hello! I noticed that the when we set the picture property of a button or another control as embedded, it takes a lot of place. Is there an explication that show why the Access file encrease in size by more than the picture size (even if it is a bitmap, a format that is normaly heavy) Exemple: An mdb without picture would take 4 MB the same file with pictures would increase to 40 MB with only 400 KB of pictures. In JPEG format. Is it because Access uses a non efficient compression to include the image file? Thank you in advance for any suggestion! PS: I know that I can set the pictur...

Pictures don't print in outlook 2000 or 97
How do I get pictures to print when I print messages for Outlook 2000 or Outlook 97. I'm using XP Home. Thanks, Chris Hi Chris, Have you checked to make sure you have all of the latest Windows and Office Service Packs installed? I remember this issue from a whle back, and it was corrected in one of the service pack releases. Regards, Scott Atkins MCSE, MCSA Partner Technical Lead - Outlook Microsoft Technical Support for Platforms and Business Applications -------------------- >From: socialism001@yahoo.com >Newsgroups: microsoft.public.outlook >Subject: Pictures don't...

Inserting picture from "My Pictures"
When I add a pic from "My pictures" the entire picture does not appear on the slide and when I try to format it it is impossible to get it back to the same pic I am attempting to add. If I am trying to add a pic I might only get a nose or a blade of grass instead of the original picture from "My Pictures". Reduce the zoom to 10%. Coul be a too large image "PP Neophyte" <PP Neophyte@discussions.microsoft.com> a �crit dans le message de news: CA5F97E6-D4D8-401B-B066-E261024F082F@microsoft.com... > When I add a pic from "My pictures" t...

picture in picture
Have to digital pictures & would like to put a couple of people on one picture into the other picture. How do i do this? Anyone got any ideas? TIA "ted medin" <n6trf@arrl.net> wrote in message news:OaNwFXQeKHA.2596@TK2MSFTNGP04.phx.gbl... > Have to digital pictures & would like to put a couple of people on one > picture into the other picture. How do i do this? Anyone got any ideas? > TIA Well not with Vista. You need a Graphic editing application. The Gimp may be able to do this. (It's free, Open Source but is a bit tricky yo get to lear...

stop update link messages
I have a workbook I received (via email) from someone we buy from, I take that workbook and edit it to be able to send individual sheets to my customers. Problem is, original workbook creator has links from other workbooks on his machine When I open the workbook it asks me do I want to update the links. Well I couldn't if I wanted to because I don't have the workbooks its asking about. How do I get rid of these warnings. I want to email my individual worksheets to my customers but I don't want them to see this Update message when it doesn't pertain to them (it's...

Picture in Publisher
When inserting pictures in publisher the picture does not show. I can see the frame. The same thing when I load a publisher file created by someone else. All the inserted pictures does not show. View>pictures is set to detailed display. Any suggestions for a solution? -- Thor Read the third FAQ here http://ed.mvps.org/Static.aspx?=Publisher/FAQs -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx "Thor" <Thor@discussions.microsoft.com> wrote in messag...

Linking with 3rd party DLL
I'm trying to link a command line based program with a 3rd party DLL. That seems to become an impossible mission. I get these error messages: LINK : warning LNK4199: /DELAYLOAD:CodeGen.dll ignored; no imports found from CodeGen.dll CCAcodegen.obj : error LNK2019: unresolved external symbol _CreateCodeShort3 referenced in function _main In my code i have this statement: extern "C" { const char* CreateCodeShort3(int level, const char *name, const char *encryption_template, unsigned long hardwareID, unsigned short otherinfo1, unsigned short otherinfo2, unsigned short otherinfo3, ...

Picture Link
Appreciate some help here and thanks in advance. I link my pictures to the following folders C:\Documents and Settings\MyName\Desktop\Picture.jpg C:\Documents and Settings\MyName\My Documents\Picture.bmp My code: If Me!pic1a = "X" Then Forms!startpg!fmpPic!Img.Picture = "" Else Forms!startpg!fmpPic!Img.Picture = Me!pic1a End If It works on my PC but when I copied the program to another PC, it does not work. This is because of "MyName" and the other PC has a different name. Is there a way to ignore "MyName" for any PCs Regards "ChoonBoy&quo...

Sending pictures with text and then another picture with text.
I receive some e-mails with text and then a picture with more text and again a picture. Some of these will have 8 to 10 pictures with text under each picture. But when I send it out it is received with all of the text in a group and the pictures are all sent as attachments. How do I get my e-mails to send the pictures and text the way I receive them? Thanks for any help you can give me. Bob ...

Picture in header
How do I get a picture in the header? This was added in xl2002. File|Page setup|header/footer tab|custom header There's an icon that looks like a picture near the far right. Steve wrote: > > How do I get a picture in the header? -- Dave Peterson If you are using a version of Excel before 2002 then check out: http://www.nwarwick.co.uk/Excel2000GraphicalHeaders.htm for a workaround. HTH Neil www.nwarwick.co.uk "Dave Peterson" wrote: > This was added in xl2002. > > File|Page setup|header/footer tab|custom header > There's an icon that looks lik...

Can pictures be centered in a picture frame in a catalog?
I have created a catalog for items we sell. I have added the pictures to the catalog through the Excel worksheet. When the worksheet is imported, all of the pictures left-justify in the picture frame. Can this be centered? ...

Link to Previous
my [Link to Previous] button is pale and unresponsive. i'm working on a Word document and want to change 'sections' as chapters change. You don't mention which version you are using, this can change the necessary instruction to solve problems. Usually the reason that the Link to Previous is grey is that either you are in the first section of the document, or that tha document only has one section. The following article has some good tips on using the Header/Footer area and what can be done within its area. http://sbarnhill.mvps.org/WordFAQs/HeaderFooter.htm ...

Create picture catalog from current product codes
Any one who knows how to create a catalog of pictures in a=20 spreadsheet, from a list of product codes, that=20 automatically adds the pictures from a specific product=20 code list and creates links from the product code to the=20 specific cell in which the picture is positioned. Thanks=A1 Hi Julio, Merge Pictures and Words - Oh My!, by Cindy Meister, creates a catalog from text wording and external pictures from an Excel database. [photos, photographs] http://www.computorcompanion.com/LMMArticle.asp?ID=126 Also see extracting JPG / GIF files from an Excel document (charts). htt...

attaching pictures as an icon
Hi I am trying to save memory in an excel report and I wish to include a picture in this report as an icon that shows the picture when selected. If you're going to try to save memory in the workbook, then it sounds like the big picture will be outside excel (a common LAN folder???). If yes, then maybe you could create thumbnails of each of your pictures (using ????) and then add a hyperlink to each thumbnail. The hyperlink would use whatever program is associated with the extension to open the big picture--outside of excel completely. (I don't know how you'd include the big p...

linking WinSCard.lib
i've got a dialog based MFC project in which i would like to call some PC/SC API functions directly. i'm experienced in writing smart card apps but not in MFC. how would i link the winscard library to make the functions calls possible? alexsd@gmail.com wrote: > i've got a dialog based MFC project in which i would like to call some > PC/SC API functions directly. > > i'm experienced in writing smart card apps but not in MFC. > > how would i link the winscard library to make the functions calls > possible? > MFC does not change the nature of linki...

picture in background show multiple images
When formatting a picture in background, it shows up as multiple images. How can I get just the one image? Thank you! My bad! Forgot about the 'master page' insert. "Anita" wrote: > When formatting a picture in background, it shows up as multiple images. How > can I get just the one image? > > Thank you! ...

Picture download to picture taken date folders
Maybe somebody could direct me to a proper newsgroup if this isn't it. When I download pictures from my digital camera, it stores them all in one folder. Is there a way that I could download them into folders that it created by picture-taken date? Ken W <KenW@discussions.microsoft.com> wrote: >Maybe somebody could direct me to a proper newsgroup if this isn't it. > >When I download pictures from my digital camera, it stores them all in one >folder. Is there a way that I could download them into folders that it >created by picture-taken date? No...

No longer able to view pictures in Publisher Document
I am creating a document with many inserted photos. Everything was fine until I opened it today. All the photo areas are blank (the frame is there, but no photo). I checked the View menu and Pictures, but everything was set correctly. Why did this suddenly happen? What else can I try so the photos can be viewed (and most importantly, printed)? TN I checked further down in the "problem list" and found Ed Bennett's solution to move the hardware acceleration down 3 notches for my video driver. That Worked. I can see the photos OK in my other publisher documents with ful...

change linked sheet name
Hi, I have Access programs that are linked to Excel spreadsheets. Due to circumstances beyond my control the sheet names have been changed and I will have to use the new names in my programs. I have tried to go into Link Manager but it does not let me change the sheet name only the file name. Does anyone know an easy way to change the Sheet name in a linked Excel spreadsheet without messing up the connections in queries etc. Thank you in advance for your help -- Nancy When you go to the linked table manager, click the button down at the bottom that say "a...

Picture referencing
I am currently trying to produce a spreadsheet and within it is the need for a database of pictures. The problem comes is that I need to be able to reference the pictures for use with VLOOKUP/HLOOKUP/IF. Can anyone shed some light on this issue. Richard, I will send you an example spreadsheet that does what you want. HTH, Bernie MS Excel MVP "Richard Riley" <richard.riley@consultant.volvo.com> wrote in message news:145301c3fbae$1db55450$a301280a@phx.gbl... > I am currently trying to produce a spreadsheet and within > it is the need for a database of pictures. T...

Dynamically build a link
Is it possible to have cell A1 be a hyperlink to a concatenation of what is in cells B1 and C1? Without VBA? Thanks! =HYPERLINK(B1 & C1,"Test") Cheers ...

Article Link?
Does anyone have a link to customer or partner source article for integrating SBA w RMS? I can not seem to find this. -- Jocelyn This is a multi-part message in MIME format. ------=_NextPart_000_0628_01C74B90.99C7CB10 Content-Type: text/plain; charset="Utf-8" Content-Transfer-Encoding: quoted-printable Jocelyn, There are a couple in the KB, http://tinyurl.com/22pwoj being the most = relevant. Careful though as there hasn't been an announcement yet for RMS 2.0 and = Office Accounting 2007 upgrades. --=20 Jeff=20 Check Point Software =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=...