Search results for query: *

Within SSIS 2005 I am using the YTD function within a calculation of a cube. Now I want to use a function which returns the sum of a field from the beginning untill now. For example: 2006 Jan: 100 2006 Feb: 100 .... 2007 Aug: 100 Time parameter: July 2007 YTD: 700 (7 months x 100) All: 2000...

Sorry about my late reaction (holiday). Thanks for your efforts. This will do the trick. Exactly what I want. Frans

I have a report showing multiple chapters and paragraphs: Chapter 1 Chapter 2 Paragraph 2.1 Paragraph 2.2 Paragraph 2.3 ......(number of paragraphs may vary) Chapter 3 The paragraphs are in the detail section and have a Force New Page after section. Chapter 1 is on the Report...

Thanks, it give me hint to make the follwing function: Public Function CheckCombinatie(strCombinatie As String, Optional strReferentie As String) As String Dim i As Integer Dim iAantalLetters As Integer Dim ascCombinatie As Integer ascCombinatie = Asc(strCombinatie) iAantalLetters =...

I want to search a string for the "R" only, (so lowercase ("r") is not valid). So I hoped the Instr function would do the trick, but it doesn't. There is no difference between R and r. And I can not search voor the ascii value (Asc("R")=82); I cannot get the instr to work with that. Can anyone...

Can someone help me with building a function which returns the right weeknumber (according to ISO: first Thursday of a year=week 1). Thanks, Frans

Thanks, But where should the on error statement be? On form_open event? I cannot get the right trigger / event. Do you know? Frans

I have a form based on a SQL-server table. In the table you cannot enter duplicate keys (e.g. debtornr). I want to display a neat message when someone enters the same debtornr. The current SQL-server message looks quit frightening to a lot of users. Which event do I have to trigger? I tried...

From VBA I would like to do the following: 1) Open Excel with a given file (read only if possible) (A2=value, B2=A2*2) 2) Edit the value in a specific cell (say A2) 3) Recalculate 4) Read the value from a specific cell (say B2) 5) Close Excel, without saving changes Extra: If more users run...

I created a cube in which I can drill through (in analysis manager). In Excel I use Pivot table to access the same cube. Unfortunately I cannot use drill through: "Cannot show details for current item" Drill-down works. User rights are set to as much as possible. Idea's? Frans

No, I have not found a solution for this. It seems that there needs to be an external tool to index everything. Maybe SQL 2005?

I managed to start a sql-job from Access. ============================================= Public Sub fnExecuteSQLjob(strJobName As String) Dim oSQLServer As SQLDMO.SQLServer2 Set oSQLServer = New SQLDMO.SQLServer2 oSQLServer.LoginSecure = True oSQLServer.Connect "server-name"...

Can someone help me with the rigt vba code for starting a job or a local package within SQL-server? I have made a local package and from that package I created a job. I would like to start the local package or the job from Access. Frans

I have checked the hard drive and no prbolem for size. I have used Enterprise manager and Query analyzer to restore the database. No command line tools (I am not familiar with that yet). Right clcicking in EM doesn't give me the options you described. The database is marked suspect and I can...

A normal restore doesn't work ("device error or device off-line") dbcc checktable only works with online databases, but that is exactly the problem: I cannot get it online. I have tried to put the databse into emergency mode, but still I cannot get to the tables. Please, are there any more...

I am trying to get a mdf and ldf file to run again. This is about my last chance to get it right (no good backups...) First I tried to make a new databse and point to the mdf file: "this is not a valid file" SQL server says. Then I made a new database with the same name, stopped SQL server...

No, not via data > Refresh Data. I installed an add-in from Microsoft for the analysis services. Now I have an extra menu item called Cube Analysis. In that menu there is an option called Refresh sheet. Unfortunately it looks like it is not programmable by code. Any more hints? Frans

This is all John: (nothing important) Sub Macro1() ' ' Macro1 Macro ' De macro is opgenomen op 10-2-2005 door Frans Mientjes. ' ' End Sub

I have made an OLAP cube and connect to it using Microsofts Cube Analysis add-in for Excel. When I make changes to the design or change criteria I need to refresh the sheet. Sometimes it doesn't refresh properly and I always have to refresh each worksheet (about 25!). A macro for going into...

Thanks vongrunt, That was my missing link.