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 Chriss Miller 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. DaddyNackers

    ODBC Timeout???

    I am getting an "ODBC - called failed" error when trying to run a complicated query using ODBC linked tables. I found that if I change the property of the ODBC Timeout to 0, the query will run. However, I have code which runs each query rather than manually running each query. Is...
  2. DaddyNackers

    Copying Worksheets in Excel via Access?

    I am trying to copy a worksheet in an excel workbook and paste it within the same workbook using VBA. For example, I want to copy "Sheet 1" before "Sheet 8" using VBA code. Does anyone know how to do this? I am using MS Access 97. The following code is where I am at right...
  3. DaddyNackers

    Help - Runtime Error 458

    I am getting a run-time error '458' which reads: "Variable uses an automation type not supported in visual basic." I do not know why i am getting this error... This is the line of code where it is occuring... Set WBook = GetObject(WPath, "Excel.Sheet") I have the...
  4. DaddyNackers

    Multiple Users???

    Is there a way to permit multiple users within one access application over a LAN? Right now, my program only allows one user to actively use it. If another person enters the application, they have read-only rights (which makes sense because a table could be in use by the first person). Is...
  5. DaddyNackers

    Importing a Text File

    I need some help.... I want to import a text file using VBA code. The text file is a fixed format (each field I want to allocate a specfic number of characters). How is this possible? This is some of the code I have already written...
  6. DaddyNackers

    Access Automating Excel Chart

    I am having a difficult time automating Microsoft Excel via Microsoft Access code. I dumped my Access data into specified Microsoft Excel worksheets and want to create charts from that data. My problem is that Access doesn't allow me to manipulate any chart series other than the first. Here...

Part and Inventory Search

Back
Top