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

Hi All I think this can be done... I want to stop the return key from moving to the next record. I do not want to disable the return key by setting on key down on the forms event. Cheers SK

Hi All, Is there a way of asigning anything other that Yes/ No to the keys on a message box? Cheers SK

Hi Guys, I'm having a problem with a hidden form which appears to unhide it's self when I open other forms. Is this a known issue within MS Access, has anyone else experienced this? I use this form as a means to run some code on a timer. Cheers SK

Hi Guys, Normally the problem is the other way around, however I want to return the drive letter from a UNC path. Anyone got any ideas how to do it? Thanks in advance. SK

Hi Guys, I need to return the query name or table a report uses as it's source using VBA code. I had it working taking the data from the Namemap property but this has stopped working. Any ideas... Cheers SK

Hi Guys I have an annoying problem. I am sure it's a really quick fix. Here goes. I'm typing in the VBE window. I stop for a sec and then the cursor moves back a space. How do I stop this? Also if I type a " it will automatically add a second " Cheers SK