Search results for query: *

I'm having a problem while using docmd.transferdatabase. Unless I first go to File>Get External Data>Import and "access" (just selecting the source and hitting cancel--not actually importing anything) all my data sources, I get an "ODBC Call Failed--Unable to connect" error...

I'm having a problem while using docmd.transferdatabase. Unless I first go to File>Get External Data>Import and "access" (just selecting the source and hitting cancel--not actually importing anything) all my data sources, I get an "ODBC Call Failed--Unable to connect" error...

I'm getting an error that says a module can't be found. When I click OK, the VBE opens in debug mode with nothing selected. The call stack has a <Non-Basic Code> line in it. What is this and how do I see what's going on in that code? Patrick

I have a routine that imports ODBC data using: DoCmd.TransferDatabase acImport, &quot;ODBC Database&quot;, !ConnectString, acTable, !SourceTable, !LocalTableName, False The problem is sometimes I need to manually select File>Get External Data>Import, select ODBC from &quot;Files of Type&quot...

I'd like to programmatically add to an email I send a hotspot with a link to a file on our server--as in L:\public\drawings\example.dwg. With the user preferences set to &quot;make internet URLs (http:// . . .) into hotspots,&quot; I can use AppendText or something similar to make an internet...