Search results for query: *

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

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

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

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

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 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 hope that somone can help me. I have a text file (csv) that I currently link to using an access database. This data is then manipulated and specific rows are exported. All is working well when I test the database and everything works as expected. Unfortunatley, when I was given the original...

I have a report with a subreport. The subreport holds all of the main details of the report. As the subreport doesn't have page footers, I am using a Group footer instead. I need to display page 'n of m' in the Group header. This works perfectly for customers with only 1 page, always says '1...

I am having problems making a JavaScript call from a submit button after placing it in a style sheet 'box' The call works fine in an old HTML page as either an image or button but when placed between <div>'s it gives an error messsage which I have been unable to trace. The original code is...

I hope that someone may be able to help. I have a table with an order number, line number and Status fields. Each order can have several lines and each line can have one of 6 Status's. I need to write a simple report to find all orders with differing line Status's. Eg: order_number: 000111...

I have a table which holds 1000's of Product Codes. Each Product code can be split down into 4 Product Types. I have a formula on an unbound control on a form which looks at the first letter of the Product Code and then assigns the Product Type. I need to add this field to the Product Table as...

This is a Great site to help anyone to learn / brush-up their SQL Skills: http://sqlzoo.net/

Has anyone else had this problem?? I have a memo field in a table, which is filled in by using a form. The users want the text to be formatted in CAPS. For this reason I entered a '>' in the formatting in the properties for the memo field on the form. The problem that I have now is that the...

Hi I have a database on SQL Server 7.0 Every week for the last 2 months, the data has successfully loaded overnight on a Sunday. Our database is a rolling 4 week database with the oldest week of data being replaced by the most recent. Each week creates around 1.5 million records. A manual...

I have an error message when I try and link 2 tables together. It seems that I am only allowed 10 links between the 2 tables. I have searched for answers (and even changed the database driver from ODBC to Native), but this problem seems to exist whatever I do. Is this a limitation of CRW? or...

Hi! I am using Crystal reports 8.5 - connecting to a SQL Server database via ODBC I need to create a report which selects data between 2 time periods. I have a start year, start period, end year and end period. I have racked my brains, an cannot make the report select the correct data. It...

Hi! I have an annoying problem. I need to apply a background colour to all Customers whose name contains the letter &quot;e&quot; and I just can't figure out how to do it. Any ides?? Many thanks in advance Justine.

I have a report which needs to be conditionally suppressed according to which section the data is in. This is fine, but I need to add 19 sections, one for each level in the database that the information may be held in. I managed to add the 1st nine sections, but couldn't add any more. Does...