Search results for query: *

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

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.

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

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

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

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

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

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

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

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!

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

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?

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 =...

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

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

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

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

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.

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

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.