Recent content by MattBegg

I'm creating a hierarchical dimension based on a parent child from a table, however a member doesn't have a unique id defined, it's uniqueness comes from the path it would create. eg trying to produce this heirarchy: 1 / 2 3 / \ 4 5 4 Coming from this table...

Hi there I am trying to create an offline cube from a datasource in vb. Does anyone have any pointers or code snippets please Regards Matt matt@begg-uk.co.uk

Try reinstalling PDW as there maybe some corrupt files, especially if you may have tinkered with any of the source code. Once reinstalled repacked your project and see if that works. If you want you could email your setup.lst file to me and I could have a look at it. Regards Matt...

Here is a way to add an "I accept" / "I do not accept" disclaimer or license screen to Package and deployment wizard Firstly package your project with package and deployment wizard Next make you disclaimer or license file as a text file, call it say disclaimer.txt and add...

Cheers ChipH I suppose similar code would be applicable to all of the common dialog cancel actions. Regards Matt matt@begg-uk.co.uk

Hi I am looking for a way to trap the user cancelling a print job when the cancel button is pressed on the pring dialog box. Below is my code for printing a rich text box cdl1.ShowPrinter richtxtQuote.SelPrint Printer.hDC but this coding prints even if cancel is selected Regards Matt...

Sorted it out :-) Regards Matt matt@begg-uk.co.uk

Hi I have written a procedure below to open an instance of word based on a rtf document with merge field saved. I am looking for a way to send to another email address at the same time ie Cc. I do not seem to be able to find anything in help Here is the code Public Sub sendemail(recipient As...

This may be useful John, but I am unsure as to how to create a snapshot of a report ?? Regards Matt matt@begg-uk.co.uk

I want to send it as a document asI would like it to be the message of the email, and to have it hidden it purely to help automate the process as emails will be containing different information and going to different recipients. Hope you can help further ;) Regards Matt matt@begg-uk.co.uk

I am looking to send a document created in word as an email (not an attachment). The document will have fields that will be filled with fields from an Access database. (NOT SURE HOW TO APPROACH THIS). The document is then email as thought sentto email had been selected from the file menu in...

I am looking to send a document created in word as an email (not an attachment). The document will have fields that will be filled with fields from an Access database. (NOT SURE HOW TO APPROACH THIS). The document is then email as thought sentto email had been selected from the file menu in...

cheers PaulF I had gone a bit brain dead :( Regards Matt matt@begg-uk.co.uk

How could I go about importing many csv files into an Access 2000 database all with the same structure but there is no commonality between the files names, onlt the extension. I would imagine the logic would be to loop through each file in the directory until all have been processed, but at the...