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...
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...
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...
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...
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"...
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...
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...
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
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...
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.
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...
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...
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("tblReport", dbOpenTable)
With rsReportInfo
Do Until .EOF
colAttachments.Add !ReportName...
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.
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 =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.