Search results for query: *

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

Hi, Is there a way to suppress the Excel dialog/notification boxes that pop up asking the user to confirm or accept something (i.e. a box that pops up asking the user if they really want to delete a sheet or enable macros, etc)? I'm writing a macro and would like to avoid having the user...

Hi, I'm making a chart in Excel 97 where one column value must always be selected from a drop-down list. How can I make a drop-down list that automatically resizes with the row height and ensure that only the *value* of the drop down list shows up when I print the spreadsheet (as opposed to...

Hi, Is there a way I could execute an Excel Macro by clicking a button on an Access form? Thank you for your time.

Hi, I've exported data from Access to Excel. The data I've exported is from a combo box in Excel, and at the end of each line, there are weird formatting symbols (a black rectangular box). When this text is exported to Excel, weird squares show up at the end of each piece of text, as well...

Hi, I'm trying to automatically open a file in Access using: Application.GetOpenFilename However, it doesn't work; is there another VBA command I could use? Thank you for your time.

Hello, Does anyone know how I could use VBA to copy a table (row headings and content) in Access to a spreadsheet to MS Excel? Thank you in advance.