Replies

It took me awhile but I found some usefull batch command variable examples on the net.

@echo off
set var1=Hello
set var2=World
echo %var1% %var2%!
set var1=
set var2=

Regards,
John

Chirs,

Do you know if Robocopy is capable of file compression? I would like to compress the file, move it to a new location and decompress on the other side.

I have a large number of files in size where compression seems the right choice.

Thanks,
John

I don’t see where you specify Text as data type (in Access 2002 the data type is next to the field name).

Han’s,

I’m using Access 2007. Here is another screenshot.

Regards,
John

What are you importing into? That is, is it creating the table or is it an existing table? What is the data type of the field it is importing into? I’m guessing it is numeric.

Hans,

Here is a screen shot of the import settings.

What are you importing into? That is, is it creating the table or is it an existing table? What is the data type of the field it is importing into? I’m guessing it is numeric.

The import is going to an existing table whose field’s data type is set to text.

Regards,
John

Hans,

Thank you for pointing it out to me as I overlooked it.

John

Don/Hans,

Thank you for your suggestions.

John

Here is an alternative solution to what Chip Pearson posts; tests an infinite loop on the processID and waits until it finishes prior to running the next line of code. I took bits and pieces from Chip Pearson and others to reduce the amount of lines to what you see below.

[codebox]Public Declare Function OpenProcess Lib “kernel32” _
(ByVal dwDesiredAccess As Long, ByVal bInheritHandle As Long, _
ByVal dwProcessId As Long) As Long

Public Declare Function WaitForSingleObject Lib “kernel32” _
(ByVal hHandle As Long, ByVal dwMilliseconds As Long) As Long
Public Declare Function CloseHandle Lib “kernel32” (ByVal hObject As Long) As Long
Public Const SYNCHRONIZE = &H100000
Public Const INFINITE = &HFFFF

Sub Start()
Dim lngRtn As Long
Dim lngProID As Long
Dim lngProHn As Long

‘Process 1st SHELL call
lngProID = Shell(“Enter your shell statement here”)
GoSub Continue_Process_Check:

‘Process 2nd SHELL call
lngProID = Shell(“Enter your shell statement here”)
GoSub Continue_Process_Check:

MsgBox “Finished”
Exit Sub
Continue_Process_Check:
lngProHn = OpenProcess(SYNCHRONIZE, True, lngProID)
lngRtn = WaitForSingleObject(lngProHn, INFINITE)
lngRtn = CloseHandle(lngProHn)
Return
End Sub
[/codebox]

Regards,
John

I found what I was looking for [post=”638395″]here [/post] in the Lounge.

Regards,
John

Chris,

Do you know of a GUI calendar interface (free) that I can incorporate into the batch file. This is what I am trying to achieve:

1. Open GUI calendar
2. Select appropriate YYYYMMDD
3. Pass this variable (in item #2) to the batch file
4. Process batch file

Thanks,
John

Chris,

Thankyou for the suggestion. I’m a happy camper…

John

I swear by RoboCopy.

Thanks Hans,

I found the post and will have to give it a try.

Regards,
John

Hans,

I would prefer it to be in a “batch file’ as the batch file can be schedule to run.

Regards,
John

Hans,

I would prefer it to be in a “batch file’ as the batch file can be schedule to run.

Regards,
John

OK, I’ll move it to Windows XP. Hopefully BATcher will know how to do this.

I thought about putting it under Windows XP but then “Coding” sort of jumped out at me.

Feel free to move it.

Regards,
John

Is it possible to move files based on the date stamp of the file(s)?

I have a number of files that I would like to move (based on dates) to an archieve.

As an example: Move *.xls with a date stamp <= April 30, 2009

Thanks,
John

And here I thought you were a Ghost Writer…

Sorry you’re right. I meant to post in reply to this post.

I’m having trouble hitting the right spot on the little iPhone touch screen.