Windows 10: Timing Issue with Access 2013

I am an Access VBA programmer out of Sunnyvale, CA


My Name is Tony


My company will not permit me to bring the application back to my home office in the Bay area..


The program will not run the current Query we requested, but it did run in previous office versions before XP.


It works on Vista but Not Windows 10.


This is a critical situation.


Here is the Code




Dim OldBloodType as variant

Dim StDocName as variant

Dim BloodType as variant

Dim HoldWtr as variant

Dim Voltage as variant

Dim WorkA as variant

Dim WorkB as variant

Dim OldCX as variant

Dim SickA as variant

Dim SickB as variant

Dim SickC as variant

Dim Sick as variant

Dim Wtr as variant

Dim CX as variant


StDocName = "qryOldBloodType"

DoCmd.OpenQuery StDocName ' This works Fine Removes Records, Not Table tblBloodType


StDocName = "OldBloodType"

DoCmd.OpenQuery StDocName ' Inserts new patient and Blood Information , Works Fine All The time ****


StDocName = "qryOldCX" DoCmd.OpenQuery StDocName ' This works Fine Removes Records, Not Table tblCX


StDocName = "qryCX"

DoCmd.OpenQuery StDocName ' Inserts new patient and Blood Information , Works Fine First Time


StDocName = "qryOldCX" * DoCmd.OpenQuery StDocName ' This works Fine Removes Records, Not Table tblWtr


StDocName = "qryCX"

* DoCmd.OpenQuery StDocName ' Inserts new patient and Blood Information , Works Fine First Time




StDocName = "frmBlood"



SickA = "[Blood]=" & "'" & Me![cboBlood].Column4 & "'"

SickB = "[CX]=" & "'" & Me![cboCX].Column2 & "'"

SickC = "[Blood]=" & "'" & Me![cboBlood].Column4 & "'"


Sick = SickA & " And " & SickB & " And " & SickC


' The above line was recommended by The Microsoft Community and did fix one problem for the WHO.


DoCmd.OpenForm StDocname,,,Sick ' This always works correctly.



Problem is that the doctors must close the entire application and reopen the application, if they do not it takes over ten minutes the queries never look like they work.


If the doctor forgets to completely close the application the kid could die!!!!


Here at the hospital Fort Bliss Military Windows 10 appears to be the problem. However amazing as it seems this is the first Time I have seen Vista out perform and other system.

It looks like the two queries mark with an asterisk * never execute a second time?


Any Ideas Guys?


Tony Zinenagetto

:)

 

AMD FX OC'ers Club

That's what the auto setting will do since you're over the 1333 mark it jumps to the next step which isn't listed or officially supported I assume by that ram.

At this point though I would suggest dropping the multi one step or .5 so that we can get something stable and possibly take the heat issue out of the picture for now.

 

Edge Search Does Not Permit Change of Region


I got these suggestions from the Microsoft Community forum.No. 1 worked for me:

Thank you for posting the query on Microsoft Community. I am glad to assist you on this.
We have reproduce the issue here and we are able to access non-regional search for google using Microsoft Edge.
I would suggest you to try the below steps and check if it helps.
Step 1:
Clear browsing data option of Microsoft Edge and check if you face the issue. To do so perform the steps below.

1. Click on the More actions icon next to the feedback icon present on top right corner of the Project Spartan homepage.
2. Select Settings and click on Choose what to clear.
3. Check the boxes Browsing history, Cookies and saved website data and Cached data and files and click on Clear.

Step 2:
I suggest you to create a new user account and check if the issue occurs.

1. Go to Settings.
2. Choose Accounts and then select Family and other users.
3. Select add someone else on this PC.
4. Enter a user name and hit next.
5. Click on Finish.
6. Sign out from the current Account and Log into the new account.

Step 3:
It could also happen because of network issue. I suggest you to try with different network connection and check if it helps.

 

Can I run Access 2016 and Access 2013 on the same Windows 10 computer?

The Issue

This is really just a simple question: Can I run Access 2016 and Access 2013 on the same computer?

I currently am running Windows 10 and whenever I open an Access 2007-2013 format database in Access 2016 -- even though the database is already open -- a windows pops up that says "Installing Access 2013 please wait" (paraphrase).

It was suggested to run different versions of Access by putting one in a virtual machine. Well, I tried installing VVV (vagrant) on Windows 10 and it wasn't as intuitive as the YouTube videos made it seem.

My Questions

1. Is it possible/common to run Access 2013 and Access 2016 (both cloud versions) on the same Windows machine?
   
2. If so, what is required?
   
3. Can I do it without conflict if I don't use a Virtual Machine?
   

Any help is appreciated