Jumat, 11 Agustus 2017

Re: [MS_AccessPros] Question about performance of Databases

 

hi Jim,

you're welcome

fault has no place. Often, you cannot anticipate things that might happen until they do. Solution is to add tracking and code to check stuff.

At the end of the code to update, if no error has occurred, store date/time -- and store date/time last record changed: use BeforeUpdate event of form(s).

respectfully,
crystal
 
~ have an awesome day ~

On 8/11/17 10:13 AM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] wrote:
Thank You Crystal. I have done that type of thing in other databases. But is it possible that a query in a macro or even a vba procedure be skipped because of network issues? If she clicked the button and the query was skipped, then it is my fault.

Jim Wagner



On ‎Friday‎, ‎August‎ ‎11‎, ‎2017‎ ‎08‎:‎04‎:‎52‎ ‎AM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


 

hi Jim,

store the date calculated in a database property or table. When records are changed, also store that date. When the report is opened (maybe you can do this on Open event), compare dates to see if macro/code needs to run.

respectfully,
crystal
 
~ have an awesome day ~

On 8/11/17 9:29 AM, luvmymelody@yahoo.com [MS_Access_Professionals] wrote:

Hello all,


One of the databases that I support, caused quite a stir yesterday. there is a report that is sent out from Access that shows the budgets for departments. This report is sent to the department heads. Apparently the user did not validate the data before emailing to the executive director. The budget numbers balance differences were way off. Of course it was the database's fault and ultimately my fault. Most were understanding, but there were some that were very unhappy and I was called into my boss' office.


There is a macro that must be run before the reports are sent out. The user says that she clicked the button to run the macro. But as I went through the macro and found the query that updates the balance difference, I ran the macro on its own and the report was fine. So she either did not run the macro or the query in the macro did not run.


Which leads me to two scenarios.

  • she did not run the macro
  • the macro ran but the query was skipped.

if she did not run the macro ---- end of issue

if she did run the macro and the query was skipped. Does that happen?

we have network issues here. it is intermittent in my opinion. could the intermittent network cause the query to skip in a macro?


What should I do?


Thank you


Jim Wagner




__._,_.___

Posted by: crystal 8 <strive4peace2008@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Posting Komentar