Erik A

Erik A has asked 10 questions and find answers to 56 problems.

Stats

About

Medical doctor with a passion for research. Skilled in research application development, Access, VBA, SQL server.

Erik A questions

Set Excel cell equal to string containing date without leading apostrophe
Is it possible to raise events on a subform's form, when that subform is bound to a table?
Class_Terminate not firing on object from form
Stop Access from using wrong identity when appending to linked table on SQL server
Why am I getting "Data source name not found and no default driver specified" and how do I fix it?
How do I display a messagebox with unicode characters in VBA?
How do I use parameters in VBA in the different contexts in Microsoft Access?

Erik A answers

MS Access Selecting Blank/Empty/Null Text Records
automate printing of existing MS Access report (preferably with Python, but open to alternatives)
MS Access vb code to search for string (using the LIKE) statement
MS Access Multi-control KeyPress CTRL+A Handler
Exception on importing Blob image into ms Access report
Updating an Access Table with a CSV File Automatically
How do I check if a value a user is entering in Textbox is a numeric double?
How to connect to .accdb database from R
Reference List Box Column by Field Name
Exporting or writing data from python pandas data frame to MS Access table