Erik A

Erik A has asked 10 questions and find answers to 55 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

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
Access SQL Statement create tables always creates a field full of length