Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: robz2009
  • Order by date
  1. robz2009

    Excel; conversion issue from MS Works

    Yes that will work.
  2. robz2009

    Excel; conversion issue from MS Works

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

    Referencing a .NET COM Class library (dll) in VB6; Compile error

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

    Connecting to a Sybase 12.5 DB

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

    Connecting to a Sybase 12.5 DB

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

    Connecting to a Sybase 12.5 DB

    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;" & _...
  7. robz2009

    ACC2000: DoCmd.OutputTo Current Object

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

    ACC2000: DoCmd.OutputTo Current Object

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

    Unable to DEBUG stored procedure: Client or Server setup?

    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'...
  10. robz2009

    XQuery: XML data in SQL Server

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

    XQuery: XML data in SQL Server

    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?
  12. robz2009

    XQuery: XML data in SQL Server

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

    New to VB.NET

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

    New to VB.NET

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

    Execl VBA: Workbook_BeforeClose Event

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

    Execl VBA: Workbook_BeforeClose Event

    I have created an Excel spreadsheet which calls a Stored Procedure which works fine but I want to put some additonal validation in the spreadsheet which will stop a user closing the spreadsheet if the procedure is still executing. I am looking to utilise the "Private Sub...
  17. robz2009

    Excel (Macro: VBA) - call Sybase Stored Procedure

    Ignore my last post, for some reason when I have closed the spreadsheet and stepped through the process it has successfully connected and called the stored procedure. Very strange! Thanks for all the input.
  18. robz2009

    Excel (Macro: VBA) - call Sybase Stored Procedure

    Ok, I have now got past the connection issues. This code works with no error. Dim con As ADODB.Connection Dim cmd As ADODB.Command Dim rs As ADODB.Recordset Set con = New ADODB.Connection Set cmd = New ADODB.Command con.Open...
  19. robz2009

    Excel (Macro: VBA) - call Sybase Stored Procedure

    I have tried the alternative of specifying the full connection string but still get the same error. So if I use, Dim con As ADODB.Connection Dim cmd As ADODB.Command Dim rs As ADODB.Recordset Set con = New ADODB.Connection Set cmd = New ADODB.Command con.Open "CODADEV" Or Dim con As...
  20. robz2009

    Excel (Macro: VBA) - call Sybase Stored Procedure

    Apologies, it must have been me being thick and overwriting the start of the sub routine. This now compiles, thank you. I do have a further issue though - it's still in relation to the post header so thought I'd contiune the post.... It now fails on this line con.Open "DSN" I get the error...

Part and Inventory Search

Back
Top