Search results for query: *

Thanks MDXer I will give it a go....

Thanks MDXer. I have had a look at attunity but do you have to pay extra to use as it looks like you can only download a trial version?

I am new to SSIS so here goes. I have managed to extract data from Oracle 10g (10.2.0.4) into a SQL Server 2008 database. I have transformed some of this data ok in SQL server bu I also need to load some of the summarised data back into Oracle and I can load some of this back into Oracle using...

It looks like we will never know what happened! I have looked at it this morning and the broken reports are all working fine??? Very strange....

Hi, We are experiencing some really strange behaviour from soem of our Crystal XI reports. When we browse the data in the fields it displays the information we would expect however if you create a formula with that field the result is blank (it's not null as we tested for that). The reports...

thanks for the info. We were hoping there would be a way of updating the existing schedules!!! It's is such a palaver to re-schedule reports in Enterprise as you have to start from scratch and we have around 150 to do :-<

We currently use Business Objects Infoview to schedule and email reports (Crystal reports) to different users on a daily basis. We have recently changed database servers and have updated all our reports to retrieve the data from the new database server. However, we have noticed that none of the...

Thanks for your comments, I think I will leave it looking like it is !!!

hi alex, I basically create some ADO recordsets and then loop through sticking data into appropriate tags. This an example below of how I put stuff in; This bit sets where I want to be (this gets very laborious when I am down to the 8th or 9th level!)... Set objRootElem =...

it looks ok in IE. I have just seen another tek-tips thread http://tek-tips.com/viewthread.cfm?qid=1372353&page=1 that basically sticks a textnode with a vbcrlf in after each element I add if I want it to look nice. I am not sure if I have the energy to go through all the elements and do...

I have written a vba routine in access that looks at a 3 of tables in an Oracle database and then puts all of that into an xml file. This works ok and the file works as I can upload it into the required website. However the actual file itself looks pretty ugly when not viewed through something...

thank you Remou it was the wildcards and yes I am using ADO!!

...tblEMSdata.GIVENNAME2, tblEMSdata.LINE3 " strSQL = strSQL & "FROM tblEMSdata WHERE ((" strSQL = strSQL & "(tblEMSdata.FAMILYNAME) Like ""*" & Chr(39) & "*""))" rst.Open strSQL, CurrentProject.Connection, adOpenKeyset which then produces the following query, SELECT...

Hi Remou, I have compacted and repaired to no avail. I have cut and paste the contents into word and it has a character count with spaces of 2200. I am beginning to think your suggestion of a separate table maybe the way I should go....

...into the table. Below is the line that is fails on; rst.Fields("request_desc").Value = rst.Fields("request_desc").Value & vbCrLf & vbCrLf & "********* Request Updated by " & strFullName & " - " & Now() & " ********** " & vbCrLf & Me.memAddDesc I have also attempted to use Docmd but get the...

Thank you RoyVidar! a rethink is called for, I have already spent long enough trying to work around it! Rainbow Rabbit

Hi, I have searched the forums for an answer to this much asked question but I can't find one that fits the bill! I have a form which has a subform on it. The main form simply has a date picker field and a combo box with codes in. The form allows you to select a a code and a date and you press...

Just what I needed, Thanks PHV!!

...in a string but i would like to save it as a hyperlink in the table I have created. I am using the following bit of code; rst.Open "select * from tblAttach where 1=0", cnn, adOpenKeyset, adLockPessimistic rst.AddNew strAttach = ahtCommonFileOpenSave(InitialDir:="C:\", Filter:=strFilter...

why embed it indeed!! thanks for waking me up to myself MajP!