Refresh Table After VBA Code

[vahnx]

I have a form with a button that inserts records into my table, but I must close and re-open the table to view the results. Is there some code or a way to make it auto-fresh the table?

http://youtu.be/lPxQmnI37SE

 

[xenou]

Hi,

As a general rule I would suggest not viewing/working with tables directly. You can create a form that *looks* exactly like a table. You would do this by just using a form with the table as a data source -- display the form in datasheet view. The form's On Activate event can include the line me.refresh or me.requery. Even queries, if they are used to show data to users, are best implemented as forms in datasheet view, as you have much more options at your disposal for exercising control over the process.

Will that do the trick for you?

BTW, what technology do you use to create the youtube demo? I think one of my teachers used the same too.

ξ

 

[vahnx]

Thanks.

The software I used was 'Screencast-o-matic'. It runs from your browser using Java. For free use you get up to 15 minutes and a small watermark, and a built in uploader. It's great for quick tutorials.

CamStudio is a better solution for unlimited everything free, but not as convenient.

 

[xenou]

Thanks - I might have a play with that some day.
To avoid unnecessary form refreshes, I'll revise my suggestion. Say you create a form called FormX based on your data table, putting it in datasheet view so it looks just like a table. You could then put in your button code:

Sub Command1_Click()
'//Do Update
Forms![FormX].Refresh

Or

Sub Command1_Click()
'//Do Update
Forms![FormX].Requery

 

[Pretty1996]

does this help at all?...

its titled "Update Immediately in Access 2007"

http://www.tutorialized.com/tutorial/Update-Immediately-in-Access-2007/41233

 

[vahnx]

Nope, still must close and re-open the table.

 

[boblarson]

I would echo xenou's statements along the lines of not working in tables directly. If you use a form that is based on the table you can set it to be a datasheet view which looks like the table but also has events so you can do what you want to do. If you use the table directly you can not do what you are wanting.

 

[vahnx]

I am using xenou's solution :D I am just confirming Pretty1996's solution does not work. It would be nice though to view updated data directly.

 

[Tesla]

[SOLVED] Refresh a local table view after delete all record then append with out the F5 - Access World Forums - Code that works in Access 2013