Refresh doesn't work

Let's try something else.

On the On Apply Filter event, put a Msgbox "Filter applied" just to test whether or not the filter was applied. Or you can use Debug.Print "Filter applied" and look in the Immediate Window to see if that event was fired.

Put a similar thing on the On Filter event too.
 
On Apply Filter I see MsgBox.

On Filter, there is no MsgBox opening.
 
This might indicate some form of corruption has crept in.

Did you convert the db from Access 2003 to 2010 or are you just running the 2003 db in 2010?
 
Create a copy of the db and try these two things on the copy.

* Convert the copy from 2003 to 2010, see how the code now performs in that. To convert I would advise you simply create a brand new 2010 accdb then import the objects from the copy into the new db.

OR

* Create a new 2003 db shell and import the objects from the copy into this new shell. Run this in 2010 and see the result.
 
Created new 2010 .accdb, imported all and no change in form behavior.

Not sure how to create 2003 .mdb from Access 2010. It should be save as and then I should be able to choose Acc version I want to save. If that is correct, I do not have that option.

On dropdown menu, I just have option (*.accdb)
 
Every release "fixes" oversights in earlier versions. As a result, there may be certain things that work differently in a later release. Perhaps if you post the actual AfterUpdate code from that ListBox from Private Sub...to...End Sub, we will see something.
 
Hi Allan,

You haven't got 2010 by another chance have you?

I'm thinking that Acke could upload a 2003 and 2007 db we can test on. I think 2007 'should' work similar to 2010.
 
I have both ac2007 and ac2010. I would like to test this as it has me puzzeled as it does the OP.
 
Ah, perhaps he/she can upload the 2010 version as well for you to have a look at (if you can).

I did once notice that in 2007 it won't work if I didn't set the Filter to vbNullString or zls before setting it to the actual filter string - like shown in my first post. Something I noticed on a db posted by someone on this forum a while back.
 
I have some time if the OP wants to upload and removing the sensitive data does not also remove the issue. :D
 
I am preparing a file for upload. To make application as simple as possible, I would like to cusotmize application toolbar. Unfortuanately, I don't know how to do it.

How is it possible to remove command from customized toolbar, made in earlier Access version?
 
I am preparing a file for upload. To make application as simple as possible, I would like to cusotmize application toolbar. Unfortuanately, I don't know how to do it.
Here are instructions on how:

http://www.access-programmers.co.uk/forums/showthread.php?t=140587

How is it possible to remove command from customized toolbar, made in earlier Access version?
Is this necessary for the upload? There's no interface for doing it in 2010 but there are other options.
 
I always use me.requery instead of me.refresh to update my lists and subforms.
 
Finaly...

Please start forms "Bodovni racun - pregled" and "Dinarski racun - pregled". When you choose a date from listBox, it should change data below.

Form "Dinarski racun - pregled" works, but I had to add me.requery, to the end of the code, as well as docmd.gotocontrol.

I sencerely hope you will be able to find solution.
 

Attachments

I always use me.requery instead of me.refresh to update my lists and subforms.

In this case me.refresh does not work at all. Only me.requery. But, the thing is, filter was working in Access 2003 without either me.refresh, or me.requery. I am interested to find out if it is possible to make this code work in Access 2010 as it was working in Access 2003.
 
Yep, setting a filter doesn't require a requery. So this puzzling. I thought you were going to upload a 2010 version as well for Allan?
 
I don't have 2010 version, but I can save this file as 2010 file, but I guess you can do the same.

I tried to convert 2003 original file to 2010 file and filter behaved the same. Therefore, I presume that saving a file in different version will not solve problem.

Still, do you want me to upload 2010, converted version?
 
I don't have 2010 version, but I can save this file as 2010 file, but I guess you can do the same.

I tried to convert 2003 original file to 2010 file and filter behaved the same. Therefore, I presume that saving a file in different version will not solve problem.

Still, do you want me to upload 2010, converted version?
I don't have 2010 (yet), but Allan has it and has offered to look at it.

Yes it can be converted but we want to be sure that the 2010 db you attach is one that isn't working. Reason being it may work on Allan's conversion but not on yours probably because he has a certain patch that you don't have.

So yes, please upload a 2010 db that you've tested and isn't working.
 

Users who are viewing this thread

Back
Top Bottom