Search results for query: *

I have two tables that I would like to pull information from. TableA has my part information, and TableB has the vendor specific information about that part. A partID can exist only once in the TableA, but partID can exist many times in TableB (once per vendor). In the live data, a particular...

I'm running into a problem with Crystal Reports that users view from within our application created with Visual Studio. I've been able to narrow it down to MS SQL Express vs. MS SQL Standard. For testing purposes, Database: I have a test table with two columns: rowid (int) and data...

I'm struggling with how to write a query. I have a table with records that are identified by a section field and an ID field, but the SECTION and ID fields can be repeated. For example, these would be valid records SECTION ID 1 2 1 7 2 1 2 2 2 3 2 8...

I am working on a function that will download a file from an specified FTP site and return the file as a filestream. I have found a number of very helpful posts online that have gotten me quite a ways on it. I'm able to get the file downloaded, but am drawing a blank as to how to download it...

I've got a Pitney Bowes postage system right now that I am itching to replace but am struggling to find a replacement printer. All the printers that I am finding that talk about printing postage are all either label printers or traditional printers. What I am looking for something that...

I am using VB.NET 2008 and distribute my main work program using the Publish Wizard - I publish to a network location and then install it to my workstations from the network location. When I publish an update, I have noticed that some workstations will prompt the user before installing the...

I am working with our Merlin Magix system in Hybrid/PBX mode. We currently have all outbound calls going out through our pool 70 which is a number of POTS lines. I've just added a DS100 card which will be giving us PRI ports (I think they show as ports 813 through 836). Can anyone give me...

One of my users is coming up with an odd one today. When selecting an object, then clicking Properties (or CTRL-1), the properties window comes up, but is blank. The dropdown combo box is there, but has no objects listed in it. If I go to another CAD computer (same version of ACad) and open...

I have a VB.NET app that makes a lot of use of the GetCommandLineArgs function. With a published application, I don't see anyway to start a published application without using the installed icon, and obviously when starting it from the icon, I cannot pass any command line parameters. Does...

I am printing out a Crystal Report through a VB app using the PrintToPrinter function. When setting it up originally, I was printing to an HP laser and to labels on standard 8.5" x 11" paper size. This part works with no problems. I am in the process of changing the report to a new size label...

I'm looking for some suggestions since I'm sure many other companies have gone through the same situation. We are running a Merlin Magix R3.0 system. I have a second production building that has some copper and fiber connections back to my main building (where the phone system is). We have...

I have an invoicing report set up in Crystal Reports (I'm using version 11) and am including a picture for each part/line item. I'm displaying each picture by using an OLE object, then changing the graphic location formula based on my part #. This works quiet well for us, except the aspect...

I am working with a Merlin Magix 2.2 Hybrid/PBX mode. We have two pools set up, 70 and 890. I have a fax machine set up on a T/R extension for outbound faxes only. Currently my users have to dial a 9 to get an outside line. Is there a way to program the system to auto pick a pool for this...

I'm running this SQL statement select sum(AMOUNT), AMOUNT_TYPE, GL_ACCOUNT_ID from RECEIVABLE_DIST group by GL_ACCOUNT_ID, AMOUNT_TYPE which returns AMOUNT TYPE GL_ACCOUNT_ID 500.00 CR 0110-000 100.00 DR 0110-000 which means that my total for account...

I am working with a check viewing program from our bank that reads check images from a monthly CD. My goal is to copy all the CDs to network shares and give the users an easy interface to remap a network drive to the desired month's share. The program also reads the volume label of the CD to...

I have been using the VB.NET 2003 and CrystalReportViewer control to allow users to access a Crystal Report ver 8.5. The viewer has worked without a problem using this login process from my VB app: Dim crReport As New ReportDocument crReport.Load("c:\testv9.rpt") Dim...

I'm working with Microsoft's Windows Image Acquisition Library v2.0 in a vb.net project. I've been able to successfully scan and save that scan to a jpg. But rather than saving it to a file, I would like to move it to a bitmap object and display the bitmap object in a picturebox control...

Most of the applications that I have written in VB.NET use SQL as their backend database. When I am using the SQL Server Enterprise Manager and look at the current activity, process info screen, it will show the user, system, database, and application that is connected to the SQL server. My...

I am doing a custom app in VBA (inside Excel) to automate the faxing of worksheets. I'm using the Microsoft Fax Service Extended COM Type Library. My client station is Windows XP Pro. code clip: --- Dim objFaxServer As New FAXCOMEXLib.FaxServer objFaxServer.Connect strServer --- When...

I am using VB.NET 2003 and am trying to pass parameter values to a subreport. I am able to pass values to the main report with no problems, but I am not sure of the syntax to get it to go to the subreport. Any suggestions? The section of code listed below works for adding the parameter for...