Search results

Hi George, I am demonstrating that when I use a Form Parameter (forms]![frmA]![dtmBirthday]) in the Where Clause on Access Tables everything works as expected but when I migrate the two tables to SQL Server I get a different result. I'll try to make a video.

AccessBlaster if you mean the data within the two tables is not consistent that is by design to demonstrate the issue.

Hello MS Access Expert, I am experiencing different query results when linked to SQL Server Tables, specifically, when I hard code criteria vs. a Form Reference. Note I don't experience this discrepancy when using Local MS Access Tables. I have attached the example database as a Zip. I have...

Thanks amorosik, VCS and WinMerge work great together.

Amorosik, How do you use Vcs for the purpose of comparison between different versions? I used to compare databases using FMS detective but it is no longer being updated for the latest versions of MS Access. Thanks.

I like to put Error Handling even into very basic methods because we often use the Runtime Environment and I also want every error emailed to us. Thanks for recommending vbWatchdog. I am little surprised by the CAD $295 price compared to MZ Tools USD $79.95.

That's it! MZTools. I was looking up NZ tools and couldn't find it :) Thanks Moke. I noticed MZTools has "Insert Exception Handler" but it appears this is a manual process which you must select for each newly constructed method? FMS Tools had a feature where you could automatically add...

Hello MS Access Expert, Unfortunately, it appears the latest FMS release does not support a 64 Bit environment. I recall there was a free Tool that offered very similar features to FMS Visual Code Tools but I cannot recall the exact name. Can you provide the name and link for this free VBA...

Thank you TheDBGuy.

Thanks The_Doc_man. TheDBGuy are you comfortable sharing some code snippets demonstrating how you successfully implemented OAuth 2.0 or pointing to a source that helped you in your implementation. Thank you.

The_Doc_Man, I am running the Kyle Beachill code as you suggested. OAUTH2 and VBA When I attempt to get the AuthHeader the code opens an Internet Explorer window with a BING Search. (See below screenshot) I presume I am supposed to do some kind of user interaction based on the code...

Thank you for all the responses. They were helpful.

Hello MS Access Expert, I am learning how to migrate MS Access objects using SSMA into SQL Server 2019. I was not able to Migrate the following query using the SSMA wizard and I am curious why. SELECT Invoice.InvoiceNo, [Quantity]*[UP] AS Total, Month([Invoice].Date) AS [Month], Invoice.Date...

Good to know it's possible and you have implimented it successfully theDBguy.

Thank you for providing these links. I will review the code.

Hello MS Access Expert, I would like to know if it is possible to make API calls via VBA that meet the below standards: Ability to adhere to TLS 1.2 encryption for HTTPS connection Ability to support OAuth 2.0 JSON Web Token (JWT) Bearer Flow I have a MS Access system that has been in...

I was able to resolve item 1) Now when I reboot my machine 2 Instances of MS Access load on Startup. I turned off the Sign-in Option which resolved the issue. (See attachment) 2) When I close an MS Access file and then open another MS Access file immediately, it takes several seconds to open...

Speaking of Restore Points why is it Disabled by Default in Windows 10? Could of been Handy Right now.

isladogs is it safe to Unistall Office 64 Bit and Re-install Office 32 Bit without rebuilding the machine? Thanks

isladogs is correct. The Default Office Install is now 64 Bit. (See Screenshot) My new Dell Machine came shipped with Office 64 Bit installed and so will all future machines. My experience with 64 Bit MS Access has not been a pleasant experience. The Compact and Repair Bug completely breaks...