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 bkrike 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 olekr

  1. olekr

    Trap a caption

    Hi! Perfect! This work like a charm: If Shift = (vbCtrlMask Or vbAltMask) Then.. But if it is 50 controls in a form, must each control have an event, or can this be done more easy with subclassing or something?
  2. olekr

    Trap a caption

    Hi! In a form, I have different type of captions (labels, buttons, checkboks, etc.). I want to CTRL+click a control, and get the caption to the control in a textbox. Is this possible? (The reason are for translation of captions. So when the caption is in a textbox, I have a function to write the...
  3. olekr

    Close another application from VBA

    Hi folks! Is there some way to close an application from VBA which is shown in task list as a process? For ex. Winzip? Thanks. Ole
  4. olekr

    Organizing folders

    Hi folks! We have a cad project including app. 6000 files. Will there be some speed difference in browsing files while organizing these files in several folders, or in sub-folders, vs all files in one folder? Is there some max number of file in one folder? We're using Win2K. Thanks. Ole.
  5. olekr

    Excel; Input minute and second

    Hi folks! "Just out of curiosity, if you could enter 12:15 and have it interpreted as mm:ss, what would you propose as the way to enter twelve hours and fifteen minutes?" --See your point, Zathras, and my suggestion will be like Gavonas: Just enter 12m15. And what about 15s instead of...
  6. olekr

    Excel; Input minute and second

    Hi! Thanks folks, but still i have to put in hours.. Isn't strange that with this multipurpose-stateoftheart-$$$-software, is not possible to write 12:15 without typing 0:12:15? Hmmm..Gates:Still a way to go! Ole
  7. olekr

    Excel; Input minute and second

    Hi! Is it possible to write 12:45 and get Excel to understand that this is mm:ss instead of writing 00:12:45? Thanks Ole
  8. olekr

    Best solution to remote connect?

    Hi! We have a Win2KPro mainly as a file server. It has 2 NIC, one to ADSL with static IP and one to the LAN. We use a proxy from Gatekeeper. We want to connect to this server from whatever PC connected to the internet (remote connect). What is the best solution? IIS? VPN? 3.part software...
  9. olekr

    Setting up VPN from scratch

    Hi! I'm a little confused about VPN. I have a situation: LAN at work with one PC running Win2KPro with 2 NIC (and acting as file server). One NIC for the LAN, the other for Internet via Cisco Router (ADSL). I have a static IP for WAN. Is it possible to connect to the LAN from whatever PC...
  10. olekr

    Ceate user with OSQL

    Hi and heeeelp! Can you help me how to create a new database "Test", with user "Hank", password "PASS"?? Must have rights to make tables, procedures and triggers. Thanks. Ole
  11. olekr

    Best solution: LAN to Internet?

    Hi! Thanks a lot! I'll follow your advice. Ole
  12. olekr

    Best solution: LAN to Internet?

    Hi! We have a TCP/IP-LAN with Win2K Server. Our hub is connected to a DSL-router in a VLAN. Our VLAN has 10.0.1.99 as a gateway which all LAN-clients use. But is this the best way? Is it better to use a proxy on Win2KS and lets say 192.168.1.x for LAN-clients? Very unsure of the LAN design here...
  13. olekr

    Max record number in a report

    Hi StarPassing! Splended!! Thanks a lot. Regs Ole
  14. olekr

    Is Access the best solution?

    Hi! I have never testet a db with Access-tables in bottom without having Access on the file server or client PC. Is it possible? Ole
  15. olekr

    Is Access the best solution?

    Hi folks! I have made several Access db with VB60 on top. Front and back end system. What do you think is the best db solution to sell to small companies which not have Access? Is it perhaps MS SQL in bottom and use VB as interface? Regs Ole

Part and Inventory Search

Back
Top