Search results for query: *

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

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

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

I have an Excel workbook with four sheets inside and each one contains the results of a Database query I have setup. The way the table is populated is via a stored procedure in Sybase. I’d like to amend the spreadsheet so that it calls the stored procedure, I can then refresh the queries and the...

I have been doing some research in regards to the FindStr command and think I can use this to get the information I am after. I have a text file which is approx 200,000 lines and I only wish to extract the lines which contain particular text (as well as the subsequent line as this contains a...

I have an issue on a user's PC which is causing knock-on effects for an in-house Access Database. I have investigated and I’m 99.9% certain the issue is with security setup in Access 2000. When Iaccess the menu option Tools > Security > User and Group Accounts - all the information is blank...

My background is Oracle and SQL Server but I am now using Sybase and the SQL tool provided is SQL Advantage. For some reason I cannot write joins in the new ANSI standard? I can’t see any problems with my syntax. This works, select b.el1,b.curcode from oas_grplist g, oas_balance b where...

I seem to have an issue where the open function in javascript is always opening new popups even though the window name is setup in the parameters. To add further confusion this is only happening on certain PC’s. I have tried in vain to see any differences but the Operating System, Browser and...

I have an issue with certain machines duplicating a popup window called from another asp page. I have tried to amend the code to output the variable to the screen to investigate further but if I make any amendments the code is simply ignored. I know a little vbscript but nothing in regards to...

I am in the process of converting an Access 2.0 database to Access 2000 and am trying to strip a lot of the functionality (basically to streamline it and make it less complicated). I would like to remove most Macros but now when attempting to open a form I get the error, “Run-time error ‘2485’...

I am currently migrating an Access database and trying to iron out a lot of bugs and make the application run smoother. I am sure there is a way where you can lock the current form so that a user cannot switch back to previous forms loaded in the background. I do recall a property which can be...

I have seen loads of posts in regards to Error 2105 “You can't go to the specified record.” And have tried the workaround setting the focus on the subform and then the control on the subform but I am still stuck and really struggling to find a solution. The issue in question is a report which...