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!

Search results for query: *

  • Users: medieval
  • Content: Threads
  • Order by date
  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 ?

    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?
  4. 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.
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. medieval

    Ticker Tape - Scroll Bar

    Thanks for looking at this one. I would like to add a ticker scroll bar into an excel worksheet. The ticker will need to scroll a string variable. Does anyone have any idea's as to how this can be acheived ? regards, Medieval.
  12. medieval

    Saving Files - Naming Conventions

    Firstly thanks for looking. I am using the code ActiveWorkbook.SaveAs Filename:=Fanta where Fanta is a variable string. However in an instance where the string contains illegal characters like "/" or "\" or "&" for example is there a script which will remove these illegal characters ? For...
  13. medieval

    SAP - How does it Remember ?

    I am using SAP 4.6, SAP logon 620. A version of which is installed on one PC and the same on another PC. SAP on the first PCwill recall entries previously entered into fields whereas the second PC will not. How do I enable the second PC to recall previous entries into fields ? thank you, Medieval.
  14. medieval

    Disable Save Prompt

    I have used the command ActiveDocument.Close but how do you disable the Window Prompt which asks you if you wish to save the document prior to closing it. thanks for reading this. sig Medieval.
  15. medieval

    Mouse Hangs - any ideas ?

    Whenever I move the mouse on odd ocassions every 2 to 5 minutes the mouse pointer will stop moving for a second or so although I keep moving the mouse. In addition to this the computer beeps too. This will occur on the desktop and also affects any gameplay too. I have windows xp with service...
  16. medieval

    Mouse Pointer hangs

    Whenever I move the mouse on odd ocassions every 2 to 5 minutes the mouse pointer will stop moving for a second or so although I keep moving the mouse. In addition to this the computer beeps too. This will occur on the desktop and also affects any gameplay too. I have windows xp with service...
  17. medieval

    Cannot Share Folders - Why ???

    Okay, First thanks for having a look at this and I'll try to keep it simple... I have Windows 2000 Pro and I want to share my folders in Windows Exploer. I would like to right click on a folder to share it but that option is not available. I don't understand why ? Please help. thanks Medieval.
  18. medieval

    HOW MANY cells occupied in a Field ???

    Firstly, thanks for looking at this - I hope you can help.. I regularly produce a report with 7 fields. Each Field has the same number of records as another. However each report may differ from next as the number of records produced will vary dependant upon external influences however as I say...

Part and Inventory Search

Back
Top