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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by hende10

  1. hende10

    Option 11C - Glowing Fiber

    Thanks John. I think I can handle it, I am mainly worried about causing some cataclysmic system crash. The two cabinets are right next to each other, and the fiber is spooled in both cabinets, so I should have enough slack. What type of fiber is it? Does it require special ends to it? Its sad...
  2. hende10

    Option 11C - Glowing Fiber

    Thank you ace. Can an end user like myself replace the fibre? Or is there a chance of doing damage to the system? Thanks, Hende
  3. hende10

    Option 11C - Glowing Fiber

    We have had an increasing problem with some of our digital handsets making a "clicking" noise, but only audible to the person on the other side. This happens for both inside and outside calls, and for only the handsets on the digital card in our second cabinet. As an earlier test, I swapped the...
  4. hende10

    Call Voicemail box through DID.

    Thank you for the painfully obvious answer johnpoole. I thought I had tried * before, but I was wrong. I just tested it and it works fine. The idea to map the DID direct to voicemail is interesting serge9. I will keep that in mind if (when) people start complaining that pressing * takes too...
  5. hende10

    Call Voicemail box through DID.

    On our Option 11C, is it possible to check your voicemail by calling your DID? Currently to check voicemail from outside the office, we will call our main number, then ask the operator to put us into voicemail, where she then transfers the call to ext. 222. I would like to do something...
  6. hende10

    Vantage vs Vista

    Pratzt, I've sent an email to the address you posted. I am looking forward to your reply. Thanks, Hende
  7. hende10

    Vantage vs Vista

    Yes Pratzt, we can speak in more detail if you like. The original reason for this posting is due to how much the sales rep has "hedged" on his discussion of the software and other details. Should I post my email address on this site, or is there a better way to share info? Thanks, Hende
  8. hende10

    Vantage vs Vista

    My company is currently evaluating replacements for our incredibly outdated ERP system. Two of the choices we've looked at are Vantage and Vista by Epicor. According to the sales representitive, the main difference between the two (outside of price) is that Vista does not have any multi-company...
  9. hende10

    Disable Scroll Wheel?

    Thank you. I didn't relize I had only searched with the Access: Reports thread, instead of the entire site. Sorry for the bother. Hende
  10. hende10

    Disable Scroll Wheel?

    I have a vendor database which contains three page tabs. While I designed it to fit the majority of screen resolutions here, some users have such a low resolution that the form is too big for the screen, and they have to scroll down to access the bottom. The problem is that these users try to...
  11. hende10

    Checkbox Query - ANY vs ALL vs SOME?

    Thanks Greg. Between your post and a little research I now have this: strSQL = "" For intI = 1 To 21 If Me("chkBox" & intI).Value Then strSQL = strSQL & "(" & Me("chkBox" & intI).Tag & "=True) AND " End If Next intI strSQL = Left(strSQL, Len(strSQL) - 5) If strSQL <> "" Then strSQL =...
  12. hende10

    Checkbox Query - ANY vs ALL vs SOME?

    Greg, Only including the checked checkboxes sounds a lot cleaner. How do I build the WHERE clause in the form? Would it be in the On Click event of a button? Thanks, Hende
  13. hende10

    Checkbox Query - ANY vs ALL vs SOME?

    Greg, Thanks, that did work for the example. However, this query will be ran on 21 different checkboxes, which may make it more complicated then I can handle. My goal is to have a select screen where the user will check the box next to every machine capability he wants to see from a vendor...
  14. hende10

    Checkbox Query - ANY vs ALL vs SOME?

    PHV, Yes, in the same row. The two vendors that come up with the OR query look like this: VendNo VendName MattGrind ThrdGrind --------- ------------- -------------- -------------- 45 Acme Co. Y Y 55 Inco Inc...
  15. hende10

    Checkbox Query - ANY vs ALL vs SOME?

    PHV, I did try your example, and it returned nothing, even though there is one vendor that has both MattGrind and ThrdGrind checked. If I changed your example from AND to OR, it returned two vendors, the one with both MattGrind and ThrdGrind and one with only ThrdGrind checked. Thanks for you...

Part and Inventory Search

Back
Top