Auto-Filter and Memory problems

[greencat]

I have a huge database, i need to see it at a form and not an autofilter, but that form has to have those possibilities, i have to implement the auto-filter at this form. When i have to many rows in list boxes it writes "not enough memory"
The questions are:
1) How do i free memory without deleting the database?
2) How do i work with auto-filter through VBA?

Thanks!
Gil

[datastream]

To adjust autofilter in VBA:

Worksheets("SheetName").Range("A:A").AutoFilter Field:=1, Criteria1:=">=10", Operator:=xlAnd, Criteria2:="<=20"


The above example selects column A and filters >=10 and <=20.

Field selects the column filter. 1 is column A, 2 column B and so on.
Having just field stated without any criteria listed will just reset the filter, so if you are done filtering and you want to reset the data, just use the field code to reset it.

Criteria1 is the first criteria, you can stop at this point, but if you need 2 criterias, then use Operator which will either be "and" / "or" for the relationship with the 2nd criteria. Criteria2 is the next criteria.

The above code works in excel 2002. Not sure of earlier versions.

[Chris Davison]

free memory : this is what I do : Remove any add-ins you may have in excel temporarily, switch off "undo" and close other applications (most people run with Internet Browser and email open... shut them down). Also keep an eye on your free hard drive : you need a healthy area of free space on this for Windows to use as temporary memory when it's RAM runs out. So if it's running low (personally I'd get worried at less than 100meg) then clean up your PC and delete any unwanted files. Reboot your PC, as often memory will have been affected by all of the above and may not have reset itself.

(As an observation though, if you're regularly getting memory probems, ask your employer to provide you with more memory... if they want you to do your job effectively, they need to provide you with the appropriate tools to do so, tools that keep pace with your expanding range of skills)

dunno if it helps but excel can track your memory that's available : =INFO("memavail") in any cell will keep track of your RAM in megs

[greencat]

I just hope that it will work at excel 97

Thanks a lot guys!

[Chris Davison]

that's what I use, at work and home

[Jack in the UK]

Chris shutting programs will do very little as i know your set up in the short term it will allow actions routeens VBA to run, but will soon enough fall back then what????

Excel is useless at resources and thats the issue here it often mistaken that excel cant so blame excel, not so it a win issue

two kinds of windows, (Noty open or shut ones)

Commercila/ professional NT nased and
domestic Win 95 and 98 versions
these are 16 or 32 bit bianry addressing bla blar blar not important here

Nt willmanage resorces and re allocate Domestic dont.. thus your problem...

knowing all that whats Jacks fix:

cold boot that the best cure to many issues.. a pain but true allow default boot connect top network if neeeds be and then NOTHING ELSE run what you like this way 100% power of whats left is used.

DIRTY memory domistic can noy cope with

HTH

Your friend Jack