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

    Has anyone got ADO to Excel to work??

    Hi, I'm using an ADO link to excel and I can read from the Excel file OK, but has anyone successfully written to an Excel file using ADO? (I've previously used Automation but I've had problems with leaving instances of Excel running, despite explicitly closing them down!) Cheers Will
  2. WilliamMathias

    paramaterized queries question?

    Hi, I've got a make table query which is passed a parameter parDealType of type integer. For various reasons I can't use a where clause. I want to pass a value for parDealType of "1 or 2" My query works fine if I'm passing just 1 My query works fine if I'm passing just 2 but if I...
  3. WilliamMathias

    VB to Excel using ADO to run a subroutine in Excel??

    Hi. The following code will not work? When I execute the command I get run time error -2147467259 (80004005): Cannot execute a select query Can I run an excel subroutine through ADO? I've previously used OLE automation to do this but I've found it very troublesome. Thaks in advance...
  4. WilliamMathias

    Source Safe and Access

    Hi, I've just installed Visual Source Safe 6. Its working fine I've got Access 2000 installed OK Its working fine When I open the addin manager in ,say, VB 6, source safe appears as one of the available addins. But, When I open the addin manager in access, there are no available add ins...
  5. WilliamMathias

    Specifying a funny range

    Hi, I want to select a range of values from an excel spreadsheet. At the moment I'm using: [Nat Gas Download Data$C1:Z200] but I only actually want columns C,D, F and Z Is there a way of doing this? Also I dont actually want all the rows, I just whant does where column A's value is after a...
  6. WilliamMathias

    Can I use .NET for non internet based applications

    Hi, I'm reasonally experienced in VB6 / VBA but I've no knowledge of .net. CAn I produce normal COM objects, forms , database linking applications, with no internet element in VB.net? Also if this is the case will the code run as fast? Is VB.net interpreted? thanks
  7. WilliamMathias

    Parameterized Queries

    Hi, I've got a number of queries that I'm passing parameters to for use as record selection criteria. I'm using the parameters tab in query properties to create the parameters. However, if I want one of the parameters to be ignored (so as to return all rows) how do I do this I've tried...
  8. WilliamMathias

    How to open 2 instances of the same report

    Hi, I've got a report that works fine. How can I have 2 copies of the report open at the same time using VBA? thank you
  9. WilliamMathias

    ADO connection to excel from Access wont be read only

    Hi, I'm using the Jet oledb provider 4.0 (I've also tried with oledb provider for ODBC) to open a read only ADO connection to excel from access, and read a data range from a worksheet. Everything works fine, but if another user has the workbook open, I get an error saying the file has been...
  10. WilliamMathias

    How to debug a com object?

    Hi, I've written my 1st com object, in VB, it compiles, I've run regsvr32.exe and added the object to my project references. How can I debug my com object, can I step thru it? Do I run 2 versions of VB?
  11. WilliamMathias

    ASP won't run

    Hi, I'm running NT4 Server and IIS 3.0 I'm trying to write my 1st ASP script. The content of the page is as follows: <html> <body> This Page is <% Response.Write &quot;Working&quot; %> </body> </html> When I look at this page in my browser using the URL http://localhost/responsetest.asp...
  12. WilliamMathias

    How do I get MTS

    Hi, I'm running NT4 server and I'd like to learn about MTS. I've got some COM creation experience and I've read about the advantages of MTS. Does MTS come with NT4 or do I need to download it? Is there a single user interface etc? If you've got any tips 4 getting started / understanding it...

Part and Inventory Search

Back
Top