Search results for query: *

  • Users: ggunter
  • Content: Threads
  • Order by date
  1. G

    Trouble Accessing OCX Component

    I have a third party component that I regularly use. I referenced it as usual and it pulls in the dll's. However, it is not pulling the ocx into the toolbox. I last used this component four months ago and it's not showing in that project's toolbox either. I'm hoping there is a Studio...
  2. G

    How different is coding for MS Office 2007 vs MS Office 2003?

    My company will be upgrading from Microsoft Office 2003 to Microsoft Office 2007 in the near future and all our processes will need to be rebuilt. I expect to be asked for an estimated completion date but I have no idea how different the coding will be. We currently have automation built...
  3. G

    Resolved Print Word Document Range Issue

    Code: Public Function PrintDocument(ByVal pageFrom As Object, ByVal pageTo As Object, _ Optional ByVal displayErrorMessage As Boolean = True) As PrintReturns Try wrdApp.ActiveDocument.PrintOut(, , WdPrintOutRange.wdPrintFromTo, , pageFrom, pageTo...
  4. G

    Question Microsoft Word Print Issue

    First, the code: Public Function PrintDocument(Optional ByVal displayMessage As Boolean = True) As PrintReturns 'print Try wrdApp.ActiveDocument.PrintOut(, , , , , , WdPrintOutItem.wdPrintDocumentContent, , , , , , , , , , , ) PrintDocument =...
  5. G

    Resolved Like Query Issue

    I created a small program to test running a "Like" query but I can't seem to get any results. I don't get any errors, it just doesn't populate the dataset. Here's the code: Private Sub btnLoadLike_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnLoadLike.Click...
  6. G

    Change program name in Task Manager

    Is it possible to code a program so that the name displayed in the Task Manager can be changed mid-process? I have searched for it but everything I found was either someone wanting to hide the name or was for VB6. I am developing a program that will be run in a dozen instances at the same...
  7. G

    Question SQL Issue (hopefully)

    I have a small program set up to test making a connection to an Access database and running a query. I used the wizard to connect to the database and set up the query just like in the MSDN walkthrough. I encountered no errors when setting this up. However, when I actually run the program I...
  8. G

    Resolved Multiple Column ListView Load Issue

    I'm trying to load a listview control that contains two columns. Here is my current code: Try Dim lvwCollection As New ListView.ListViewItemCollection(Me.lvwWorkbooks) For Each row As DataRow In dtNatt.Rows Dim nuItem As New ListViewItem(row.Item("nattsPath").ToString(), 0)...
  9. G

    Make Table Query Issue

    Hi, This is my first try at Ado and I have run into an issue. I am trying to run a maketable query in one Access database to create a table in a different Access database. When I run my code, I don't receive any errors but the table isn't created either.:mad: And before you ask; yes, I am...
  10. G

    Question Access Sql parameters Question

    Please forgive my ignorance. I'm from a VB6 background and new to Parameterized Queries. I thought the PQ's were supposed to be INSERT INTO tblAssoc ( ?, ? ) VALUES (@name, @name) But when I try to run that I get a syntax error. If I replace the ? with the actual field name it runs. What...
  11. G

    Question Writing to a table in a secondary Access database

    I must have missed something pretty basic because I have no idea how to proceed. I can create a dataset/datatable and populate it. But I have NO idea how to write to a database. I need to run a query on an Access table and write the results to a table in a different Access database. In VB6...
  12. G

    FYI Run A Query Against Existing Dataset Tables

    I apologize up front. I KNOW this has been answered in other threads but I was not able to find them. Background: I have populated a datatable with data from an Access database. (I know... I know... but it's all they let me have. :mad: ) In addition, I have populated two other datatables...
  13. G

    Question Excel As Dataset

    I have a project in which I read data from two Excel worksheets and use this to create 25+ reports. The program would be far easier if I could query the worksheets directly as opposed to reading the data into tables. I found some code for this but I can't seem to get my test code to work. I...
  14. G

    Question Insert Into Error

    I'm a VB6 programmer trying to get a handle on .NET and I'm really hoping someone can point me in the right direction. My insert sql statement is as follows: sql = "INSERT INTO tblMTDadjust (Lend, ManagerAcid, AssocAcid, Month, " & _ "Day, Hour, Minute, Region, Unit, Activity, Symbol, AdjHour...
  15. G

    Answered Excel 2003 Cell Background Color

    I am trying to create an Excel "class" that will provide basic functions such as opening a workbook, formatting cells, etc. Does anyone know how to change the background/foreground colors of a cell in Excel 2003? In VB6 this was such a simple thing to do. But I have just spent 4 hours...
  16. G

    Question Permissions Error

    Hi all!! I'm a VB6 programmer trying to upgrade my skillset to VS2005. I have written a small application that will get a person's name based on an ID number.:D My problem is that I cannot get the program to access the database. I have the VS software set to run the debugger with the...
  17. G

    Answered Compile a Program

    I'm a VB6 programmer trying to learn VB.Net (2005). I've completed my first small app but I can't find any way to compile it. Is it no longer possible to directly create an exe?:eek: The only option I've found is to publish the app but this entails installing the app on individual machines...
  18. G

    Question Listview Population Issue

    I am trying to programmically run a SQL statement and use the results to populate a listview control on a form. My Ado class runs the statement and captures the data with no problem.:) My question is, "How do I get the data from my Ado class to the listview control?".:confused: To prevent my...
  19. G

    Not Responding

    Hope this is in the correct place. I have a form containing one 3rd party control and one button. When the button is clicked, it calls a class containing a function which acts on the 3rd party control. My problem is that when I run the program, it hangs after just a few seconds and the form's...
  20. G

    Need help adding ActiveX to 2005 Project

    Help!!! Does anyone know of any way to add a pre-DotNet ActiveX control to a VS2005 project? The control was provided to the company I work for by a 3rd party and I don't have access to the base code. Any feedback/ideas would be greatly appreciated.
Back
Top