Search results for query: *

That did it! That is what I was looking for - thank you very much. The only part that I'm missing is for new parts that have been created, but do not have any corresponding information in the vendor table yet - they do not show up; but you specified that earlier that they would not show up...

Interesting stuff - I've not used this before. I tried your example, and it works for displaying the part info and vendor info of the first vendor. I can update the last line to read And (VendorParts.RowId = 1 or VendorParts.RowID = 2) but then that gives me two data rows for each part...

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

That's the ticket right there! Thanks hilfy! A simple SQL Server 2008 Client download and install, and everything works fine. Thanks again for the help.

Mixed Authentication: My program that they run to report through passes the connection information. That's what is so weird - before installing the SQL Server Management Studio, it won't work, but after installing SQL Server Management Studio, it does work.

Interesting update on my problem. If a user has SQL Server Management Studio installed on their workstation, the reports will display without a problem. Obviously there is something within the Management Studio install package that gets me what I need. Now it is just a matter of narrowing...

Gave that a try, but I guess I should have realized I already had Remote Connections enabled, otherwise I wouldn't be able to access the SQL Server from my development workstaion, right? I've gone through several online walkthroughs to make sure I wasn't missing something when enabling Remote...

Sounds like a good place to start. I know I had to enable the TCP/IP protocol, but don't recall ever messing with remote connections. I see that I will have to restart the services before the change takes affect, so I'll give it a try after users go home for the day.

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

Thanks for the idea Duane! That works perfectly.

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

Sorwen, I can appreciate your warning. That is something that I will have to watch closely - limit the number or viewers open at once, limit the size of the files, etc. But in this case, it will only be used within the my company so I can feel more certain what specs the user will have. Some...

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

WOW - what a difference 6 months makes. I haven't done any searching on Merlin / Asterisk integration for a while, but it looks like people are making it happen. That's very exciting. I, like many others, have been looking to do this too. Are any of you service techs local to the Chicago...

The user does have PICKFIRST set to 1. I changed it to 0, then back to 1 just to make sure it was reading the setting ... but still had the same problem.

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

While that is true for a shortcut's properties, if the application is a published application, the icon that gets installed does not have a target box. My published app is installed from a shared folder, then ever time the app is run, it checks the share for updates, installs updates if...