Search results for query: *

I eventually decided to use an array, coded the solution then looked in here for any replies. That was the very suggestion. Thanks for taking the trouble to reply.

I have a series of variables in a number sequence. Const strTest1 = "A" Const strTest2 = "B" Const strTest3 = "C" I am using a loop with a counter incrementing it. A simplistic example is shown below. intCounter = 1 Do... Msgbox strTest & intCounter intCounter = intCounter + 1 Loop I...

I have some code which sends an email through VBScript: 'create the email components, attach the zip file etc and send strSchema = "http://schemas.microsoft.com/cdo/configuration/" Set objConfig= CreateObject( "CDO.Configuration" ) With objConfig .Fields.Item( strSchema &...

20080312 1212 ...which later on becomes an archive file name (20080312 1212.txt)

But there are 4 scripts all with the same code and the only alteration has been to change the server name variables. Surely it shouldn't rely on chance if it's doing the same thing over and over?!!

The date formatting works fine and has no bearing on the other code than to name the file that is archived. Cheers for the advice though. I tried staggering the scheduled tasks every 2 minutes and it now works as it should do. WScript has its own process for each task so I cannot see why it...

Does anybody have any ideas? The WScript.Sleep seems to be the cause of the problem. It is set to sleep for 3600000 milliseconds and it all works fine when I run it manually. Surely I can use WScript.Sleep in a scheduled task?

I should of added that the scheduled task runs the performance monitoring part of the script but seems to stop when it reaches the update and edit of the outputted performance monitoring file: '-------------------- 'Performance Log File '-------------------- Dim objFile, objFileCopy...

I have created a series of VBScripts to run performance monitoring and input the data into SQL Server. It all works fine when I run each in turn manually. Whenever I schedule them to run at the same time then it fails. Have I got to stagger these in some way to get it working? Surely it should...

Thanks PHV. Should of known that... Doh!!!

I have a global variable set at the top of the module: Public GLBstrEFOLDERID As String I then have code within Sub AutoOpen() to do this immediately when the document is opened: Sub AutoOpen() Dim strReadLine As String If Dir("\\itax-dmdev2\SOAPDownload\Admin.txt") <> "" Then...

Sorry for sounding stupid but I'm not quite sure what you mean. It's early days for me with using CR. Could you elaborate a little? Thanks...

I have a series of linked tables. In addition to this is a user table which has no correlation or link to the other data at all. Within here I need to get the user name and a security id. I have a function which displays the user name so this data can easily be gathered. But I find having an...

I'm still having difficulty with this one. Any suggestions? Thanks...

The only thing I could come up with is fudging it a little. In SQL Enterprise Manager I created a view joining the two tables together in a standard select query: SELECT dbo.mSessions.eUsername, dbo.mSessions.mSOAPSession, dbo.OTHER.EFOLDERID, dbo.OTHER.Forenames, dbo.OTHER.Surname...

I have a sub report which links to the main report via an ID field and this works fine. The sub report brings up a list of documents and a http link to open IE and display that item. The problem is that I need to get the user name and a permission key from an unlinked table in order to view...

I have been trying to my figures to round correctly within Access. Example: (296/365) * 3.4 = 2.75726 Round to 2 decimals it should = 2.76 Round((296/365) * 3.4,2) sets it to = 2.75 Does anybody have any suggestions?

Is there any way of going back more by than one record (Previous())? The [USER] may be further down the version number list. Thank you: Table 2: == ======= ========== ======== ID VERSION DATE USER == ======= ========== ======== 02 01 01/01/2006 Admin 02 02 02/01/2006 System 02...

Thanks Ian. That has really got me thinking about things in a totally different way to what I had been doing previously. I was trying to chnge things using SQL rather taking everything on board and then formatting the page to suit my needs. With a little more hands on practice i'm sure I can...

I'm pretty new to CR and would apprecaite it if somebody could help me... Table 1: == ========= ======== ID USER FOLDER == ========= ======== 01 A Smith A123456 02 J Bloggs B123456 03 H Jones C123456 Table 2: == ======= ========== ======== ID VERSION DATE USER == =======...