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, Went on their Universe Designer course a few years ago and found it very good. They teach from the offical guide but they apply good working examples They would get my vote

Do you want seperate PDF files or one single one split out? If its the former, you need some code to filter on your criteria and save the snapshot. If its the latter, just set up some seperate tabs...based with filters or sorts... then when you save the pdf file it will be seperated out...

I think what you need here is an alias table. If you want to access the same table twice - then you rename it as another name. If you are doing this in the query grid, then add the table colors to the query twice - linking them to the relevant fields on person . Let me know if you are...

Hi all, I continued to play with this and got it to work at last!!! Its a bit bizzare...but it now works... thanks to both bill and centurion for all their help!! strMonthSQL = "SELECT tblSettledAudit.* INTO tblSettledReporter " & _ "FROM tblSettledAudit LEFT...

Thanks Bill, Will do...can't actually send it til later on today!!! Thanks

Hi Bill, Its still giving the run time error - its expecting parameters where there is none???? I'm confused!!

Hi there, the field dtmDate is of type date/time - does this have any bearing on the way the code needs to be written?

thanks CajunCenturion for your quick response, I have checked the field and table names, these are all fine - any other ideas? Thanks

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

Had some use of this tool on Excel97. In my experience, i thas been very good. An exsisting form with cica.50 fields has been converted into a good data entry form. I had problems with different types of filed type - so i used the wizard to import as txt and then exported to another table with...

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

nope, i have tried to specify all the cells in the excel s/s with the correct format: number, percentage, text, date BUT it is turning it all to text

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, You could also use Application.WorksheetFunction.Even(value)

Thanks again Steve - bear with me - I will try and be clearer. What I really need is a new dimension that I can incorporate from/with the old one. I thought of using a CASE statement - but this is not supported in oracle version 8. but in any situation, I will get an error as a flow sent in...

Thanks Steve for the response - I have tried the 'where' statement and it works fine. But I would really like a new variable, so I can report out like: 5 Wds 12 Less than 15Wds 36 null 05 Total 43 hope this clarifies my situation

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 Rob, Thanks for the excellent feedback...its given me the info I need to carry on Cheers Mike

Hi Rob Thanks for the feedback. I like the idea of keeping track of the ones I want to keep open. I'm a little unsure of how to use arrays...and how I can use arrays in this situation...hope you can help