Search results

I have several apps making use of Lebans' picture box class. They have worked great for many years, but they have started bombing as users have switched to 64-bit systems. I've tracked it down to the following code, which run great on 32-bit machines and causes Access to shut down on 64-bit...

I have a database that is throwing that extremely unhelpful error about "A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX control". It is a single-file DB – not split. All tables and queries open normally and correctly. I've tried all the usual...

I have a memo field into which the user pastes text from various online sources. I made it an RTF field, because some of the formatting is useful - mostly italics for species names, and occasionally bold. Unfortunately, pasting web text often brings in a huge amount of superfluous formatting...

I have several apps in the field using Stephen Lebans' PictureBox class to draw various thing on the screen, generally a map with some selected information from the database shown on that map. All has worked well for many years, but one of my users now has a 64-bit machine, and the class no...

I've run into a weird one. I have a form that had NO controls that could take focus. All was controlled from the ribbon, and the form only displayed things in response to procedures called from the ribbon. Recently, I tried an experiment, and add a few controls to the form. They work, but when I...

I have a database that is slow to perform some functions. When the users click a button before the task is finished, an error message pops up, saying something like, "Setting of macro or function to property Before Update or Field Validation Rule prevents Microsoft Access from saving data in...

I have an Access 2007 db front-end that interacts with a SQL Server engine. All works OK, but there is a linked table that has me scratching me head. There are two copies of the entire database on the SS engine - one real and one test/development. I have the ODBC link set to the test version on...

I have an Access database that makes extensive use of right-click menus. 14 textboxes and comboboxes have a right-click menu attached, and they all work pretty well, most of the time. They are geared to the contents of the database, and so my code changes them when certain values in the database...

I have a form with a "Make Copy" button. The database has many records which are very similar in content. This button allows the user to select a record similar to what he wants to enter, make a copy and edit the copy, rather than having to type everything every time. This all works fine. In...