Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. plawrence

    DoCmd.TransferDatabase Automation

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

    DoCmd.TransferDatabase Automation

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

    DoCmd.TransferDatabase Automation

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

    Can't Find Module 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
  5. plawrence

    Can't Find Module 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
  6. plawrence

    Help with Creating Charts

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

    Importing ODBC Data

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

    Importing ODBC Data

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

    Word macros

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

    Hi, What I currently do is create a

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

    Saving a calculated field total in a table

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

    Creating a boxplot in Access

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

    Creating a boxplot in Access

    What's a boxplot? Patrick
  14. plawrence

    Add Hotspot Programmatically with VBA

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

Part and Inventory Search

Back
Top