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 wOOdy-Soft 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 wsimmonds

  1. wsimmonds

    Chart Label Number Format

    Forgive me if I am missing something really obvious here, but what I'd like is to format the label on a chart so that it reads: 0.00M Currently I appear to be limited to what's in the Chart Expect or Format Data Label. I can do 0M or 0K - or one of a number of other formats, but I just can't...
  2. wsimmonds

    Print ( {DATE} + 30 )

    lbass, yeah your way is definitely simpler. Very new to CR myself and come from a programming side of things so DateAdd just popped into my head. Just started reviewing these forums - finding some gems of information. If you're not an employee, Business Objects really ought to be compensating...
  3. wsimmonds

    Crystal - working remotely

    You're able to open/edit/refresh data, so it doesn't sound like a firewall issue. I don't know what database you are accessing, but could it be that there is a different security configuration in place for VPN access as opposed to from your office?
  4. wsimmonds

    Print ( {DATE} + 30 )

    You're looking for the DateAdd function. To add 30 days you could create a formula entitled Due Date and then put the following code: DateAdd ("d",30,{GP.Invoice_Date})
  5. wsimmonds

    Conditional HTML output not working

    Thanks for the respones so far I meant to add to the previous message.. I have actually been known to use = instead of == before in code.. the perils of having to also work with VB6 sometimes!
  6. wsimmonds

    Conditional HTML output not working

    Sorry guys that was a typo! But I had actually used the comparison operator and not assignment within the code. That was me trying to just re-produce it.. I should have copied and pasted! This is the strange thing, as it works on several other development/production systems - just not my own...
  7. wsimmonds

    Conditional HTML output not working

    Hi all, Having a slight problem with my development machine. I've just upgraded to PHP 5.2.1 (can't remember previous version).. I am trying to do some template-based work, and for this I like to be able to edit my HTML within Dreamweaver/visual software. My problem is that a statement that...
  8. wsimmonds

    How to get count of number of rows which have more than X duplicates

    Tony, You have brightened up my day! That works and takes merely 0.13 sec.. I'll accept that! Superb, thank you.
  9. wsimmonds

    How to get count of number of rows which have more than X duplicates

    Hopefully a simple question, but one which I seem to be struggling with at the moment: As part of a large database system I have a table which contains merely ID numbers, some of which are duplicated. E.g. id 23592 23911 24950 24950 28700 27910 27910 27910 29100 It's likely that it'll be...
  10. wsimmonds

    Linking two close CAT5 connected offices

    Sizbut, Ooops - well spotted. I wrote DS but I meant DT units! You probably guessed that one though after posting. Do you think the VCM5 unit will present problems, i.e. lack of capacity for the 3-4 people? The vast majority of calls will be outbound and not to VM Pro or anything like that...
  11. wsimmonds

    Linking two close CAT5 connected offices

    All, Have been reading for a while (and having my colleague post under my username!) and am now attempting to setup another office,with just 3 or perhaps 4 users, with access to our IP Office system. We have an office (literally) over the road and now have a single CAT5 running between the...
  12. wsimmonds

    Alternative, faster search for SQL query with internal query

    The idea of this query is to use one table as an index to another table, so that it can be used to perform customised searches without having to mess with the actual table that records are kept in. This query does the job, but is very slow. Ideally it will be searching for multiple records by...
  13. wsimmonds

    DragDrop with Dynamic Control Array elements.

    Cheers for pointing that out. I still haven't got it to recognise the MouseDown event, but using the index property has helped me in another part of the program.
  14. wsimmonds

    DragDrop with Dynamic Control Array elements.

    I'm having trouble configuring a drag and drop feature for a configurable user interface. There are a load of frames, which are part of a dynamic control array. They need to be like this so that users can add or remove frames at their whim. The frames basically move around OK, but they jump a...
  15. wsimmonds

    Voicemail Pro: Goto Start-Points

    I'm having trouble getting the Goto, Transfer or any other such actions working with any Specific Start Points. For example I could get to Sales.Queued by simply being put in the queue, but when I use a Goto or Transfer action to run Sales.Still Queued, I just get silence. Any ideas why this is?

Part and Inventory Search

Back
Top