Replies

Hi John, thank you for your reply.

The task does remind , but the query is run on aknowledgement of the task, not directly by the user.
So all she does is complete the task, the rest is done by Access.

I’ll have a look into automation thriugh Access direct, onceagain thanks.

I have a task in Outlook 2007 which runs an Access query.
The user of that machine completes the task every time she turns on her PC on each morning.
The task puts a text file on the server which I can access from 10 miles away.

My question is, can I automate this task instead of the user having any intervention.
This way, I can possibly have the task run every hour or so in the background.

I’m not used to Outlook so any help would be appreciated.

I have a task in Outlook 2007 which runs an Access query.
The user of that machine completes the task every time she turns on her PC on each morning.
The task puts a text file on the server which I can access from 10 miles away.

My question is, can I automate this task instead of the user having any intervention.
This way, I can possibly have the task run every hour or so in the background.

I’m not used to Outlook so any help would be appreciated.

I have a task in Outlook 2007 which runs an Access query.
The user of that machine completes the task every time she turns on her PC on each morning.
The task puts a text file on the server which I can access from 10 miles away.

My question is, can I automate this task instead of the user having any intervention.
This way, I can possibly have the task run every hour or so in the background.

I’m not used to Outlook so any help would be appreciated.

I have a task in Outlook 2007 which runs an Access query.
The user of that machine completes the task every time she turns on her PC on each morning.
The task puts a text file on the server which I can access from 10 miles away.

My question is, can I automate this task instead of the user having any intervention.
This way, I can possibly have the task run every hour or so in the background.

I’m not used to Outlook so any help would be appreciated.

I have a task in Outlook 2007 which runs an Access query.
The user of that machine completes the task every time she turns on her PC on each morning.
The task puts a text file on the server which I can access from 10 miles away.

My question is, can I automate this task instead of the user having any intervention.
This way, I can possibly have the task run every hour or so in the background.

I’m not used to Outlook so any help would be appreciated.

I have a task in Outlook 2007 which runs an Access query.
The user of that machine completes the task every time she turns on her PC on each morning.
The task puts a text file on the server which I can access from 10 miles away.

My question is, can I automate this task instead of the user having any intervention.
This way, I can possibly have the task run every hour or so in the background.

I’m not used to Outlook so any help would be appreciated.

I have a task in Outlook 2007 which runs an Access query.
The user of that machine completes the task every time she turns on her PC on each morning.
The task puts a text file on the server which I can access from 10 miles away.

My question is, can I automate this task instead of the user having any intervention.
This way, I can possibly have the task run every hour or so in the background.

I’m not used to Outlook so any help would be appreciated.

Hi Mark

Apologies, the project is VB6.

The timer doesn’t seem too much of an issue, but it’s the inactivity that is important.
I can set the timer to fire and refresh every hour or so but I don’t want the refresh if the user is using the form.

I found this example:
http://www.vb-helper.com/howto_inactive_timeout.html Inactive
Which is ideal for my purpose, but I just can’t register the control and the instructions are not forthcoming.
Maybe I’m missing something, any help would be very very useful.

Again, thanks for the reply.

A couple of things really.
One is I can’t set any format, ie [BKI_DTE] is a book in date which I would like to set as =Format$([BKI_DTE],”ddd-dd-mmm-yyyy”,0,0) in a report.
So really the conversion needs to take place in the make table query.
I get circular reference error if I use “BKI_DTE: DateValue(Left(BKI_DTE,10))”

Thanks for replying.

Hi Wendell.
Yes I didn’t mention the table is linked to a text document and the delimiter is a comma.

Appologies

Is this what you needed:

& vbCrLf & _

Used like the following example:

strMsgPrompt = “Confirm Selection” & vbCrLf & _
“Selecting This Option Will Over-Write” & vbCrLf & _

As ever !! perfect !! Thanks again…

I’ve been trying to do this for ages.

Cheers Hans

Works great :))

I have taken a different approach to this.
Instead of creating a folder via FTP I have changed the load up script to create it instead.
Each time the user loads the software it checks to see if “L:MMPDFTransfer” exists, if not then create it.
The transfer sequence of the individual files is good and works perfectly.

I now need to count the number of files in that folder that begin with a specific number ( dependant what file the user is looking at).
With the following code, a file count is successful, but it counts all files and not just files that begin with strLeft5.
Where do I put strLeft5 to count only files it refers to?

Many thanks for the help.

Dim fso As New Scripting.FileSystemObject
Dim fld As Scripting.Folder
Dim strPath As String
Dim strTrans5 As String

strPath = “L:mmpdfTransfer”
strTrans5 = Left(Me.txtEst, 5)

If fso.FolderExists(strPath) Then
Set fld = fso.GetFolder(strPath)
If fld.Files.Count > 0 Then
Me.txtTrans.Text = fld.Files.Count

End If
End If
Set fld = Nothing
Set fso = Nothing