Dataenvironment VB parameters troubles

Similar Threads:

1.Passing parameter to DataEnvironment

Hi,

Is it possible to pass parameter to a dataenvironment?

I want it to execute a SQL query, but the query is builded using the SQL 
builder in the dataenvironment.  I want that rsMyRecordset being made on 
different table that I specify.

DataEnvironment1.rsMyRecordset.RecordCount

Something like a "SELECT * FROM " & strMyTable executed in the 
DataEnvironment1.rsMyRecordset

Can this be done?

Thanks you very much

Marty

2.Parameters in DataEnvironment

Hi, 
I am using VB6 with SQL2000 under SBS2003.

Why is tab2 (Parameters) within the DataEnvironment disabled ?
I want to add a new command, which is a SQL-statement with a
parameter (which is a public variable from the Form), like this: 
SELECT * from Table WHERE ID = m_XYZ
So the value of m_XYZ should be passed to the DataEnvironment(SQL)command.
I think, I have to set this parameter (m_XYZ) in the DataEnvironment, by 
using this tab2 (Parameters), but I cannot access the fields (adding the 
parameter m_XYZ for instance) of this tab.
I have tried the following statements, but nothing seems to work:
SELECT * from Table WHERE (ID = [m_XYZ])
SELECT * from Table WHERE ID = [m_XYZ]

In my opinion I need to use a certain syntaxis in above statement, on which 
the
DataEnvironment "regcognizes" this variable and put it in the 
(tab2)-parameterlist.

Or am I totally wrong ? Any help is appreciated,

regards, Ger.

3.Passing parameter to DataEnvironment

Hi,

Is it possible to pass parameter to a dataenvironment?

I want it to execute a SQL query, but the query is builded using the SQL 
builder in the dataenvironment.  I want that rsMyRecordset being made on 
different table that I specify.

DataEnvironment1.rsMyRecordset.RecordCount

Something like a "SELECT * FROM " & strMyTable executed in the 
DataEnvironment1.rsMyRecordset

Can this be done?

Thanks you very much

Marty

4.trouble w/ creating a VBA function that uses an enum in it's parameters

Greetings,

I have an enum that I use as a variable in a function.  If I call on
the function from w/in the VBA IDE, the enum values are displayed, but
not when I call on the function from w/in Excel.

I have tried all sorts of things, but I am at my wit's end.  Here is
the code...

Public Enum To_Unit
    eMinute = 1
    eHour = 2
    eDay = 3
    eWeek = 4
    eMonth = 5
End Enum

Public Function ChangeUnit(Target As Range, ToUnit As To_Unit) As Long


Thanks in advance, 
Jacob

5.Trouble Passing Parameters To Report

Hi

I have VB.Net project which has a Crystal Report to display some data.
The data is to come from a stored procedure I have in an SQL 2000
database, this stored procedure takes three parameters, 2 of DateTime
type and 1 of String type. I have played around with the parameters
collection but cannot get it to work properly. I do not want the
dialog box to prompt the user for the field values I want to pass
these from my code. I am confused as to how to pass three separate
parameters. I have my report set up and the parameters appear in the
field tree as they should. Does anyone know of any good sources of
information on passing parameters in Crystal Reports. The
documentation has me confused.

Many Thanks
Kim

6. Trouble with Crystal parameter - "Specified cast is not valid"

7. CR9 Trouble prompting SOME rpt parameters

8. Trouble with binary stored procedure parameter