SOFTWARE for SALE!!!???????????????????????????????????????????????????????????????? 102564
Friday, 23 Nov 2007 05:26:46 -0600
Software for sale. Huge Selection. 10 Euros/CD. Worldwide shipping.
Windows, Mac, and Linux. The very latest software, stock video/photo, games, etc.
Contact David for details:
david007@worldnewstonight.net
...
|
UPDATE: How to use a union query in access as a data source for a
pivot table
Thu, 22 Nov 2007 04:09:15 -0800 (PST)
Hi Everyone,
This is an update to the system I outlined in the post at:
http://groups.google.co.uk/group/microsoft.public.excel.querydao/browse_thread/thread/1ca76034adc10c1a/204261bda38c118c
which deals with pulling in data from a union query in access through
to a pivot table in excel.
The instruction ...
|
Problem Seeing Headers...
Fri, 16 Nov 2007 09:20:46 -0800 (PST)
If I use the "as" function, the output does not include the "as"
header like it would if I ran the same query in sql. This is
particularly irksome when the column returns a result, like "count",
and the header is blank.
I'm using excel 2003 to query a sql database.
Anyone encountered this? Got any tips?
...
|
autorefreshing query table (Excel 2000)
Fri, 16 Nov 2007 16:33:06 +0100
Hi,
I have a query table with marked option: refresh data at startup (more and
less - sorry for my translation).
Normally there is a warning message when I open a file with autorefreshing
query tables (or pivot tables) and I can choose to refresh or not.
Unfortunately I switched this warning off and I have no ...
|
Query Wizard Problems
Mon, 05 Nov 2007 09:45:29 +0000
Hi there,
I have an Excel 2003 user who is using a spreadsheet that pulls data
from our SQL server.
When he opens it and refreshes that data it is fine, it pulls the
current data, but when he tries to edit the query, the Query Wizard does
not appear, he can see it on the task bar, but when he switches focu ...
|
SQL & Like and parameters
Thu, 01 Nov 2007 10:54:13 -0500
I would like to have the operator prompted for a "like" value. For
instance, I would like the operator to be prompted to enter the word
PUSH if the description field contains PUSH anywhere in the
description.
This is a query using microsoft query which returns data to excel.
For normal parameter queries you en ...
|
Microsoft Query gets stuck with more than one parameter
Wed, 31 Oct 2007 09:36:36 -0000
Hi:
I have an Excel 2003 workbook that uses a Microsoft Query to query an
Access database. I there are two parameters in the same spreadsheet
and the query is set to refresh based on these parameters changing.
Those parameters are a start date and an end date.
I have found that the following happens. Let's ...
|
|
|
ODBC Text Driver not picking up fields
Fri, 28 Sep 2007 18:07:39 -0000
I have a tab delimited text file and am trying to use ODBC to connect
to the text file and pull values into an Excel file. The code I have
so far doesn't seem to be picking up the field headers. It'll run
when I take off the criteria, but will break when it comes to the
first specific query for a fieldname. H ...
|
Report Model as Data Source
Thu, 27 Sep 2007 13:59:02 -0700
Can Excel use a "Report Model" (Reporting Services) as data source?
Thank you, ...
|
DAO.CreateWorkspace() fails in Add-in with Excel 2007
Wed, 29 Aug 2007 05:48:00 -0700
We have a VBA Add-in component that we've used for a long time. Our users
have recently begun to report that the component no longer runs once they
install Office 2007.
We have always created an ODBC workspace as in the following:
DIM workODBC As DAO.Workspace
Set workODBC = CreateWorkspa ...
|
