Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. stroyer74

    select statement

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

    select statement

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

    select statement

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

    Crystal Reports with Visual Studio and SQL Express

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

    Crystal Reports with Visual Studio and SQL Express

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

    Crystal Reports with Visual Studio and SQL Express

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

    Crystal Reports with Visual Studio and SQL Express

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

    Crystal Reports with Visual Studio and SQL Express

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

    Crystal Reports with Visual Studio and SQL Express

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

    Query parameters

    Thanks for the idea Duane! That works perfectly.
  11. stroyer74

    Query parameters

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

    FTP download to FileStream

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

    FTP download to FileStream

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

    Looking for postage printer

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

    VB.NET Published Application - confirm before update

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

    Configuring PRI ports

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

    Magix / Asterisk integration

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

    ACad 2006 - Blank Properties

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

    ACad 2006 - Blank Properties

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

    Command line argument / published app

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

Part and Inventory Search

Back
Top