Search results for query: *

Ah. So simple. Now I feel dumb. It was very late!

I have a database that I'm trying to perform a transform query on. I have the following query that is working OK: TRANSFORM Sum(tblInvoices.InvoiceAmount) AS SumOfInvoiceAmount SELECT Sum(tblInvoices.InvoiceAmount) AS TotalInvoicing FROM tblProjects INNER JOIN tblInvoices ON...

that doesn't do it. but thanks for the reply Regards, Russ http://www.learnvisualstudio.net?referedby=38523

Hi, I'm using this code to add form to a panel in a main resizable form. Dim frm As Form Select Case e.Button.Text Case "Staff" : frm = New frmEmployees 'Case "Details" : frm = New frmCompanyDetails End Select Me.pnlMain.Controls.Clear()...

thanks for the responses. actually I discovered a few things. 1. i was getting problems becuase both summed values didn't necessarily return a value. so I used this and it worked within access SELECT (SELECT SUM(tblTiming.TotalCost) AS SumCost FROM tblTiming WHERE...

I have a tricky SQL statement to write and not sure if it's even possible I have the following 3 tables and fields: tblProjects projectID taskID etc.... tblTasks taskID taskName etc... tblTiming timingID taskID hoursworked etc... tblExpenses expenseID taskID expenseamount etc... What I...

I have a application that connects to an access database. I need to insert an item into one of the tables and immeditely retrieve the value from the autonumber field so that I can use that value into a record in another table. I've tried using a simple INSERT command followed by a querie to...

I should have said... I would like to avoid using a def file as I don't really want to declare all the functions in the dll before using them. Thanks

I am a VB.NET programmer and really no very little about C++. However, I have a lot of code written in C++ and I want to be able to use it in a VB.NET app I am working on. I have setup a win32 dll project in VC++.NET (2005 express beta), I have added all the .h files to the project and it...

Thanks, I'm starting to understand that I need to build a singlton class. But what might that class look like if it were to be added to the following simple app? Russ Public Class Form1 Inherits System.Windows.Forms.Form Private oWinWord As Word.Application #Region " Windows Form...

I am currently developing an application in VB.NET that uses the Microstation's object model via COM Interop. I have a problem regarding multiple instances of the Microstation application (ustation.exe) and calling the COM object in multiple forms in my application. The Microstation...

I am developing a custom application for Microstation v8. My app connects to an Access database (I haven't yet hooked it up to Microstation). Within my code I have two very similar functions to query a database for a particular record. They are: Public Function GetProjCfgFromDb(ByVal...

Just found another source. http://blogs.worldnomads.com.au/matthewb/archive/2004/03/19/207.aspx Which uses the ODBC driver "Microsoft Text Driver (*.txt; *.csv)" Russ

I'm trying to build a method to populate a listcontrol from a csv file. My immediate requirement is to read a two column csv file and use the fist column a listcontrol.valuemember and the second column of the csv file to be listcontrol.displaymember My code so far, Dim sAppPath As String...

What's the best way of either, editing dialogs in my setup project or creating new ones? Are there any tools that will let me do this without buying expensive install suites? I need a custom dialog that will allow a user to browse for a folder during install. Also, Custom dialogs have to be...

I am currently working on a small VB.NET utility that accesses the Microstation VBA object model via COM. I have this code which I am trying to get to work... The key bits of information are Dim oEl As MicroStationDGN.Element Dim oTagEl() As MicroStationDGN.TagElement Dim oArrayList As New...

Great, thanks guys. Regards, Russ http://www.russgreen.net/software/ http://www.learnvisualstudio.net?referedby=38523

Hi there, This, I know is simple but..... I am doing this simple VBA macro to place numbers (with a prefix) into a Microstation drawing. The number increments by 1 everytime the text is placed. I have a little function that returns an incremented number. When you pass in a number like...

Does anyone have some sample code for posting to a MySQL database located "somewhere" on the net from a VB.NET Winforms app? TIA Russ Regards, Russ http://www.russgreen.net/software/ http://www.learnvisualstudio.net?referedby=38523

How do you limit to only one instance of a particular form? Regards, Russ http://www.russgreen.net/software/ http://www.learnvisualstudio.net?referedby=38523