Search results

I come again to the well of knowledge... Having a brain cramp here... I display US address information, Address, City, State, and ZIP Code, in a simple user demographics form. Prior to displaying the current record in the form, I set a variable, BeforeFullAddress, consisting of a...

Interestingly, I can't find any public references on Google's website, however we did get this: Dear Administrator, We’re constantly working to improve the security of your organization’s Google accounts. As part of this effort, and in consideration of the current threat landscape, we’ll be...

Greetings to the well of knowledge... As some of you may know, Google will be dropping support for SMTP as an account authentication methodology, replacing this with OAuth.. I have several snippets of code that uses the native CDO library to handle email within my VBA code. Has anyone been...

No. I upgraded the Access 2010 program to the Access 2016 program. I then relinked my SQL tables to my front-end (that was written in Access 2010) using "Linked Table Manager". After that, I noticed that a Currency field was now an OLE Object. When I looked into the SQL Server (2008R2), that...

Sorry, it is VARbinary(510) in SQL Server. It comes up as an OLE Object in Access. It was Currency before I moved from 2010 to 2016. The SQL database is unchanged.

Greetings to the well of knowledge... When I upgraded my Access front-end from 2010 to 2016, one of my currency fields was converted to a Varbinary(510). The field displays properly in a report but I am unable to export the data into a spreadsheet; the field is blank. Is there a conversion I...

BINGO! Thank you so much for that insight!

OK, figured it out. With SQL Server 2017, there is a different DAO library that needs to be loaded into Access (under References in the VBA Editor). Once I figured that out, the rest was gravy!

Oops, sorry, my bad. Error 3265 was generated by DAO.QueryDefs Item not found in this collection.

Greetings to the well of knowledge... Not sure of where I should post this, so posting it here. I recently upgraded my SQL Server back-end from 2008R2 to 2017. I am now trying to get my existing front-ends working using 2017. I have encountered one issue. I have some code that executes...

Greetings to the well of knowledge... I have an Access front-end that talks to an SQL Server 2008R2 back-end (yes, I know I need to upgrade this). This front-end is used by users on a Server 2008R2 remote desktop server. I am in the process of completing the build-out of a new Server 2012R2...

And we have a BINGO!

Greetings to the well of knowledge... I am sure most if not all of you have been touched by the recent rash of defective MS updates for Office. :banghead: Despite my best efforts to remove the bad patch(es) or apply the alleged fixes, I continue to have problems where my applications just...

Thanks to all of your for insight and assistance. I learned an awful lot today thanks to you.

We are just starting our Windows 10 rollout. What I'm going to try is modifying the trust settings on my Win10 "gold" image so that everything is set when I image a PC.

Most of my databases do a lot of initialization during Form_Load. I wonder if this is where the trust error is happening.

So I changed the trust center settings to accept VBA and Active X. This now makes the DB start properly. Is this applied at the DB level so that anyone who copies the DB will get the same settings?

As I noted, I don't allow users to run the copy on the network shared. I require them to take a copy to their desktops.

That makes sense but when running under Win10 and using Access 2016 runtime, the warning doesn't come up. Access Runtime just starts then closes with no warnings or errors. Interestingly, on Win7 PCs running Access 2016 runtime, the warning DOES appear.

Greetings to the well of knowledge... All of my Access DBs are front-ends that talk to our central SQL Server. I manage the development and release new versions on a fairly frequent basis. I install the "gold" copy of the Access DB on a network share and instruct my users to take a copy of...