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!

Recent content by medieval

  1. medieval

    Next Int. Date Report

    Quick one.. Given one or more customer accounts, credit region groups, etc., what report from SAP 4.6 gives a list of customers with the field 'next int. review' date as per fd32 or fd33. thanks, medieval.
  2. medieval

    Saving Excel Spreadsheet

    Hi, Ok, I'll keep it simple and you can ask me if you need more details... I have created a macro to tidy up, colour, currency change, date format a spreadsheet. This is then saved to the desktop. I have it so I am not prompted for errors. The spreadsheet saves, no problem. Albeit it doesn't...
  3. medieval

    INSTR treated like an ARRAY ?

    this is entered in select expert as part of the formula editor. i'm trying to see if a discrete parameter appears in any part of a table.field, if so then i can include this in a gorup.
  4. medieval

    INSTR treated like an ARRAY ?

    I'm using Crystal V10 and have entered InStr({CS_CONTACTS.EMAIL_ADDRESS},{?EMAIL_ADDRESS}) but this is treated like an array for some reason and a prompt denotes that this array should be treated as a subscript. Any ideas as to why this is happening and what can be done to get the INSTR effect?
  5. medieval

    Outlook 2003 : Reply with attachments ?

    When replying to an email which had an attachment, how do you configure Outlook 2003 to include the orginal attachment? for some reason, this seems to be missing.
  6. medieval

    Cannot Group by Formula ?? V10

    thanks. problem solved.
  7. medieval

    Cannot Group by Formula ?? V10

    thanks synapsevampire and Madawc. The code to the formula is 'Year (CurrentDate)'. What are your thoughts ?
  8. medieval

    Cannot Group by Formula ?? V10

    Hi, Pretty new to this so bear with me however using V10.. I have created two simple mathematical formulas however when attempting to group the data under detail by formula; the program does not give me the option. I have the various fields for any one of the Tables I have chosen but that is...
  9. medieval

    Search cell content over multiple worksheets

    Hi, I have an excel spreadsheet with multiple worksheets. By making a cell active in one worksheet, is it possible to show which other cells in all spreadsheets use the active cell as part of any formula or calculation by colouring this say yellow ? This will help identify any...
  10. medieval

    Order of File Lists

    Thanks for the quick reply Bcastner, Will you fix work each time I turn off and turn on the pc ?
  11. medieval

    Order of File Lists

    When listing files in Explorer or in a dialogue box, I would like to change the default view Windows XP offers for all situations. As it stands, the view default is 'List' but I would like this changed to 'Details' in an ascending alphabetical order. This needs to remain constant always. Any...
  12. medieval

    SATA Drive - Incorrect Size ??

    I have a motherboard with SATA connections and a 200Gig SATA hard drive. I have installed windows 2000 but it reports the hard drive as 133Gig in size. I have been told to reinstall windows and press F6 on the keyboard but this only prompts me to enter a floppy disk which I do not have; in any...
  13. medieval

    Saving a file with a built in Macro

    Okay, I have created a VBA script which in the end saves the worksheet. But if I wanted to embed a VBA script within the worksheet before it is saved, how can I do this ? Now I'm not exactly proficient with VBA so please keep it simple, oh and please tell me if you need more information from...
  14. medieval

    Saving Files with Subset VBA script

    Hi macropod, Thanks for the website. I'll give it a read although it will take a while to digest as I am somewhat new to VBA. :-) medieval
  15. medieval

    Saving Files with Subset VBA script

    First of all thanks for reading this.. I have created a VBA script in Excel which culminates in saving a spreadsheet. However I would like to have the spreadsheet saved so that it includes it's own proprietry VBA script. So in this example, I have saved the worksheet which includes a column...
See more

Part and Inventory Search

Back
Top