Search results for query: *

Hi all Got a perplexing problem which I'm sure some of you can shed some light on Developing a piece of code to open and run reports and had got part way throught when i decided to test it...the code so far: Sub RunReport() Dim buso As busobj.Application Dim DP As busobj.DataProvider Dim...

Hi all, I think I'm making a schoolboy error here but I can't see it. It is giving me a 'Run-time error: 3061' - Too Few parameters. Expecting 1' Can someone give me any advice please? Private Sub cmdMonth_Click() Dim wks As Workspace Dim dbs As Database Dim strMonthSQL As String Set wks...

Hi all, I have asked this question on the office forum but been told you guys might be able to help I have an excel form that has various calculations and subsequent percentage formats that I would like to export to a table in an Access Db. Using the template wizard seemed the best way - BUT...

Hi all, I have an excel form that has various calculations and subsequent percentage formats that I would like to export to a table in an Access Db. Using the template wizard seemed the best way - BUT it imports all the fields as text...is there a way around this..... or do i need to do...

Hi all Probably a simple solution - but I can't see it! Have a variable (Universe level) that has three categories (5Wds, 5-15Wds and Failure) - using two dataproviders, I have a report with numbers of flows in the three categories and null results i.e 5Wds 12 5-15Wds 24 Failure 02 null...

Hi all, I'm sure there will be a really simple solution. I have to open lots of separate workbooks....do some manipulation on these books and then close them BUT I have a few workbooks that need to always remain open. Has anyone got any ideas?

Hi all, I am using the filesearch option to find and then open a series of Excel documents. My code is: Set fs = Application.FileSearch With fs .LookIn = "C:\Mike" .FileName = Not "*mo*" .FileType = msoFileTypeExcelWorkbooks If .Execute > 0 Then...

Hi all, I was wondering if anyone has had any experience of Business Objects crashing due to number of rows fetched back. I'm using BO Ver 4.1.3. The query is hitting one table. This table has 3.5 million rows - BO crashes out at about 1.8 million mark. Is this a bug and can anyone offer any...

Hi I have got a table (table_x) with a list of Orders No. It is a temporary table that is a subset of a bigger list. For one set of reporting requirements, I have joined it to another table (table_y) where I want to see rows that have the Order No from table_x. so the join is table_x.order...