472,981 Members | 1,113 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,981 software developers and data experts.

Number of records found

Good day,

I am not sure if this is the right forum for this question, but would
appreciate any help.

I have a spread sheet with a lot of rowws in, about 5000 and before i
deleted a lot i had 9000.
The question is that when i filter by a certain criteria, i get a
message at the very bottom of the spreadsheet saying; "500 of 9540
records found".
Can a person change this or is this something that Excel does itself ?

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
5 1524

"Les Stout" <le*******@bmw.co.za> wrote in message
news:40*********************@news.frii.net...
Good day,

I am not sure if this is the right forum for this question, but would
appreciate any help.

I have a spread sheet with a lot of rowws in, about 5000 and before i
deleted a lot i had 9000.
The question is that when i filter by a certain criteria, i get a
message at the very bottom of the spreadsheet saying; "500 of 9540
records found".
Can a person change this or is this something that Excel does itself ?

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


This is an Access forum, not an Excel forum, so you're fear is correct. Why
do you have so many rows in your spreadsheet?
Nov 12 '05 #2
Thank you for your reply, this is a spreadsheet generated from various
main frame db2 systems.
It is extremly big,i actually break it into smaller pieces and pul it
into access as i have to create certain comparisons and graphs. I break
it up as if i pull the whole thing in i get errors.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3
Les Stout wrote:
Thank you for your reply, this is a spreadsheet generated from various
main frame db2 systems.
It is extremly big,i actually break it into smaller pieces and pul it
into access as i have to create certain comparisons and graphs. I break
it up as if i pull the whole thing in i get errors.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Excel is possibly the single worst POS for handling data there ever was,
great spread sheet, but really crap for data. even if you get the number
of rows right you'll bound to end up with data type errors. IME it's the
worst thing to use as an intermediary data transfer program. Consider
ASCII files (CSV, fixed length.
Nov 12 '05 #4

"Les Stout" <le*******@bmw.co.za> wrote in message
news:40*********************@news.frii.net...
Thank you for your reply, this is a spreadsheet generated from various
main frame db2 systems.
It is extremly big,i actually break it into smaller pieces and pul it
into access as i have to create certain comparisons and graphs. I break
it up as if i pull the whole thing in i get errors.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Well, you need to explore other possibilities. Good luck.
Nov 12 '05 #5
Thanks for the help, much appreciated

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: amywolfie | last post by:
Hi All: In FileMaker Pro, the error number for "no records found" is 401. What is the equivalent error number in Access (2003)? I want to capture for the "On Open" Event of a report. If...
2
by: chris vettese | last post by:
I've been searching for a few days and have't found the solution I'm looking for. I want to create the following in my form's header...Material: 1 of 15. The first number will change as the user...
7
by: astro | last post by:
Anyone have suggestions on where to troubleshoot this error? Background: -Access 2k v. 9.0.6926 sp3 - front and backend on production server (wiindows 2k) -accessed via Citrix -front-end is...
2
by: Mike N. | last post by:
Hello- I have a database that uses an auto number field type that goes out of sync periodically. My customer gets a "cannot add record, number already in use" error message. I dump the records...
4
by: Greg Strong | last post by:
Hello All, Is it possible to create multiple random numbers in a query where there are numerous records? I've created a custom function. When I use it in a query it creates the same random...
4
by: Tim T | last post by:
Hi, I have a stored procedure executing a search and an asp.net page displaying the results in a datagrid. The datagrid has paging on it, I am using Visual Studio.NET and can't see any option...
29
by: james | last post by:
I have a problem that at first glance seems not that hard to figure out. But, so far, the answer has escaped me. I have an old database file that has the date(s) stored in it as number of days. An...
15
by: Hexman | last post by:
Hello All, How do I limit the number of detail records selected in a Master-Detail set using SQL? I want to select all master records for a date, but only the first 3 records for the details...
19
by: eric.nave | last post by:
this is a slight change to a fequently asked question around here. I have a table which contains a "sortorder" column where a user can specify some arbitrary order for records to be displayed in. ...
22
by: onyris | last post by:
Hi guys - one more problem i couldn't figure it out . I have a form which displays a set of records and i want to display on top of the form the number of the record the user is looking at out of...
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
4
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.