Access Forms issues with button converting to Oracle

  • Thread starter Deborah Dawicki
  • Start date
D

Deborah Dawicki

This is my previous problem and I got responses to set module off and copy paste to a new database which I did and now get this error?? Can you help

"The expression ON Click you entered as the event property setting produced the following error: A problem occurred while Microsoft Access was communicating with the OLE Server or ActiveX Control.

Previous message

Hi, I'm converting an Access 2000 form to use an Oracle backend table instead of an Access table and the searchable field is named rcpa_no.. For an unknown reason, we keep getting "Error accessing file. Network connection may have been lost" when we try to click into the button with the code below.. Can you shed light on this one? I'd be glad to rename fields like rcpa_no to rcpano if that helps. Thanks alot! Note: When it was an access table, the fieldname was [RCPA No], and with Oracle it is [rcpa_no], not sure why the error.... It's not even allowing to create a button without returning that error. Please reply to (e-mail address removed).

Deb Dawick
Sr DB
Medtronic Neurosurger
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top