Search results for query: *

I am wanting to add a pull-down list into a toolbar (similar to the toolbar within word which has a pull-down list for the fonts). Does anyone know how this can be achived? Thanks in advance MattN

Currently I have an import table which inserts data into temporary tables which I have manually created. Whenever I add a field to the import table I need to manually add the field to the other tables. This is obviously time consuming and primitive! Is there a Stored Procedure (or other way) I...

Currently I have an import table which inserts data into temporary tables which I have manually created. Whenever I add a field to the import table I need to manually add the field to the other tables. This is obviously time consuming and primitive! I would therefore like to be able to create...

Could anyone tell me how to add a field in an MS SQL table. This field must be;- Integer Identity = Yes Identity Seed = 1 Identity Increment = 1 Kind Regards Matt N

I would like to send an email to 2 recipients using the Mapi controls. I have tried with the semi-colon seperating the two addrersses (see below) but this soes not work. NOTE: I don't want to use a loop as I want both recipients to see that the other person has received it. MAPISession1.SignOn...

I want to use a database field as a condition in an IF statement. This has obvious maintenance benefits to the program as I can add conditions and msgbox strings to the recordset without having to update the program. For Example;- rs_Conditions contains the following records - Database Field...

I would like to execute a DTS package package using VB6. Does anyone know the correct API to use. A simple code example would be most appreciated. Thanks in advance. MattN

I have a Crystal Report 8.5 report which I need to print through a VB6 application. The report needs running three times. Each time the data source needs changing to a different database. Is there a way that I can use one CR object and update the Report datasource at run-time? Regards Matt

Can someone please tell me the TSQL syntax used to connect to a database on a different server. I am familiar with the USE command but this only works on the server you are connected to. Thanks in advance. Matt :-|

I am looking at buying a 3rd party grid ActiveX called Igrid. Any comments on this product would be mostly appreciated. King regards Matt

Can anyone tell me how to execute a stored procedure with a parameter within VB6 code. This code executed the procedure prior to the parameter being added. '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Dim Qy As New ADODB.Command Set Qy.ActiveConnection = cn...

Can anyone give me a sample of a very simple stored procedure which uses a parameter i.e. OrderNo This would be most helpful to get me started. I will figure out the rest. Kind Regards MattN

I am working with VB6 and Crystal Reports 8.5 My reoprt has two database connections. One to MS Access and one to MySQL. Both are password protected databases. How do I create two database connections to one crystal report object in my VB code. Within crystal reports I can verify databases...

I started a threat last week relating to Exporting to PDF through VB6 and received an excellent response... thread222-288038 response involved using CRAXDRT.dll How can I use this reference to Print not export? How do I specify how many copies I require? Is there a help file available for this...

I am working with VB6 and CR 8.5 When working with the CR preview pane I can manually select export to disk.... PDF format. However, the OCX does not allow me to select PDF format through code. Why is this? Can anyone help? Regards Matt N

I have crystal reports prof. 8.5. When I export a report from this machine in Word format it exports fine. When I export the same report from another machine it looses lots of its formatting. How can I export the report on this machine so it shows its correct format? Regards Matt N

Does anyone know have to perform a conditional count. I have a PO number in a repeating group and want to keep a running count of a sales figure (which is also in the repeating group) only when the fields value is greater than £100. I can then summarise the total number of PO's with a sales...

I am passing values to formulas in CR 8.0 pro through Vis Basic Code ie. Report1.Formulas(1) = "ADSNum = " & rstHEADER!ADSNum rstHeader is a Numeric field containing the Value 10010. When the report prints the field it prints 10,110.00 Is there a way I can format the formula so it...