Recent content by Phoenix22

Hi, Is there a way I could join two tables on fields that are similar (i.e. using the "like" operator instead of = ?) I'm trying to join two tables, but due to inconsistent data input, it's not joining many records because there's extra words or extra letters added to the end of the field...

Hello, I'm receiving the following error message when trying to create an ODBC data source: Connection failed: SQL State: '01000' SQL Server Error: 1326 [Microsoft][ODBC SQL Server Driver][Named Pipes]Connection Open(CreateFile()). Connection failed: SQL State: '08001' SQL Server Error: 1326...

Hi, I'm getting an error when re-starting my workstation to complete a software installation: "Disk I/0 Error: Status 00000001 - Windows NT could not start b/c the following file is missing or corrupt: \WINNT\System32\C_1252.nls" I've checked support.microsoft.com, it says the decrease the...

Hi, When I have the following SQL statement: SELECT * INTO backup_table FROM orig_table; The statement executes, but I don't see "backup_table" created anywhere, and when I refer to "backup_table" in another separate SQL query, I get an error message saying the table doesn't exist. Does...

Hi, Is there a way I can remove the "," in a column of numbers so that 1,234 would appear in the table as 1234? Thank you in advance.

Hi, How can I write the "where" clause of a query when I want to extract all records with a COST_DATE of 2004-04-13 where COST_DATE is of type datetime? I tried: where COST_DATE like '2004-04-13%' and it doesn't work. Thank you for your time.

Hi, Do table names have to be prefixed with "dbo." in queries that are written in Query Analyzer? Very often when I execute queries, it complains that the table doesn't exist even though it is part of the DB I am querying. I also mistakenly renamed a table as dbo.dbo.table_name when it...

Hi, I'm using DTS in Enterprise Manager to import data from an Excel file to a table. When I preview the data I'm importing, the data range is correct. However, when I finish importing, my table is empty. After the actual importing, I get one notification that says the data and table were...

Hi, Could someone please tell me the VBA code I could use to loop through a series of tables of Access? Thank you in advance for your time and help.

Hi, Thanks for your reply. I've already done 1 & 2 and my code still doesn't compile. I'm using an IDE (Netbeans) and my class path is set to the package path, ie. ca. However, I'm still getting the unresolved symbol error message below: ToolV1/Calculator.java [14:1] cannot resolve...

Hi, I keep getting an error message when I'm compiling a class that implements an interface: ToolV1/Calculator.java [14:1] cannot resolve symbol symbol : class CalculatorInterface location: package ToolV1 The class I'm trying to compile is as follows: *********************** package...

Hi, Is there a way I could make Excel retain the value of a global variable? I have 3 macros: * macro 1 gets the file name (declared as a global string in the declarations section i.e. Public filename as String) * macro 2 & macro 3 need to use the file name obtained in macro 1, but each...

Hello, I wrote a macro last week (which worked fine). Now when I run it, I keep getting the "Access violation at 0 x c000005" error message. The code screws up at the following line: ActiveCell.FormulaR1C1 = average_formula I've tried subsituting the above with the below and it...

Hi, When I'm changing the source data of my pivot table (using the Wizard) and click finish, I get an error message "Pivot Table Cannot Overlap Another Pivot Table", and thus my pivot table does not show the new source data. How could I get rid of this problem? I need the pivot...

Hi, I have a worksheet with a pivot table. There is a drop-down select button for the pivot table, where the pivot table contents change depending on my selection. Is there a way I can protect the sheet (i.e. make the other cells locked/unchangeable), but still allow the user to select from...