A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Rename Image File - Skip



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old October 7th, 2004, 11:27 PM
j.t.w
external usenet poster
 
Posts: n/a
Default Rename Image File - Skip

Access 2000.
Windows 2000 Pro and Windows XP Pro Desktops.

I have a subform (on a form) that displays a tif image. As I rename
the image, the image is renamed and moved to another file location and
the next image is displayed for me to rename. So far this works
correctly. The problem that I am having is that sometimes I come
across an image that I do not want to rename (and move). How do I move
to the next image? It seems as though the order the images are being
selected are by the date it was created.

Basically, I would like to "skip" (or disregard) the current image and
move to the next.

Could someone please let me know if this is even possible and how I
should go about solving this problem?

Here is a short version of what I have...

Private Sub cmdRenameFile_Click()
Dim strSourcePath As String
Dim strDestinationPath As String
Dim strExt As String
Dim strDir As String

strSourcePath = "\\ServerName\Images\"
strDestinationPath = "\\ServerName\Images\Renamed\"
strExt = ".tif"

strOldName = strSourcePath & txtCurrentName
strNewName = strDestinationPath & cboNewName & strExt

‘Rename the file.
Name strOldName As strNewName

‘Get the next file.
strDir = Dir(strSourcePath & "*.tif")

Forms!Rename_Files_frm!Rename_Files_subfrm.Form.im gDocument.Picture =
strSourcePath & strDir
txtCurrentName = strDir
cboNewName = ""
End Sub

Thank you in advance for any and all help.
j.t.w
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i paste a jpeg file onto microsoft word endoaccess General Discussion 23 September 8th, 2004 04:11 AM
Upload Image Jason MacKenzie General Discussion 1 September 1st, 2004 04:38 AM
Jet35.sp3 doglover Database Design 3 August 26th, 2004 04:41 PM
Importing pst file doesn't bring in my calendar and contacts Jackie Contacts 6 August 5th, 2004 02:40 AM
GPO Office 2003 Tony Setup, Installing & Configuration 1 May 12th, 2004 10:42 AM


All times are GMT +1. The time now is 04:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.