Threads Replies Last Post 5 Pages: 1  2  3  4  5   How to Set How do I set Proj = Range "G2" value. This what I have and it doesn't work (tbl_ISProjects.GLCode In ('Proj')). In other words if "G2" = 06-000-340-000-900, I want the statement to read: (tbl_ISProjects.GLCode In ('06-000-340-000-900')). TIA Greg ... 2 23.06.2006 13:35:17 multiple web queries in one worksheet? i have generated 4000 .iqy files which query a specific table on a website. when i run an individual query, the data i want is extracted perfectly. i need to be able to combine all these queries into one worksheet and run them at once (or in batches of 500 or whatever number necessary not to overload the connection). it would be possible to narrow my query down to just one or items within th... 2 26.06.2006 21:47:46 How can I stop the "Query Refresh" dialog box from popping up? Hello, I would like to stop the "Query Refresh" box from popping up every time someone opens an excel file that has queries to external queries in it. I would like to set it to "Disable Automatic Refresh", and I can't seem to do it by altering the settings of the individual queries to not automatically refresh. I saw a fix to do it from within the registry, but I obviously don't want ... 2 24.06.2006 14:50:48 MS Query not getting all data I'm pulling data from a tab delimited tex file where one of the columns of results are set to format varchar. When I'm importing into Excel via MS Query/Pivot Table, I'm getting only the numeric values from this column - I'm missing some text values. How do I make sure I'm obtaining everything? ... 1 23.06.2006 18:20:34 Global query changes in large workbooks? Hi folks, I have a number of different workbooks, each sheet in each workbook set to query a webpage & pull data down for a local metro area across the states. The website has changed their design a bit adding an extra row on some pages, or extra verbiage on others, screwing up my formatting on each of these worksheets. An example of the data I pull down is on http://players.buzztime.... 11 18.06.2006 03:24:14 Refresh pivot table based on new query results I have a pivot table that looks at the results of a MS query to a MS Acess database. The pivot table does not change the range it is looking at when I refresh the query and new lines get added. The pivot table source data always seems to be locked. Like $A$1:$B$500. I remove the $'s in hopes that it would add the new lines to the pivot table source range but no such luck. Is there a way to... 4 15.06.2006 13:42:52 List Tables and Fields? Hi All.......... I'm relatively new to MSQuery. I have just been assigned reporting responsibilities on a new database that has about 1000 tables, and who knows how many fields. The Table names are all in abbreviations that are sometimes undecernable to the uninitiated. I would like to be able to see the list of Tables and their respective Fields, without "looking through a straw". Do... 2 11.06.2006 02:11:52 Relative Source Data for Query? How do I get my Query to pull data from a local copy rather than one on a different server? For example, if you have the same folder on two different servers: F:\UserApp G:\UserApp In each one, I have a copy of Sample.csv that I want to query from. So I set up a spreadsheet in F:\UserApp to query from Sample.csv and it works fine. I copy that spreadsheet to G:\UserApp and inste... 3 31.05.2006 18:52:02 Parameter queries? Hi, Using Excel 2003 and writing a macro to query a SQL 2000 Server. I'm trying to use a parameter but it's not working for me, can anyone tell me why? When I display the sql string in a message box it looks good except the question mark character isn't being replaced. Here's the code: ' Define the SQL query string strSQL = "SELECT DISTINCT pt.patient_id, RTRIM(pt.last_name) + ', ' ... 2 31.05.2006 08:37:03 Excel 2003 embedded in IE 6 crashes when refreshing data for Pivot Issue: My users develop Excel 2003 spreadsheets containing Pivot Tables connecting to SQL Server 2000 Analysis services and upload them into IIS6 web site to share queries. When they want to re-use a query they click on a hyperlink which opens Excel embedded within IE6 on their desktop. When they try to refresh either data or change one of the dimensions Excel throws an error and dies s... 1 28.05.2006 05:53:01 JJCC behind war and peace JUDAIC-JESUIT-CHRISTIAN CAPITALISM (JJCC) BEHIND WAR AND PEACE A discussion-group which deals in Sociological-Political-Economy and History to the present time and the future! In particular Sociology and Social Science are studies about the origin, development, organization, structure and functioning of society and the fundamental laws of social relations. Political Economy is a study abou... 1 15.05.2006 06:46:23 Excel 2000 pivot table problem In Excel 2000, I am working with the page header of a pivot table and trying to make multiple choices. In Excel 2003, I can do this, but in Excel 2000, I click on the dropdown, and I get a dropdown where only one item can be selected. Is there an option to make multiple choices available in the drop down of a page header or is this an Excel 2003 enhancement? -- *************... 4 13.05.2006 09:45:43 ASP.NET Application on a web site which in not a default web site. We have an ASP.NET application for which we created a set up program using DOT NET Setup Wizard. However, the set up programs installs the application on the Default web site only. Does any one know, how to deploy the application other than the default web site? Thanks for your time. shaht.... 1 01.05.2006 17:59:02 how to refresh query into new columns I am using a query to log data from a website. How can I have each refresh put the data into a new column next to the old ones? Is this possible with query? Mark ... 4 29.04.2006 02:29:00 Replace ^ in web query result I can't remember how to fix this. I am running a web query macro in xl2002. When I run in xl97 I get a caret ^ at the beginning of each cell. ^$.77 Sorry about multipost but few look at querydao TIA -- Don Guillett SalesAid Software dguillett1@austin.rr.com begin 666 Don Guillett.vcf M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..D=U:6QL971T.T1O;@T*1DXZ M1&]N($=U:6QL971T#0I.24-+3D%-13I... 1 26.04.2006 14:05:03 excel dao if i buy and install only excel, not office will dao or ado be installed to ? ... 2 25.04.2006 07:39:10 Make Money From Google Google AdSense is a fast and easy way for website publishers of all sizes to display relevant, unobtrusive Google ads on their website's content pages and earn money AdSense for search results pages use Google's search to provide relevant results, and the search results pages are customizable to fit with your site's theme https://www.google.com/adsense/?ai=BRRgZ9XRNRM... 1 25.04.2006 06:35:22 Pls help on creation on Pivot Field I have a table with these field headers Product/Status/USD:- A/Actual/100 A/Budget/90 A/Variance/10 I have created a Pivot Table with Product as row field (A or B) Status as Column field (Actual, Budget, Variance) USD as Value It looks fine like this but I need to create a column called Variance % which is (Variance/Budget x 100%). Please urgently advise how to create thi... 1 19.04.2006 11:23:02 for sale: internetDotComs.com domain for sale: internetdotcoms.com http://www.afternic.com/name.php?id=11866440 ... 1 16.04.2006 13:33:21 New Database Query When I click on New Database Query in Excel 2002 it tells me I need to install it. I put the CD in but it's looking for a file called PROPLUS.MSI which is nowhere to be found. Can anyone tell me where I can get this file? Thanks. ... 2 12.04.2006 09:34:30 QUERY WITH CELL VALUE.. Ok..from reading here I've discovered how to do a query using a cell value as a parameter. (query odbc datasource). However...I have a list of parts - so the parameter is different in each query. I figured I just put the query on each row - changing the parameter location. Well..the computer doesn't like this - I think I'm running out of memory or something. It gets to query 24 and giv... 2 06.04.2006 19:28:58 How to bypass Open macro when launching Excel 2003 Hi everybody ! Used to program Excel macros (VBA) on window's 2000. I have several applications progammed to get rid of most menu bars and others at opening and construct by programmation my owns for the benefit of the user.and for protection of the programming When application needs to be updated (once a year ) I use the <shift> key to bypass the OPEN macro and acces all menu ... 1 05.04.2006 16:50:26 Connection string I am connecting to a SQL Express database from Excel 2K. I have three connection strings examples. The first two work however the third was the one I wanted to use as I do not want to specify a local db. These two work fine: strConn = "PROVIDER=SQLOLEDB; DATA SOURCE=(local);INITIAL CATALOG=IPS; Trusted_Connection=yes;" strConn = "PROVIDER=SQLOLEDB; DATA SOURCE=(local);INITIAL CATALOG=I... 2 04.04.2006 07:49:18 msquery odbc --> excel repeats query on return [excel 2003 sp2, postgresql odbc driver 8_01_0200] When I use MS-Query to get data from my postgresql server via odbc, the query succeeds and displays in the msquery window. But when I say "return data to excel" it re-runs the query. Is there some way to make it just pass what it has instead of re-executing a sometimes lengthy query? [if this is the wrong forum for this, please forgive ... 2 03.04.2006 19:27:51 connect to sql Excel 2000, 2003 I've built an app that connects to sql and does various things. On some machines it works just fine, on other machines it throws an error. The error occurs when I attempt to connect to sql. The error is: Run-time error '-2147467259 (80004005)'; Automation error Unspecified error My connection code is below. Sub Connect() Set rs = New ADODB.Recordset Set ... 10 03.04.2006 09:15:35 5 Pages: 1  2  3  4  5