473,385 Members | 2,180 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Refresh Table

I have a table that is receiving updates from a form via an append query. I need the table receiving the updates to refresh and display the recently added record as soon as it is added. Currently, the only way that I am able to see the new record is by navigating to the table and saving the table. I have tried several variations of Do.Cmd to include "requery, repaint, and refresh" however the underlying issue seems to be that all of these are by default acting on the "current object" which is not in this case the table that I need updated. Do I need to shift focus to the table needing the update and then run Do.Cmd Requery? If so, how do I shift focus with out interrupting the user's view of their form view which is the only view users will be using in the project. Thanks in advance for any assistance here.
Apr 17 '18 #1
3 3894
BikeToWork
124 100+
Assuming the form's recordsource is based on that table, me.requery should refresh the data. Is the form unbound or bound to another table?
Apr 17 '18 #2
Sorry, minor detail I left out, it's unbound which is why I assume it's not updating with me.requery
Apr 17 '18 #3
NeoPa
32,556 Expert Mod 16PB
Certainly if it's unbound it won't be affected by any Requery or Refresh.

To help further (if required now) we'd need a much clearer understanding of what's where and connected to what. I have no idea what you mean by referring to the table - other than the one point I think we can be sure of, which is that it isn't the table itself. They don't need requerying and can't have unbound items in them.
Apr 20 '18 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Bruce | last post by:
I want to create a new table based on an existing table, but I don't want the tables to have any enforced relationship. Is this possible without having to do a CREATE TABLE and an INSERT? ...
9
by: Andrea | last post by:
Hi, I've read the former postings but was not able to solve my problem: I have a Summary Table (or MQT as you like it) and the query optimizer does not seem to use the summary table. I run...
7
by: Zri Man | last post by:
I have searched far and wide (not wide enough some might chip in) but cannot find the syntax for creating a staging table for an MQT. IBM manuals talk long and longer in serveral sections of this...
6
by: Klemens | last post by:
I want to create an MQT, intialize it manually and then use staging table to refresh it with new data, but i don' t see a way for not doing full refresh after creating the staging table. I tried...
7
by: Lisa | last post by:
I have an Access 2000 application that uses the following function to re-link my tables when I switch from my Current back end to a Dummy back end. I also use it to refresh my links. Function...
0
by: cwahlmeier | last post by:
We are unable to create a new summary table while a REFRESH TABLE command is running on different summary table. Why does the REFRESH TABLE command hold a lock on SYSTABLES? Is there a...
2
by: Memborg | last post by:
Hej Everybody I have tried do make an "instant search" in javascript, ie everytime one hits a key the javascript sends the request to a database and returns the result into a table. The...
3
by: BD | last post by:
I'm doing some cross-platform development, under LUW 8.2 (Windows) for z/OS 8. I have some fairly complex queries which address some rather large tables. One query takes approximately 30...
2
sandyinfinite
by: sandyinfinite | last post by:
Hi I make entry form to enter data. That data is go to table to make Chart. My question is that how to refresh that table data? I have use but wont work... table1.Refresh
1
KhadkaSaroj
by: KhadkaSaroj | last post by:
Hi there! I have a Form having comboboxes and labels which show the corresponding records of a Table. The Form is meant to delete records of Table but when a record is deleted I can see #DELETED...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.