Search results for query: *

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

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()...

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

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

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

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

Hi, I'm trying to perform several manipulations to time values (all will be stored in a access database). I need to find the elapsed time between a start time and a finish time and I also need to be able to find the SUM of multiple time values. I know how to do this first part of the using the...

I have restricted textbox input to numeric with the following code Private Sub txtACI_KeyPress(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtACI.KeyPress If Not Char.IsDigit(e.keychar) And Not Char.IsControl(e.keychar) Then...

I have made a real simple email client that works. However, the emaqil is sent but it just takes for ever to get delivered. Why is that? The exact same email sent to the same address through the same servers when sent through Outlook is virtually instant. My code is below... TIA Russ...

does anyone know how to get a service to restart itself. I'm working an a service with a built in www server to host a www admin interface. I want to be able to restart the service from one on the web pages. any ideas? Regards, Russ http://www.russgreen.net/software/...

Hi guys, I'm having a problem on a server I'm nowhere near. I have asked someone at the site to install some software on the server so I can manage their network remotely. When they login in as administrator and attempt to install the software they get the following error "Cannot use(or...

I have made a simple hta page as the entry point to an intranet application. I want to be able to to use a popup window script to open subsequent pages. My javascript popup looks like this <script language=&quot;javascript&quot;> var popUpWin1=0; function popUpWindow(URLStr, left, top, width...

I have made a simple hta page as the entry point to an intranet application. I want to be able to to use a popup window script to open subsequent pages. My javascript popup looks like this <script language=&quot;javascript&quot;> var popUpWin1=0; function popUpWindow(URLStr, left, top, width...

I have created a task list on our exchange server access by anyone working on a particualr job. The path of the task folder is \\Projects\****\****\1956 project tasks How can I make this task list appear on my Outlook Today page inplace of the default personal task list? Many thanks in...