Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-04-2019, 11:53 AM   #1
GoodyGoody
Newly Registered User
 
Join Date: Aug 2019
Posts: 43
Thanks: 16
Thanked 0 Times in 0 Posts
GoodyGoody is on a distinguished road
Datasheet form refresh issue

Hi, I'm new to Access (but not coding) and have a datasheet which is just populated from a table. I have put a macro behind the 'ID' field so the user can click the ID field and it runs the Macro to bring up eitther a New Record or to edit the existing record. When I click the 'New' link and add a record, despite having used the 'Refresh' command in the Macro it doesn't the new record to the visible list. I also tried the Requery command but that doesn't seem to help either. There's a 'Refresh All' option on the menu bar which does do the trick so can someone tell me what the Macro version of 'Refresh All' is please? many thanks
Stephen

GoodyGoody is offline   Reply With Quote
Old 11-04-2019, 11:59 AM   #2
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,653
Thanks: 58
Thanked 1,459 Times in 1,440 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Datasheet form refresh issue

Hi. Are you saying the macro is calling a popup form? Is this from one of the available MS Templates?


Can you post a screenshot of your macro for us? Thanks.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 11-04-2019, 12:09 PM   #3
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,562
Thanks: 442
Thanked 847 Times in 818 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Datasheet form refresh issue

Did you try the Requery *without* any argument ?

__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
Old 11-06-2019, 07:29 AM   #4
GoodyGoody
Newly Registered User
 
Join Date: Aug 2019
Posts: 43
Thanks: 16
Thanked 0 Times in 0 Posts
GoodyGoody is on a distinguished road
Re: Datasheet form refresh issue

Thanks for asking and yes.
GoodyGoody is offline   Reply With Quote
Old 11-06-2019, 09:06 AM   #5
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,562
Thanks: 442
Thanked 847 Times in 818 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Datasheet form refresh issue

Not sure what to say.
I just created a datasheet form.
I created a form for data entry.
I created a macro with the follwoing steps

Open form to add a new record in dialog mode
Close form, though I did close it with the X
Requery on it's own

I ran this query from a double click of the ID control on the table and the new data appears as I would expect.?

HTH
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
The Following User Says Thank You to Gasman For This Useful Post:
GoodyGoody (11-16-2019)
Old 11-16-2019, 04:37 AM   #6
GoodyGoody
Newly Registered User
 
Join Date: Aug 2019
Posts: 43
Thanks: 16
Thanked 0 Times in 0 Posts
GoodyGoody is on a distinguished road
Re: Datasheet form refresh issue

I was running both Refresh and ReQuery and they seem to interfere with each other. Just Requery on its own works a treat so thank you for checking.
GoodyGoody is offline   Reply With Quote
Old 11-16-2019, 06:18 AM   #7
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,653
Thanks: 58
Thanked 1,459 Times in 1,440 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Datasheet form refresh issue

Hi. Glad to hear you got it sorted out. Good luck with your project.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 11-16-2019, 08:22 AM   #8
GoodyGoody
Newly Registered User
 
Join Date: Aug 2019
Posts: 43
Thanks: 16
Thanked 0 Times in 0 Posts
GoodyGoody is on a distinguished road
Re: Datasheet form refresh issue

Thanks. It's getting there. It's all coming flooding back! Have a weird issue at the moment with a corrupt query. I've tried re-writing it from scratch, repairing the front and back end all to no avail. Very odd...
GoodyGoody is offline   Reply With Quote
Old 11-16-2019, 08:54 AM   #9
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,653
Thanks: 58
Thanked 1,459 Times in 1,440 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Datasheet form refresh issue

Quote:
Originally Posted by GoodyGoody View Post
Thanks. It's getting there. It's all coming flooding back! Have a weird issue at the moment with a corrupt query. I've tried re-writing it from scratch, repairing the front and back end all to no avail. Very odd...
Have you seen this?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 11-16-2019, 09:38 AM   #10
GoodyGoody
Newly Registered User
 
Join Date: Aug 2019
Posts: 43
Thanks: 16
Thanked 0 Times in 0 Posts
GoodyGoody is on a distinguished road
Re: Datasheet form refresh issue

...I hadn't so thanks for pointing it out. Glad I'm not going mad. However, tried downloading and updating it and it says it's already installed.
GoodyGoody is offline   Reply With Quote
Old 11-16-2019, 09:46 AM   #11
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,653
Thanks: 58
Thanked 1,459 Times in 1,440 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Datasheet form refresh issue

Quote:
Originally Posted by GoodyGoody View Post
...I hadn't so thanks for pointing it out. Glad I'm not going mad. However, tried downloading and updating it and it says it's already installed.
Downloading and updating what? The fix is to "unistall" the MS update.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 11-16-2019, 09:58 AM   #12
GoodyGoody
Newly Registered User
 
Join Date: Aug 2019
Posts: 43
Thanks: 16
Thanked 0 Times in 0 Posts
GoodyGoody is on a distinguished road
Re: Datasheet form refresh issue

Ah right! Doh!
GoodyGoody is offline   Reply With Quote
Old 11-16-2019, 10:07 AM   #13
GoodyGoody
Newly Registered User
 
Join Date: Aug 2019
Posts: 43
Thanks: 16
Thanked 0 Times in 0 Posts
GoodyGoody is on a distinguished road
Re: Datasheet form refresh issue

Sorted. Thanks again
GoodyGoody is offline   Reply With Quote
Old 11-16-2019, 12:23 PM   #14
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,653
Thanks: 58
Thanked 1,459 Times in 1,440 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Datasheet form refresh issue

Quote:
Originally Posted by GoodyGoody View Post
Sorted. Thanks again
Hi. Glad to hear you got it sorted out. Don't forget to turn off automatic updates until after Dec 10.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 11-16-2019, 03:01 PM   #15
GoodyGoody
Newly Registered User
 
Join Date: Aug 2019
Posts: 43
Thanks: 16
Thanked 0 Times in 0 Posts
GoodyGoody is on a distinguished road
Re: Datasheet form refresh issue

Good point. Thanks for the reminder.

GoodyGoody is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sub Form Datasheet Delete issue chrisjames25 Forms 5 07-27-2018 12:07 AM
Image/Form Refresh/requery issue irish634 General 2 11-11-2008 12:19 PM
How to make automatic refresh / realtime form datasheet esugiawan Forms 0 04-14-2005 06:38 PM
Refresh a single record in a Query or Form (datasheet) ecrespol Modules & VBA 0 04-07-2005 11:11 AM
Refresh issue with unbound form Malcy Forms 3 08-25-2004 03:52 AM




All times are GMT -8. The time now is 11:54 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World