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!

Search results for query: *

  1. TropicalFred

    VBScript works as .vbs, won't work in VBA module

    I have a VBScript that runs fine when I save it as a .vbs file, but when I put it into an Excel VBA module and try to run it I get a VB "Object Required" error on the first line. What am I doing wrong? VBS code: Set WshShell = WScript.CreateObject("WScript.Shell") Set objEnv =...
  2. TropicalFred

    Change or Remove Outlook "From" field using VBS?

    Is there any way, using VBS, to change or delete the “From” field in an Outlook 2000 e-mail? I am sending out a custom e-mail to 400+ people in our company. I developed a VBScript to automate the process and it works great with one exception. I would prefer that the "From" field either show a...
  3. TropicalFred

    CR 9 e-mail from machine without e-mail program?

    I have a CR 9 report distributed through CE 9 that has several fields formatted so that when the user clicks on a field it opens up a blank e-mail form with an address in the To: field. My question is what will happen if a user tries to do this on a machine that is connected to our WAN but does...
  4. TropicalFred

    Dynamically change field positions at runtime?

    Is there any way in CR 9 to dynamically change field positions at runtime? I have a report with 10 data fields that can have anywhere from 1 to 255 characters in each field. If the first field has only 10 characters, for example, I would like the second field to move up underneath the first...
  5. TropicalFred

    Creating columns from rows

    I have an Access database table that looks like this: Account Attribute 100 Reg20 100 Comp 100 South 101 Reg31 101 NonComp 101 North 102 Closed And what I need is a table that looks like this: Account Group Region Comp/NC...

Part and Inventory Search

Back
Top