I'm running an Access 2016 Front End and a SQL Server 2014 back end. I'm unable to Update Access Date fields in my project.
I can't seem to get Access and SQL to communicate when it comes to Dates. The project I'm working on …
![Access]()
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications,...
Read more- 224K Content
- 16K Contributors
Expert Spotlight
Keep everyone healthy; Wear a mask - Social distance - Don't touch your face - Wash your hands for 20 seconds
Almost 50 years of programming experience. Click '+ More' in my "Full Biography" to see links to some articles I've written.
Leading Experts In
Troubleshooting Solution
Article
"Domain Aggregate" for Concatenating Values by Group in Microsoft Access
by Patrick G. Matthews
A common request in the various …
A common request in the various …
Video
Executing a SQL Server Stored Procedure from Within Access
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft …
Post
The Course of the Month for May: Comp TIA A+! Prepare for …
The Course of the Month for May: Comp TIA A+!
Prepare for the 220-901 & 220-902 exams in the month…
Prepare for the 220-901 & 220-902 exams in the month…
Article
Callback functions in Microsoft Access VBA. Part 1
Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. To get started, learn the basics.
Article
Callback functions in Microsoft Access VBA. Part 2
Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. This article covers how to reconfigure a callback function.
Article
Callback functions in Microsoft Access VBA. Part 3
Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. This article covers how to share one callback function between multiple controls.
Post
I recently passed my Microsoft 70-346 Exam. As part of my …
I recently passed my Microsoft 70-346 Exam. As part of my revision I used Flash Cards that I …
Post
Hello everyone out there in Experts Exchange World! My name…
Hello everyone out there in Experts Exchange World! My name is Terri and I am new to this site. …
Post
Gmail just launched a physical Security Key access option, …
Gmail just launched a physical Security Key access option, dubbed as Advanced Protection, for their …
Article
Revitalise colours in the VB editor
The colour setting for coding in the VB editor (VBE) of Microsoft Office is a left-over from a past century. Here is how - with a few steps - to bring new life to the ancient editor.
Post
Lost code of form Issue If you on a form decide to …
Lost code of form
Issue
If you on a form decide to move some controls into a…
Article
Indian number formatting of Currency in Microsoft Access and Excel
The Indian number format for currency has groups of two and three digits. The native Format function of VBA cannot handle this if Windows is set for a Western localisation. Thus, a custom method must be applied. Here it will be shown how to use dynamic formatting to accomplish this.
Article
Search As you Type for Microsoft Access Combobox
This is a rather simple but effective way of searching while typing on a Microsoft Access Combobox.
Troubleshooting Solution
Ad sequence number to new record in MS Access
I have several forms but these are all linked to the same table and create or elaborate records on …
Post
WebRTC Came to stay! It took a while but it seems that …
WebRTC Came to stay!
It took a while but it seems that now there is no turning back.
Levou um …
It took a while but it seems that now there is no turning back.
Levou um …
Troubleshooting Solution
Revising a Regex Function: MS Access
Hello Experts,
I need help revising a regex function that was created for me earlier this year by …
I need help revising a regex function that was created for me earlier this year by …
Troubleshooting Solution
Need help getting rid of a #Deleted record
I am using MS Access with MS SQL Server as the backend.
When I run the below query the first record …
When I run the below query the first record …
Post
Picoware has announced an update to their Tree View control …
Picoware has announced an update to their Tree View control for Microsoft Access:
…
…
Explore solutions and more
![Access]()
Microsoft AccessBack to the top
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.