Refresh doesn't work

[Acke]

... 2010 converted file

 

[vbaInet]

Can you upload a 2007 version for me? Check that it doesn't work before uploading. You should get the same result.

 

[Acke]

Can you upload a 2007 version for me? Check that it doesn't work before uploading. You should get the same result.

Glad to do that, but I don't have an option to save file as 2007 version. I can save as .accdb (as it is in my last post with file attachment), as Access 2002-2003 Database (.mdb) and as Access 2000 Database (.mdb).

Is there a way to save it as 2007 file?

In addition, while I was saving this file in different versions, it came to light that original file is 2000 database file. Not 2003 as I beleived. That means that filter code was working fine for years in all previous Access versions.

 

[vbaInet]

Have a look at the first set of instructions:

http://msdn.microsoft.com/en-us/office/cc907897.aspx

 

[Acke]

...2007 file

 

[Acke]

Are there any news? Did you manage to define a problem?

 

[vbaInet]

I haven't had a look yet.

 

[Acke]

Hi guys!

I was away for two days. Did you had a chance to look at my problem?

 

[vbaInet]

I don't think RuralGuy has been on since. He's the one with 2010.

I will have a look later this evening because I don't have 2007 on this machine.

 

[Acke]

I don't think RuralGuy has been on since. He's the one with 2010.

I will have a look later this evening because I don't have 2007 on this machine.

I would, honestly, apprecate help on this one...

Hope to hear from you soon...

 

[vbaInet]

Right, see attached.

There was nothing wrong with the Filter method, it was your coding and naming conventions.

 

[Acke]

It is working now. Thank you!!!

I owe you a beer..., or six

What puzzles me is the fact that this code was working for so many years, without any problems. Not important now, but it is interesting...

 

[vbaInet]

Glad it's working.

I owe you a beer..., or six

I would prefer six please