Too many rows for Excel output from Access 2000
In my application I am exporting several records to excel file
dynamically using a query,when the number of records exceeds 50000 records
in one of the scenarios I am getting this error :There are too many rows to
output, based on the limitation specified by the output format or Microsoft
Dim stDocName As String
stDocName = "Query11"
DoCmd.OutputTo acOutputQuery, stDocName, acFormatXLS, , 1
Can any one suggest the solution to this problem,
Thanks in Advance,
IIRC, OutputTo uses an earlier Excel format that limits to 16K rows.
Use the TransferSp...Quirky recent file list #2
I do tend to open from Windows Explore more then File>Open. But I am
saving the file.
It's more that it is annoying when I close a file by accident and don't
quite remember where it got saved on the server.
SPenney's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1079
View this thread: http://www.excelforum.com/showthread.php?threadid=267592
Well, I guess you weren't the only one who wanted this behaviour
If/when you upgr...Opening a new instance of Excel
I am using multiple monitors for work and it is great! Is
there a setting that I can use so that it opens each new
excel file in a new excel window so I can drag different
ones to each monitor? Is there a similar setting for Word?
I am using Excel 2002 and Word 2002.
Yes, you can check the Windows in Taskbar checkbox in
Tools; Options. This is on the View tab for both Word
>I am using multiple monitors for work and it is great!
>there a setting that I can use so that it opens each new
>excel file in a new excel ...Auto sort dat when updated
I am not a novice with Excell, however I have never written a macro. I have
a worksheet that data can be updated on. That data transfers by formula to
another worksheet. I want the second worksheet to auto sort when data is
updated. I believe I need a macro to do this, but I don't know how to even
You can sort the data using formulae. There are lots of examples in
the archives if you do a Google search, but if you can't find anything
that suits then you will need to provide more details of what data you
have, how it is organised etc.
On Jan 13, 7:36=A0pm, bvander...Illegal operation error while printing EXCEL or WORD Files
I am facing an illegal operation error when i try to print any file from
excel (any no. of pages), this happens in stand alone printer as well as a
When we press the print button, it flashes this message, but still prints,
but once the printing is completed, i will have to restart the PC. Due to
this error other applications PRINTING also will NOT HAPPEN and the only way
out is, restart the PC.
This happens not only in EXCEL, it happens in all the MS applications
(outlook, access, front page, powerpoint also).
When I check the print manager (before restart),...how do I add times in Excel and result in hours & mins
I want to insert a time when I start work and a time when I take a break,
then a time when I leave work.
Following that I want to be able to add up the amount of hours that I have
This will enable me to plan my week ahead and ensure I only allocate a
specific amount of time to a project.
Microsoft MVP - Excel
"Rty Shaw" <Rty Shaw@discussions.microsoft.com> wrote in message
>I want to insert a time when I start work and...Importing Data into an Excel Pivot Table via Access
I have set up a query in Microsoft Access which is linked to our AS400
server. I have created pararmeters within Access which asks for certain
fields which works. I then go into Excel and create a pivot table with the
external data source that I have created in access. When I go to enter a
pararmeter within Microsof Query I get a reply saying that "Parameters can
not be used with this Query", what I want to do is setup a parameter on the
Excel spreadsheet which then goes and gets the data i require from this
parameter. I would be very grateful if someone could help me with thi...VBA from another app: Suppressing Excel confirmation dialog?
After creating/formatting several worksheets from MS Access, I'd like to delete
the "Sheetn" worksheets that got put there when I did a .WorkBooks.Add.
I avoided using them because I'm not sure how/why they are created - i.e. maybe
some user's defaults would only create 1 empty sheet or none.
So, form MS Access's VBA I'd like to do:
On Error Resume Next
On Erro...make column lists for select query.
I want to make column lists for some table listed in sheet1.
for example, select column_lists from table1
without vba is it possible?
I think you may want some dependent lists.
> table1 col1_1
> table1 col1_2
>...How do i get outlook to update hotmail account without reopening?
the tedster <the email@example.com> wrote:
Ask your question in the body of the message.
Without reopening what? Outlook? Hotmail? The short answer is "you
...How can I drop a flyer from Publisher into PowerPoint as a slide?
I have created a flyer in Publisher but I now need to drop it into PowerPoint
as a slide, is this possible?
No, not really. You could open up both instances, Powerpoint and Publisher,
and then drag and drop/copy and paste from the Publisher window to the
Powerpoint window, the reformat as needed.
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no rights.
"melann" <firstname.lastname@example.org> wrote in message
&...REPOST: Looking for how to use DTPicker
I am using Excel XP and am trying to use the date/time picker.
Is there a way to use this that will give me date AND time as a single
Is there a way (Or where can I get code to do so) to have the DATE/TIME
validated with OUTLOOK-Calendar to see if that DATE/TIME is free? I quess I
would need a duration as well?
Also posting this in OL and Excel groups...
Wrong newsgroup -- and most people don't answer pests who like to crosspost
like crazy. It is very inconsiderate.
"Newbie1" <newbie1@No.SPAM.com> wrote in message
news:Lthcc.191900$Cb.173228...Emailing in excel 2003 02-26-10
If i type in the cell A34: neil.Holden@test.com and press a button is it
possible to email to the address of what ever is in A34 is?
The email body should say: this has been submitted for cell B34 and todays
Check out Ron De Bruins "Send-Mail" tips:
"Neil Holden" wrote:
> If i type in the cell A34: neil.Holden@test.com and press a button is it
> possible to email to the address of what ever is in A34 is?
> The email body should say: this has been submitted for cell B34 and...re: updating values
that works, but i'll need to add a lot of hidden feilds (20+/-)...
Is there another way (perhaps more efficient -if not as simple?)
("there's more than one way to skin a cat")
"Daryl S" <DarylS@discussions.microsoft.com> wrote in message
> Mark -
> Add the field [PresetOption] to the form. You can set the .visible
> to FALSE so the user won't see it. Then the code...using GP with Cognos
Is it possible to map GP to a reporting tool like Cognos? If so, what would
be the easiest way to decipher to the data tables?
Thanks for your help.
The first thing is to install the SDK from the second CD. You need to explore
the disc and look for the tools folder then the SDK folder. When you install
the SDK, you will get a new item in your Dynamics program group. You will
have access to documentation on data flow.
Additionally, within GP you have the resource descriptions off the Tools
Richard Whaley has books that can help you, as well. Go to
www.accoladespublications....How can Journal be used if Project is not installed, or on the net
How can Journal be used if Project is not installed, or on the network
Network Support Technician
The Journal folder works without Project being installed at all. It's an
integral part of Outlook. What functionality are you seeking?
"Rusty" <email@example.com> wrote in message
> How can Journal be used if Project is not installed, or on the network
How can Journal potentially affect the Exchange server, and I would like more
information on Journal for a Outlook foundation class?
...Does anyone have a dashboard gauge (speedometer style) for Excel?
I am trying to create dashboard charts from Excel data and would love other
templates not available in Excel today - speedometer charts, multi-dimension
comparitive charts, charts that build information overlays.
I regularly create these in a manual way for executive and customer
summaries but would appreciate the ability to automatically generate these
types of charts allowing for real time viewing of "what if" scenarios.
Steve, there are tons of these things out there to review, few better than
Andy Pope has put together...graphing data
What is necessary to graph the number(s) in cell(s) when the number in that
cell(s) is/are generated from a formula in those cells?
Graph them in exactly the same way that would have done if the numbers had
been typed into the cells.
"mikaman" <firstname.lastname@example.org> wrote in message
> What is necessary to graph the number(s) in cell(s) when the number in
> cell(s) is/are generated from a formula in those cells?
...Copy filtered data
Let's say I have data in A1:Gxx. Now I use Autofilter to find all rows which has a "2" in column C. Let's say it leaves rows 1:4 and
8:10. Now I want to copy the filtered data in columns F:G and paste the values (not to an empty range which is easy) but to the same
cells in colums D:E.
Try Advanced Filter, excellent tutorial here from Debra Dalgeish, owner of
"Hans Knudsen" <Hans.Knudsen@mail.tele.dk> wrote in message
news:%23xtVdlR8FHA.740@TK2MSFTNG...Parent / Child Price Updates
Is there an add-on that will update the cost of a "child" item when the
"parent" item is purchased?
This is a multi-part message in MIME format.
This is what already happens! Whenever u do receiving by a parent, the =
child cost is updated!
This might happen to u if you have more than one item that is assigned =
to the same parent item, in this case, the cost of one child only will =
be updated, this's a bug that was reso...Getting List of Visible Windows
I am working on a problem that requires me to know whether or not any
part of a particular window is visible (even if it's like a one pixel
corner). In my misunderstanding, I thought that ::IsWindowVisible
would cover it, but it looks like that call just verifies that the
hWnd actually has a dialog box. I was able to take it a step further
and find out whether or not a window is minimized using
::GetWindowPlacement, but I really need to find out if a window is
visible or not (in other words, not completely covered by higher
Is there some sort of API call that ...Excel Crash
I use Excel and Word 2003 using Windows NT. I've kept some files on a jump
drive so I can work on them at home. I attempted to work on a Word documents
which had an Excel worksheet inserted in it. I tried double clicking on the
worksheet to edit it and Word and Excel shut down. Now when I attempt to
open Excel at home it asks for my Office XP Professional installation cd. (I
have Office XP at home with Windows XP). I'm having a hard time locating my
original discs. Does anyone have any suggestions or experience anything like
...EXCEL TROUBLESHOOTING #2
I have an excel file (2000 format), that after I made a
number of changes is causing me problems when I re-open
the file. Windows task manager goes to 100% CPU
activity, and i cant do anything within the excel file.
However, if I set recalculation to manual before I open
the file, all seems fine.
Obvioulsy I have a problem. But how do i find that
Thanks in advance.
I have had some experience running large spreadsheets lately. Above a
certain size, the recalculation time seems to climb very fast. While Excel
is recalculating, you can't do anything anyway.
Best in my v...Chart Stopped Updating
I have a number of DDE links that I use to increment Rows D to I every
second, providing me with a method of data logging my DDE Links.
I find that my chart works fine up to about 247 rows then stops updating.
I have just upgraded from 2003 to 2007 version of Excel.
when you saved into 2007, you keep the old file format or use the new format?
if using new, pls make sure you are using xlsm.
if you are using the compatibility mode, please check make to make sure you
click the security setting to low.
...Excel Edit F2 button changed for Mac???
Switched to Microsofts version of Excel for Mac. Can anyone tell me
what keystroke allows me to edit a cell? Before I switched to a Mac
it was the F2 button. Please help. Thank you.
See the answers in the m.p.mac.office.excel newsgroup.
In article <email@example.com>,
> Switched to Microsofts version of Excel for Mac. Can anyone tell me
> what keystroke allows me to edit a cell? Before I switched to a Mac
> it was the F2 button. Please help. Thank you.