Search results for query: *

When do you use Set to assign a value to a variable, and when do you use Select? Set @var1 = 50 or Select @var1 = 50 What if you need to result of a query, like this one: Select @var1 = count(*) from table1

The following is code that works in VBA that utilizes the Excel function "Median" from an Access module... Dim objExcel As Excel.Application Dim dTemp As Double Set objExcel = New Excel.Application dTemp = objExcel.Application.Median(1, 2, 5, 8, 13) .................. I need to be...

I am having trouble referencing values in Frames. <FRAMESET COLS=35%,65%> <FRAMESET rows=30%,70%> <FRAME NAME=LEFT src=Task6.asp frameborder=0 scrolling=no> <FRAME Name=BottomLeft Src=Task6Bottom.asp frameborder=0> </FRAMESET> <FRAME NAME=RIGHT src=Task6Right.asp> </FRAMESET> If the...

Insert a record in one of the tables on the distribution database and check that in 5 minutes, the same record appears in the subscription database. hope this helps, Chris Dukes

No problem...

I need to know how you are calling them from VB. Please post your code.

Is there a way of setting every thing up within the setup.exe (I use Installshield)? -I use Installshield, too, but I haven't tried to do this. I will look into this and if I find anything, I will add it to this post. Does every PC need to have Oracle Client installed ? -Yes, and you have...

paqguy, Try this... Dim crpParamDef As CRAXDRT.ParameterFieldDefinition Dim crpParamDefs As CRAXDRT.ParameterFieldDefinitions 'Open report for manipulation Set crpReport = crpApplication.OpenReport(ReportFilename) 'Create a variable to relate to the report parameter fields Set...

The fields have probably been defined as CHAR(10) rather than VARCHAR(10) Char (10) will always create a field that is 10 characters long. This will be filled with spaces if the fields is actually chorter than 10 Character. VARCHAR(10) will hold any number of characters upto 10...

oops! I forgot to end the procedure. Create or Replace Package HCC.MMA_TYPES AS TYPE ref_cursor IS REF CURSOR; PROCEDURE Plan_Events ( v_sorgid IN varchar2, events_cursor OUT ref_cursor ); END HCC.MMA_TYPES; / Create or Replace Package Body...

Try this in SQL Worksheet. Create or Replace Package HCC.MMA_TYPES AS TYPE ref_cursor IS REF CURSOR; PROCEDURE Plan_Events ( v_sorgid IN varchar2, events_cursor OUT ref_cursor ); END HCC.MMA_TYPES; / Create or Replace Package Body HCC.MMA_TYPES IS PROCEDURE...

No, you do not need to specify the cursor. For clarification, I am going to paste a copy of a vb call to a procedure that I use everyday as well as the procedure that was called. '****************************vb********************* Set cmdStoredProc = New ADODB.Command With cmdStoredProc...

The following sub calls a procedure that doesn't have input parameters. If you do have input parameters, you would need to include the following for each parameter: Dim nParam1 As New ADODB.Parameter 'This next part should be placed right after you set the command type. Set nParam1...

My DSN is a system one. I have isolated the cause? Well Sort of... the DSN works fine until I load Novell client software on the machine. Once that is loaded, you can't log one user off and another one in and have them use the DSN. You have to reboot before a new user can access the DSN. Even...

I still haven't found a solution. Should I post this question in a different forum? I need help here...

I figured I needed to do that, but I'm having trouble with getting it to work... I've added a standard code module called module1.bas in module1 under General Declarations, I've placed: Public objexcel As Excel.Application Public objWorkbook As Excel.Workbook Public objWorksheet As...

I installed MDAC 2.7 on a Windows 98 second edition machine that was already running Oracle 8.0.5 client. When the machine rebooted from the installation, I was able to create a DSN using msorcl32.dll, and run my application. When I logged off, and let another user login to try the...

I had the same problem, so I took DariceLR suggestion &quot;I thought ActiveForm may be of use...&quot; When you call a modal form from a non-mdi form, you reference that forms objects by using the syntax: FormName.object.property I simply replaced FormName with mdiFormName.ActiveForm...

If you go to the properties section of project, and select &quot;Component&quot;, you will see three options for version compatibility. If you do not want to break your Interface, select Binary Compatibility and use the Browse button to select the version of the object that you want it...

dparikh, I am not sure if this is what you want, but here goes. I would create a Sub that is called when each control(SSN, FromDate, and ToDate) changes. I don't see in your code where you populate the SSN, but I am assuming that you have a combo box with them in it. Public Sub sqlReport()...