Search results for query: *

If I use CrystalRpt.ParameterFields("From_Date").AddCurrentValue CStr(gFromDate) @from_date is a string I get type mismatch

I have created a report in crystal with two parameters fields called @From_date and @To_Date and they are both strings in Crytsal. How do I pass the parameters into this report. Stuff that has ' in front of it is stuff I was playing with to try and get it to work Here is my code Dim CrystalApp...

New to using Crystal, question can i create a report with out setting up a connection to a DB and then just pass parameters to it. In the application I want to have standard parameter screens that pass over different parameters like a date range, client name, date range & clients etc. Am i able...

I kind of knew what it was but had forgotten Thank you

Sorry but the name of the combobox on the form willn't be known. i was wondering if it can be found at run time. i want to be able to use this function for different forms that will have different name for the combobox Thanks

I am trying to write a function that passes name on the current form and then loads a combobox on that form with names from a table in the DB. If frmName.Controls = combox Then cboName.Name = frmName.Controls.Name End If or something like this Do Until mrst.EOF...

I created a program at home, I copied forms, modules and the project from one machine to the other. Both computers run VB6.0 sp5 and both have the msdatagrid.ocx in the system32 folder. When I try to run form at work I get an error message about license not found. Is there anyway around this...

No i hsut copied forms, modules and project from one machine to the other and tryied to start up the project and I got this message about licensing. Any help would be appreciated.

I created a program at home, copied files to another machine. Both computers run VB6.0 sp5 and both have the msdatagrid.ocx in the system32 folder. When I try to run form at work I get an error message about license not found. Is there anyway around this issue. Thanks in advance

Thanks for your help guys I was able to get the stored procedure to work.

Thanks Bob, still having problems I have a SP in SQL called sp_add_client it has 4 parameters @Surname varchar(70), @Given varchar(70), @Middle varchar(70), @Birthday varchar(70) I connect to db using this: Public mconHS As ADODB.Connection Public mcmdHS As ADODB.Command Public Function...

Thanks one last question, can you explain this line to me Set adorsLocal = AccessADO.Execute(strSQL) I assume adorsLocal is the recordsest, but what is AccessAdo.

I have created a stored proceure in SQL called sp_add_client, it has 4 parameters (Surname, Given, Middle, Birthday). I have connected to the SQl db using ADO, adoConn.ConnectionString = "driver={SQL Server};" & _ "server=qaserver\sql2000;uid=sa;pwd=me4wsql;database=chris&quot...

I tried this code just as a test and I get a compliler error (invalid outside procedure)on the keyword SET for: Set appoutlook = CreateObject("Outlook.application") I have made reference to outlook 9.0. Any ideas?