Search results for query: *

Thank you so much! I've not done any coding for a long time, hard to get my head back into it! Hopefully there won't be too much more :)

Hi folks This code runs fine in Excel macro, but I cannot get it to work in VBS. can anyone tell me what's wrong with it? Many thanks in advance. J Sub FileRename() Dim OldPath 'As String Dim NewPath 'As String Dim FileExt 'As String Dim FileNames 'As String Dim...

We have just upgraded to XIr3.1 in our dev environment. At the same time, we have upgraded the databases from 2005 to 2008. I have created a new connection to a copy of one of the XIr2 Universes which points to our 2008 database. I have run the integrity check over the universe (which picked...

Many thanks!

I am working on an XI R2 Webi report over SQL Server 2005. I have a need to enter a Start and End date prompt, but these prompt values will be used to filter several dates in the query. At the moment I have 3 start dates and 3 end dates - all start dates are likely to match and all end dates...

What do you want to do with the page? You can't (as far as I am aware) actually format this page, but you can change the order that the prompts are displayed in.

Hi there I have some VBA Code which runs from a macro to store a Business Objects report as a PDF or HTML document inside a SQL Server database. The code creates a PDF/HTML in a temp file and then this is used to store as a BLOB in the database. If the document is too large, the code splits...

I realise why I am getting multiple records, I just don't know how to get One Opportunity record and then the subset of Forecast records. I want All Forecast records and All Opportunity records (even if there is no forecast record for the Opportunity) I tried to join the View to another view...

I shall have a try and get back to you. I hadn't thought of that. Thanks for the suggestion Justine

I have a View that is the union of 3 views. The view stands to let users see the qty of leads, Archived Leads and Opportunities broken down by marketing Project. I have various calculations in the 3 views that make up my Union View and all is working well. I now have the requirement to add a...

You are all brilliant!!! Thank you so much! This has been driving me insane. Here is what I ended up with: Dim strText As String, lenText As Integer, stPos As Integer, Srow As Integer strText = SearchText lenText = Len(strText) Srow = 2 While Len(Range("C" & CStr(Srow)).Value) > 0...

Hi Geoff Here is the code that loops through and checks to see if the word that I am searching for exists in the coloumn and row that I am searching in. This code makes the whole line of text in the column bold, rather than just the word that I am searching for. EG: If I am searching for the...

Sorry - I removed it and left the code as it was before I started playing with it. I can re-post with the code that made the whole row bold if you like, I removed it as it wasn't doing what I needed it to. Many thanks, Justine

Hi all I have a spreadsheet with a 'Search' area. The User enters a search phrase or word and the code loops through the spreadsheet and returns any rows that contain the expression or word into a new sheet. This all works fine. I have now been asked if the search phrase or word can be...

Is the query working? Have you checked to see that the field that is the concatenation of the code name and serial number is populated? Are the records deleting correctly too?

This question has been answered in thread: thread707-1283327 Many thanks to PH for his useful answer.

You are truly awesome! Whatever you are being paid is not enough - I wish I could give you more than one star! Thanks you so much PH! Justine

I have to create some files (exported from MSaccess tables). The files are creating and exporting just as I like, except for one thing. I need to add a '.' (dot) into the file name. I realise that this is really bad naming practice, but this is how the files need to be named in order for some...

I had a similar issue to this a couple of days ago. I tried everything and eventually re-booted my pc which fixed the issue. Maybe try it before you get too bogged down? you never know!

I have to create some files (exported from MSaccess tables). The files are creating and exporting just as I like, except for one thing. I need to add a '.' (dot) into the file name. I realise that this is really bad naming practice, but this is how the files need to be named in order for some...