Search results for query: *

Hi All, Want to copy from an array to excel worksheet. Is this the best way: Sub test() Dim vARRAY(10000) As Variant Dim i As Integer Dim ws As Worksheets For i = 0 To 9999 vARRAY(i) = i Next Worksheets("Sheet1").Range("A1", Range("A1").Offset(i...

Hi, Been out of practice of coding for a while, please can you tell me if there is a better way of doing this. Should I be using a recordset clone ? Cheers SK Function flag_wrong_move() On Error GoTo ERR_HANDLER Dim db As Database Dim rst As DAO.Recordset Dim sSQL...

Hi Guys, I have an issue with connections. I am able to connect to an Oracle 10g database using SQL Plus. Here are the steps I complete. 1. open a SQL Plus window 2. type in username, password and hoststring. Connects with no issue. Now if I run the same thing using command line...

Hi JB, Actually the solution is to capture historic cases and enhance the data. It's a tactical solution. The solution will also be used to capture 30 or so additional data fields that do not exist in current data feeds. Indeed this is for "large" company. MS Access forms are event driven...

Hi Guys, Sorry if this has been done before. I am hoping to use MS Access as a front end connecting to Oracle. I will be using ADO to connect to the DB. It is envisaged that the solution will be rolled out to over 200 users. I can see that the IT department will not want to use MS Access...

Hi Guys, I've had a look on the net and searched on here for an answer to the above error. I believe that it has something to do with SP3 of Access2003. I am trying to execute the following: [code/] Function FrmSave(sFrmName As String) On Error GoTo ERR_HANDLER If...

Hi All, Need to add the form to a collection which has been defined as a public var. Cheers SK

Hi Guys, Sorry if this has been answered before, I have searched and the sad thing is I have done it before !! I want to open multiple instances of a form. I know that I have can use the following : [code] Dim frm As Form Set frm = New Form_frm_FULL_RECORD frm.Visible...

Hi Roy, Thanks for your answer, I'll check out the thread. Cheers SK

Hi All, Thanks in advance, this is probably an easy one ... I want to check that an array has a value in it, have tried [code] not isEmpty(vArray(0)) [code] I get Run-time error '9' Subscript out of range I've tried checking that the ubound(vArray) > 0 Any ideas ? Cheers SK

Hi Guys and gals, It's been a log time since I've been on here !!! Just a quickie, I want to run (execute) a stored procedure in Oracle 10g. I have put the folowinmg systax in a spreadsheet: begin proc_name; end; set the following in MS Access query properties: 1 saveed the connection...

Hi Thanks for the answer I used the format event, I actually found out a minute after posting (as per normal!!!) Cheers SK

Hi All, I want to set the value of a textbox at runtime using the reports open event. I did the following me.txtBox.value = "XXXX" and it returned a 2448 error you can't assign a value to this control. Is there a way of doing this without converting the textbox to a lable and doing...

Hi Dagon, The cursor returns fine however the number of rows update is zero. I wonder if the problem is in this: WHERE REPLACE(ff.acbs_facility_reference, '/', '_' ) = v_SYS_FAC_ID.SYS_FACILITY_ID ?? SK

Hi Guys, I'm actually a Sybase boy but doing a little Oracle at the moment. I'm trying to update table 2 based on the results of my cursor: CREATE OR REPLACE PROCEDURE Step4a IS v_SYS_FAC_ID FACILITIES%ROWTYPE; CURSOR lcur_name IS SELECT * FROM FACILITIES x WHERE...

Hi Guys, I'm actually a Sybase boy but doing a little Oracle at the moment. I'm trying to update table 2 based on the results of my cursor: CREATE OR REPLACE PROCEDURE Step4a IS v_SYS_FAC_ID FACILITIES%ROWTYPE; CURSOR lcur_name IS SELECT * FROM FACILITIES x WHERE x.src_sys_code =...

Hi Guys, It's been a few years since I've used SQL Server/ Sybase...I may have to write an application with SQL Server as a back end and MS Access as a front end. I was aiming to write stored procs on the back end which I would call using ADO. I have a few questions... 1. I need to have a...

Hi Guys, what is the maximum number of rows you can load into a combo box? I am using row source type "Table/Query" and the rowsource is a select query. The table contains 160k rows! Cheers SK

Hi Guys, I am having a problem with a form which I hide at start up using the following: DoCmd.OpenForm "frmLogDetails", acNormal, , , , acHidden This form has code on it running on a timer. I am having problems with the form unhiding itself randomly. Has anyone else had this problem...

As per normal you find it as soon as you post on here... Simple set cycling to current record.