Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ulwitch

    Set vs Select to assign local variables?

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

    Need help with Excel Functions

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

    I am having trouble referencing val

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

    replication (in sql 2000)

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

    VB/Crystal/Oracle

    No problem...
  6. ulwitch

    VB/Crystal/Oracle

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

    VB+Oracle+Distribution

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

    Crystal Reports parameters from Visual Basic

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

    extra space added

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

    Getting recordset to VB from Oracle Stored Proc

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

    Getting recordset to VB from Oracle Stored Proc

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

    Getting recordset to VB from Oracle Stored Proc

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

    Getting recordset to VB from Oracle Stored Proc

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

    Oracle 8.0.5 Client and MDAC Installation Problem

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

    Oracle 8.0.5 Client and MDAC Installation Problem

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

    reference excel object created in sub

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

    Oracle 8.0.5 Client and MDAC Installation Problem

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

    Multiple Instances of Same Form, Moving Data to Orig. Form fr. Modal

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

    COM question

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

    Combo Box Value

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

Part and Inventory Search

Back
Top