Recent content by oni29

Thanks for the suggestions. Due to time factors and my coding skill, I've just gone with the concatenate suggestion.

I'm extracting data from Oracle into a local Microsoft access database. The data stored in access is then used by a number of local staff. This approach is being used due to issues with creating views in the Oracle database & giving Oracle access to everyone. One of my local tables has the...

My code is as follows: Const szConnect = "Provider=MSDASQL;DSN=FGBTS-prod;" Public Function getOrder_status(numOrder As Long) As String On Error GoTo getOrder_status_error Dim rsData As ADODB.Recordset Dim szSQL As String szSQL = "select Status from tblOrders...

Hi, Below is the Excel 2002 VBA code that I am using. FGBTS-prod is an ODBC connection to an Access 2002 database. Public Function ADODBtest(numOrder As Long, Optional strFilter As String) As String Dim rsData As ADODB.Recordset Dim szConnect As String Dim szSQL As String On...

I'm working on some custom Excel functions. They extract data from a Microsoft Access 2002 database. The database is located on a shared Network drive in Windows. What is the best method of extracting the information? At the moment I'm using DAO. The code looks something like: Const DBPATH =...

That is the way it is spelt in Australia =) I have added the code tags into my post. That look any better?

Hi, Am gradually teaching myself VBA. Below is some of the code I've written. I'm looking for any suggestions around optimising it. Private Sub cmd_Update_tblOrders_local_Click() Dim intButtonPressed As Integer ' Check that the user does want to proceed with this action...

I'm using the following code to run queries: -- Dim stQuery As String stQuery = 'INSERT SQL HERE' DoCmd.SetWarnings False DoCmd.OpenQuery stQuery, acNormal, acEdit DoCmd.SetWarnings True -- Is there a way of seeing how many records the query returns?

I'm currently running three main queries in my Access database. They are accessing data stored in a remote Oracle database. What is the best way to find out: * How much data each query is returning? (Kilobyte size) * How long each query is taking to run?

I don't know that much Oracle Unfortunately I don't know that much Oracle. Setting up a new database connection & running simple queries is the extent of it. My goal is to have a simple local store of important data. I then use other applications (Excel etc..) to import the relevant bits.

I didn't think of that Unfortunately it has been a while since I touched SQL in general. I didn't think of getting the query to handle inserting the data. I've found changing the query to an 'Access Make-Table Query' works quite well. I'm now using the above approach to generate three local...

I'm using the following tools/systems: * Oracle 9i Enterprise Edition Release 9.2.0.5.0 * Microsoft Access 2002 * Access is running on a XP Professional desktop What I'm doing at the moment is: * Linking the Oracle tables in Access via ODBC * Using Access to run develop & run queries against...