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

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

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

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

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?

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

Hi guys, I'm hoping this is going to be straightforward: In excel, via vba, how do I interact with the highlighted cells on a worksheet. ie how do I highlight some cells on a worksheet and then use a macro, or vba code, to perform an action on each of the selected cells.