?
Solved

The data on the "incident" tab is not updating the data on the "events" tab?

Posted on 2014-08-10
10
Medium Priority
?
173 Views
Last Modified: 2014-08-14
For some reason, I must use "Compact and Repair" function to update the data on the "incident" tab to the data on the "events" tab?

Another words, when I enter data it it not updating to the oter screens unless I use "Compact and Repair".
HBF-Modified-Root-Cause-Analysis-for-Tun
0
Comment
Question by:cssc1
  • 5
  • 5
10 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40252292
Please rename your file with a shorter name...

In any event, ...it sounds like you need a:  
    Me.Requery
on the click event of the "Tab Control" itself...
(NOT on the individual tab(s))

JeffCoachman
0
 

Author Comment

by:cssc1
ID: 40252319
sorry
RC-20.zip
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40252854
Did you try my suggestion?
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 

Author Comment

by:cssc1
ID: 40253307
No, but I because  know what a:

In any event, ...it sounds like you need a:  
     Me.Requery
 on the click event of the "Tab Control" itself...
 (NOT on the individual tab(s))

Any example you could send then I could try it on my application and see if it works?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 40253645
I don't have the time to dig in the inner workings of your application.
So I cannot tell you if the design is flawed and that is what is causing this issue...
Nor do I know the steps to perform, in order to recreate your issue...

Your symptom here seems to suggest that something is not saved or refreshed
(This is what C&R does, ...it saves and closes the database, ...among other things)

So on the Click event of the Tab (of the tab control itself)
Put code like his:

    docmd.runcommand accmdsaveRecrd
    me.requery

Then see if that solves the issue.

JeffCoachman
0
 

Author Comment

by:cssc1
ID: 40253761
i put the code on the both the Incidents and Events tab and still have the same problem.
When I go to the events tab, the incident does not appear.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40253857
Put the code on the tab control itself, ...not on the individual tabs
0
 

Author Comment

by:cssc1
ID: 40254122
I may have made another mistake. I have many forms that I put tabs on. I just say the option for Tab Control and put a tab control on the incident and events sheet, same problem. However, I may not have the forms setup properly to use tab controls and still have all the reports, querys, and form to work properly.

I have attached what I have done.
RC-20---Copy.zip
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 2000 total points
ID: 40254797
I am having trouble understanding how your database works,...

You may want to post a question asking how it could be simplified...
0
 

Author Closing Comment

by:cssc1
ID: 40260659
Thanks Jeff
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question