Recent content by robz2009

Yes that will work.

I am looking to convert a large batch of Microsoft Works files (.xlr) to Excel but have a small problem. I can simply open the .xlr in Excel 2003 but the currency fields are coming out as dollars ($) when they were originally sterling (£) in the .xlr. My regional settings are all UK so if it's...

I am attempting to use a VB.NET Com Class Library in a VB6; Standard exe application but when attempting to call one of the functions I get the error "Variable uses an Automation type not supported in Visual Basic". The source code for my .dll (VB.NET) is this, Imports Oracle.DataAccess.Client...

I have now managed to fix this. The fix is to replace the Srvr parameter with NetworkAddress. The working connection string is, conn.Open "Driver={SYBASE ASE ODBC Driver};" & _ "NetworkAddress=wwhbsdb1,5555;" & _ "DB=AML;" & _ "Uid=myUsername;" & _ "Pwd=myPassword" I managed to find this after...

It was initially IP address and port in the format of *0.*34.*2.*1,5555; I thought this was causing problems hence using the server name. For purpose I have just tried it with IP address and I get exactly the same errors :( P.S. Reading various resources online it states that "{SYBASE ASE...

I am having problems connecting my Visual Basic 6 project to a Sybase 12.5 database, I want to code it so that a DSN is not needed. When using this code, conn.Open "Driver={SYBASE SYSTEM 11};" & _ "Srvr=wwhbsdb1,5555;" & _ "DB=AML;" & _ "Uid=myUsername;" & _...

I simply typed the same report name and it referenced the open report, works a treat. I'm assuming it was an Access 2000 limitation? DoCmd.OpenReport "Rep_SIQuery", acViewPreview, "Qy_SIQuery", "CallID = " & pubCallID DoCmd.OutputTo acOutputReport, "Rep_SIQuery", acFormatHTML, "C:\Transaction...

I am working on a task to save reports to files and then send in an email which has been working ok but I have a problem with the DoCmd.OutputTo command. I have searched extensivley on the net and it seems that you cannot apply a filter to the DoCmd.OutputTo like you can when using...

We have an issue on some client PC's here that when attempting to debug a stored procedure in SQL Developer we get the following error… Connecting to the database UAT. Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '1*5.2*4.2*5.202'...

You have also changed the text being populated in my @xml variable? The tag for PasswordLengthMax has changed from. <PasswordLengthMax xmlns="urn:travelex.global.enterprise.service">50</PasswordLengthMax> to, <PasswordLengthMax xmlns="@xml">50</PasswordLengthMax> Please explain so I can...

That works thanks, I'd like to understand the solution also. Why do you have two select statements? What is the difference between one and another?

I'm trying to use Xquery to extract specific info from XML tags but I can't get it to work, all I get is a NULL result. I don't know if the problem is with how the source XML is formed or my xquery statement. My statement is, DECLARE @xml xml SELECT @xml = PasswordPolicy FROM role SELECT...

I have just realised I meant app.config and not web.config in point 2. I'd still like some advice on how I create this from scratch for a new VB.net application.

I have been asked to create a VB.net application which will download files from an https website to a location on our internal network. The files to be selected for download will be held and maintained in an Oracle database table. I will also need to include some error handling and generate...

Thanks as I have now created a module and declared the variables as Public, Public con As ADODB.Connection Public cmd As ADODB.Command Public rs As ADODB.Recordset This is now being picked up by my Workbook_BeforeClose event. I still have a couple of problems, 1. The event is...