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

    Looping round an Excel range object

    I'm currently migrating VB6 app to .net which uses a lot of excel automation. the vb6 code employs a number of ranges and loops using a second range object as follows For Each rngCell in rngFocus < Do Stuff> Next This doesn't appear to work in .net, producing an Exception "Member Not...
  2. Shake412

    Creating a table in Access via ADO.net

    Thanks dalchri, I'll give it a try.
  3. Shake412

    Creating a table in Access via ADO.net

    I'm fairly new to .net and am trying to create an app which uses Access as a back end. I need to create a table dynamically and populate it with data. This is no problem using a DataSet and DataTable, however I want to save this table in an Access DB. How is this done, good old DAO was...
  4. Shake412

    Multiple Err.Raise From Class

    Using VB5, I am writing a class which imports an external file and then repeatedly calling that class from a form module. There are a number of checks performed in which the results are passed back to the calling procedure via err.Raise. Also any errors encountered are passed back up the stack...
  5. Shake412

    What is the short way to find out if Excel workbook is open or not?

    Firstly, thanks guys this came in very useful. But what about if there is more than one instance of Excel running? I’m writing an app which automates some excel report writing. I’ve found that if the user already has excel open and another is created in the background the GetObject function...
  6. Shake412

    Problem Connecting With Jet

    I'm writting a VB5 app on XP Home Edition and am having trouble connecting to a Jet DB. Using the CreateDatabase method I can create a database, then create a table and populate it fine. But when I close it and try to access in code simply using Set ws = CreateWorkspace(0) or ("", "admin"...
  7. Shake412

    Grid question

    I could get the whole link in for some reason. Here's the rest of it library/en-us/dnwinforms/html/wnf_custdatagrid.asp
  8. Shake412

    Grid question

    Hi I'm looking at this myself at the moment and have been working from the following msdn article. You may find it helpful http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwinforms/html/wnf_custdatagrid.asp I haven't managed to get it fully working yet, but will try tonight...
  9. Shake412

    Reading ID3v2 Tags withVB.Net

    I know there are posts already for doing this in VBA and VB6, but does anyone have any pointers for achieving this in VB.Net I've tried adapting the code quoted in the existing forums and tried the streamreader and the binary reader but with limited success. With the Binary reader, I thought...
  10. Shake412

    Analysing Subdirectories using GetDirectories or GetFiles

    Thanks for that. I never knew that you could call a procedure from within that very same proceedure. Is that new to .Net or has it always been part of VB. Thanks again
  11. Shake412

    Analysing Subdirectories using GetDirectories or GetFiles

    Is there any way of analysing a directory using the Directory.GetDirectories class and returning all levels of sub directories as well as the top level? And/or geting all the files when using the Directory.GetFiles class? Is the only way to do this, by looping through the directories returned...
  12. Shake412

    How Do I Multi Select?

    Cool. Thanks. I'll give that a go. cheers once again.
  13. Shake412

    How Do I Multi Select?

    That would work. Just that there's not a much fexability on a list box. Thanks again.
  14. Shake412

    How Do I Multi Select?

    Thanks for the tip I have used check boxes, but, as far as I know I can't select a range, i.e. Select 2 points while holding down shift to select each row in between. Do you know anyway that this is possible. I am also trying to write an mp3 editor, but to bulk change names, etc.
  15. Shake412

    How Do I Multi Select?

    I'm using a continuous form with the Record Selectors active. How do I refer to records which are selected when selecting a range of records? If I want to return data from one record, I just refer to the value of that control. Is there a way to loop through some collection of all the records...
  16. Shake412

    Help - Recover A Corrupt DB!

    I've got to work this Monday morning to discover that the Access 2002 application I was developing up to Friday has somehow become corrupt. I cannot access any of the code behind any of the forms or in any of the modules. I've tried repairing the DB and importing/exporting the forms/modules to...
  17. Shake412

    Changing Values In Collections

    Using Access 2002, I'm creating a collection whose elements are derived from a table using DAO, as follows... Set colAttachments = New Collection Set rsReportInfo = db.OpenRecordset(&quot;tblReport&quot;, dbOpenTable) With rsReportInfo Do Until .EOF colAttachments.Add !ReportName...
  18. Shake412

    .Zoom won't save

    Please disregards the .Zoom problem. I've managed to solve this now. If anyone knows the answer to the second question though, that would be most helpful.
  19. Shake412

    .Zoom won't save

    I'm exporting Access 2002 data to Excel for formating. Everything is fine but I need to have the report fit on one screen with no scrolling. Firstly, I can save all the ActiveWindow settings, but not Zoom. My code is as follows... With .ActiveWindow .DisplayGridlines =...
  20. Shake412

    Changing DB Properties by code in Access 2002

    Cheers for that, it works a treat.

Part and Inventory Search

Back
Top