Search results for query: *

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 &...

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...

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...

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?

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 == =======...

Version: MS Windows XP Pro SP2 (all updates installed to date) All of sudden I have started having problems on the Welcomelogon screen. All of the users appear on screen and I can bring the password box up. But there is no cursor in the password box and you cannot type the password. The account...

I'm having problems with this function. For some reason it fails on the line: strMerged = Mid(strTotal, 1, intPosition - 1) & Mid(strTotal, intPosition, 3) My entire function: Function RoundN(curTotal As Currency, N As Integer) As Currency Dim strTotal As String Dim intPosition As Integer...

Within my code it checks various things onscreen and places resulting values in text boxes (not the best solution but it works). Within the query it points to these text boxes for it's criteria: [Forms]![Output Utility]![valCriteria] The problem is that I want to send the text values "Is Null"...

I'm creating an array but I don't know how many values are going to go into it. Is it possible to leave the array open so that values can be added to it as and when they occur?

I have a Do While -> Loop in my code. I am using the loop counter to adjust objects inside the loop. So in a simplified way: Do While intCounter <= 4 'example 1 .Fields("PostCode") = Trim(rs1.Fields("ADDRESS" & intCounter)) 'example 2 strOnHold & intCounter = Trim(rs1.Fields("ADDRESS" &...

Hi there, I'm having real problems updating a field through VBA. I get the error message 3027 saying that it is read only. There are no read only issues with the database etc, I think it is the query using joins that causes the problem. Has anyone any suggestions about how to get around this...

I'm trying to use a sql query string in VB and then create a find duplicate query on that. I've tested the first query (MyQuery1) and that works fine but it's the find duplicates query (MyQuery2) that brings up the error. I've tested the find duplicates query (MyQuery2) with a simple SELECT...

What I am trying to do is call the first query string (MyQuery1) that has been created within the second query string (MyQuery2). So as shown below in MyQuery2 I want to use the previous recordsets results (rst2) in the SQL string rather than a named table or query. Is this or something similar...

Could somebody please help me with this query before I go mad! This is the first query example. It brings up a list of records and in there are records with the same Quest_ID so there are matching related records in there: SELECT * FROM tbl_Questionnaire LEFT JOIN tbl_Question1 ON...

I have two servers HSGNT1 and HSGNT2 on an active directory domain. HSGNT1 is the live server on MS Windows 2000 Server. It is a database server (MS SQL Server 2000) and also acts as a file and print server. HSGNT2 used to take data backups from the HSGNT1 database server. I have rebuilt this...

I am migrating one of our servers (not PDC or BDC - used for SQL Server, dept applications and printers) from Win2K Server to Win2003 Server. Obviously the plan is to copy over the relevant data etc to the new server, take the original server offline and give the new server the name and IP of...

I'm trying to help a friend so all I know about the system is that it's WinXP Home but not sure which service packs are installed. It also uses NTFS. The person tried using restore to go back to a previous date but now the computer hangs just before the login window. I tried repairing WinXP...

My operating system is: WinXP Pro SP2 All of a sudden my HP 950C DeskJet printer has started printing the standard test page following the regular print job. This happens every time I try to print. I have tried reinstalling the drivers but this makes no difference. I have tried the official...