Search results for query: *

If you're talking about linking, the ODBC driver won't allow me to access any data if anyone else is in the database. I've been importing the data either early in the morning or late in the evening or been asking everyone to stop working for a bit. These databases are in a vibration analysis...

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 have MS DAO 3.6 selected. It's either a 'Can't Find Module' or 'You canceled the previous operation.' error. I'm just about to my wits' end. Patrick

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 forget where I found the origin of this (probably at www.mvps.org/access) but basically, don't use the chart wizard. You want to fill in the chart's datasheet. This is an example I could find quick. I called the FillDataSheet routine with FillDataSheet Me.GraphFtrAreaTCCMod.Object, rs...

That's what I don't understand. There is no password and everything is set up correctly in the user DSN. What's bothering me is why do I have to step through the process manually before the code will work. I always get the same error: 3151 ODBC--connection to <my db> failed. When I go back and...

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...

In the VBE, hit Ctrl-R or go to View>Project Explorer.

Application.DisplayAlerts = False ActiveWindow.SelectedSheets.Delete Application.DisplayAlerts = True Look up DisplayAlerts in the help to get the full context. Another good one is Application.ScreenUpdating. Set it to false and you won't see the macro bouncing around the sheets. Be sure to...

I was always taught not to store calculated results unless it would save huge amounts of time for the user. If you have the necessary data, why not just leave a calculated field in the form/report? Like AccessAce alluded to, find an appropriate event (like a change or update event) and refresh...

I tried looking for add-ins or something similar but can't find anything. I agree with Zathras; the stock charts are about as close as you'll get with something built-in. You'll have to figure out which series moves your whiskers and box like you want and use the quartile function to set their size.

What's a boxplot? Patrick

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...