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!

  • Congratulations Mike Lewis 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. jseptor1

    Virtual Server 2005 best practice in production

    I'm working on a project with a customer who is considering using virtual server 2005 to cluster (virtual machines on separate virtual servers) some of their servers to increase fault tolerance and maximize their use of resources on some pretty powerful servers. I'm curious if anyone is...
  2. jseptor1

    NAS redundancy, cluster vs. d2d2t

    I am working on a project I would like to get some feedback from others on. (hopefully to validate my reasoning!) I have 2 identical NAS devices as well as the HP iSCSI feature pack. I need to balance performance, redundancy, and backup. Tape libraries are handling all the backup. My...
  3. jseptor1

    Need some help on converting VBA function to T-SQL

    Thanks for the response, it was exactly the type of response I needed.
  4. jseptor1

    Need some help on converting VBA function to T-SQL

    I'm a complete newbie to T-SQL, but have a pretty solid understanding of constructing SQL statements (queries), and VBA. I'm working on a project converting an access database into a SQL database (no front end will remain in access). I'm hoping someone can tell me this will be simple, and if...
  5. jseptor1

    VBA do while returns first record x times (x = # records in rst)

    Thanks for the help, PHV. I'm rustier on this than I thought! Your suggestions worked flawlessly.
  6. jseptor1

    VBA do while returns first record x times (x = # records in rst)

    I was actually just going down the same path you mentioned, PHV. I realized I was calling the recordset as a query, but building strings based on the form (me.). So, I realize the error of my ways now. My last question is how do I reference a query field with spaces in it? (ie, the field...
  7. jseptor1

    VBA do while returns first record x times (x = # records in rst)

    Tom, moving the .movenext outside the loop will force being stuck in the loop. (the loop will never end) PVH, using !fieldName as opposed to me.fieldName or me!fieldName throws the error "item not found in this collection. Here's the complete code, with a msgBox taking the place of the send...
  8. jseptor1

    VBA do while returns first record x times (x = # records in rst)

    I certainly appreciate the quick reply and the confimation of where the problem lies, but how would you recommend fixing this? What's the ideal way to do this?
  9. jseptor1

    VBA do while returns first record x times (x = # records in rst)

    In over my head again! The code below returns executes the propre number of times in the loop (ie, if there's 8 records, I get 8 messages sent) the problem is all 8 messages go to the first record in the rst! Any suggestions? I'm pretty weak at VBA, but my guess is that it has something to do...
  10. jseptor1

    Default printers change based on last logged on user

    I'm managing a network of winterm thin clients connecting to a Win 2003 Std. Server via RDP. I have three PC's (not winterm's) also connected to the network with printers installed locally. When I log into a PC and initiate a terminal session via RDP, My local printer becomes the default...

Part and Inventory Search

Back
Top