Search results for query: *

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

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

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

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

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

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

How could I go about importing many csv files 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 moment I cannot think of the...

Looking for help in creating access like subforms in a main form. I have created a sidebar like outlook on the left of the main form and depending on what button is clicked I would like a new for loaded within the main form. Any help would be greatly appreciated Regards Matt matt@begg-uk.co.uk

I am looking to export to CSV a table that has been refined via a select query. The query refines the table to new additions since the query was last run based on a flag. I am looking for a way to execute this query and then export the query from VB6. Your help would be much appreciated...

I am looking to export to CSV a table that has been refined via a select query. The query refines the table to new additions since the query was last run based on a flag. I am looking for a way to execute this query and then export the query from VB6. Your help would be much appreciated...

I am trying to form a treeview of part of my database. Parent is UK 1st child is Country 2nd child is County 3rd child is Town 4th Child is Solicitor The treeview works but with the procedure I have but it take 45secs to run. I have pasted the code below (apologies it is not commented), I was...

I am trying to build a treeview in my application based on a database. The treeview I am looking to build is going out of bounds The control is built from 4 tables 1: country (4 records) 2: county (106 records) 3: town (20018 records) 4: solicitors (54 records) I have pasted the code below, I...

I have built a MSAccess application, but in certail circumstances e.g. when a text is entered longer than the allowed length I get a messagebox with MSAccess in the message box's title bar. How can I make my app title the default for this ?? Regards Matt matt@begg-uk.co.uk

Hi I am about to start on a project that will involve the ability to send and receive email. I am not sure where to start as I do not know what email program the end users will have installed. Do I use the MSMAPI.ocx, if so how do I retrieve messages from a particular folder rather than all...

Hi I am about to start on a project that will involve the ability to send and receive email. I am not sure where to start as I do not know what email program the end users will have installed. Do I use the MSMAPI.ocx, if so how do I retrieve messages from a particular folder rather than all...

Hi :-I Is it possible to test for the presence of a file on an ftp server. I have created a procedure that will upload a series of text files that have been exported from a database. But I would like it so that the transfer would not occur if there was say an empty file called say flag.txt on...

I have several forms with check boxes and I would like it that when the check box is clear a value of "no" for that field is entered into the table and if checked then a value of "yes would be entered into the field. I managed it in a non repetative way by originally having the...

Looking at the FAQ on disabling the shift key looks great, but if you have a button to re-enable the shift key, how can you automatically disable the shift key again in a database that has been distributed Regards Matt matt@begg-uk.co.uk