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 derfloh 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. nalmond

    Access text field number comparison

    I have a query that attempts to identify differences between current and previous versions of a data set. A linked text file is compared to a static table within access using a query that is joined on a unique ID field. The problem is that for text fields that contain numbers as text the...
  2. nalmond

    User response prompt date not date data type in formula

    Unfortunately I don't have any control over the Universe, small fish in big pond. Using substr, to only take the dd/mm/yyyy portion of the date, on the user response input as the variable is created isn't working.
  3. nalmond

    User response prompt date not date data type in formula

    That should have been 'I can't make the variable a dimension it defaults to detail only.'
  4. nalmond

    User response prompt date not date data type in formula

    Thanks for your help guys, Unfortunately jayaramk's suggestion hasn't solved my problem. I have tried creating a variable with: =ToDate(UserResponse ("Query 1 with CL_PR" , "Open date?") , "dd-mmm-yyyy") I can make the variable a dimension it defaults to detail only. when the variable is...
  5. nalmond

    User response prompt date not date data type in formula

    I have a report that takes a date from a user response prompt, on a BO report, and attempts to incorporate this date into a formula. The problem is that the date is not being seen as 'Date' data type. The associated Clarify field is of the Date data type. I've tried ToDate, FormatDate, even...
  6. nalmond

    Auto upload a file to LiveLink

    Thanks appnair, That's just what I was looking for.
  7. nalmond

    Auto upload a file to LiveLink

    Is there a method of uploading files to a Livelink folder using scripts/xml etc? I have a number of scheduled BusinessObject reports which need to be uploaded/published automatically to Livelink. I've heard a rumour that xml can be used but can track down any info on it. Can someone point me in...
  8. nalmond

    Access VBA - Excel process still running

    Sorry for the late response, holidays & a funeral have kept me away from my desk. I find that the END command can sometimes cause problems when called from inside a procedure. Try calling END once all the work, this and other procedures, has been done. If you don't you'll probably end the...
  9. nalmond

    Access VBA - Excel process still running

    I've just spent a very frustrating 3 hrs trying to close down excel processes from after a little vba manipulation in access. After reading through many forum threads I suddenly remembered that I had beaten this problem before, and had written the answer on the front of my O'Reilly Excel Macro...
  10. nalmond

    List of values too long

    Steve, Thanks for the info. We're using v5.1.6 so it looks as though I'll be using multiple conditions for now. Fingers crossed for an upgrade to version 6!
  11. nalmond

    List of values too long

    Cheers Vinay, Any idea what the LOV limit is on a condition?
  12. nalmond

    List of values too long

    I need to query an accounts payables universe with a long list of purchase order numbers, approx 550 POs. The list is stored in a spreadsheet and when I create a LOV using it Bobj reports that the list is too long. Is there any way around this?
  13. nalmond

    text file import error

    Thanks for the response sleipnir214, I now get the error: Parse error: parse error in c:\inetpub\Team_Nortime\php_samples\import_data.php on line 15 Line 15 is the containing the ?> php closing tag Here's the full code: <?php # MySQL database User ID, Password and DB name $sql_id =...
  14. nalmond

    text file import error

    MYSQL / PHP Newbie question I'm using MySQL 4.0.14-nt and php4 on a win2000 box running pws. I've noticed from previous posts that importing from textfiles issues are a regular thread. I've tried the fixes used in a number of previous threads to no avail. When I execute the follwing command...
  15. nalmond

    Split access database not locking row on edit

    I've got the flag field up and running and it's working a treat. Thanks for the advice.
  16. nalmond

    Split access database not locking row on edit

    Thanks for the response markgrizzle. Both front and back-ends were already set to open mode = exclusive, default record level locking = edited record and open databases using record level locking was checked. Your first suggestion sounds interesting but I'm a little unsure how a flag field...
  17. nalmond

    Split access database not locking row on edit

    I have a locking problem with a simple split access database. There are three users, on the corporate network, that need to edit / add / update records on a table in the back end database. To enable them to do this I put together an unbound edit form, which works fine for editing and adding etc...
  18. nalmond

    Get range from highlighted cells in excel

    Doh! xlbo [medal] methinks you are right! Thanks very much that is exactly what I was looking for. Thanks also to all the others who have helped.
  19. nalmond

    Get range from highlighted cells in excel

    Thanks to all that have responded. I think the solution to my problem lies in a combination of Kylua and Rudo's posts. Kylua, thanks very much that code works a treat for interacting with the selected cells. The final step is to grab the range from the selected cells. Rudo is there a 'used...
  20. nalmond

    Get range from highlighted cells in excel

    Cheers Tranpkp for the post. I probably didn't explain myself clearly enough. The problem I'm having is getting the cell range, eg (A1:F56) from the highlighted/selected portion of a sheet. I'm getting confused with properties and methods such as selection, selected, activecell etc.

Part and Inventory Search

Back
Top