Search results for query: *

Hello, Does anyone know how I could use PL/SQL to find all the file names that are in a specific folder? Thanks, Tim

Hello, I'm using FtpWebRequest - I can succesfully FTP files, but can't find a way to set the Proxy server. I've got this far and got stuck: Dim ProxyServer As IWebProxy Dim webProxyUri As New Uri("ftp://my_ftp_proxy") ProxyServer.Credentials = webProxyUri result.Proxy = ProxyServer Any...

Hello all, I'm currently migrating some code from VB6 to .NET v2. In VB6 I populated the list box with the code below, using Channel_ID as the index. I can't find a way though to do this in .NET. Has anyone any thoughts? lstListBox.AddItem !Channel_Name...

Hi Has anyone got sample code on how to read an XML file using PL/SQL? Thanks in advance Tim

Hi I have a fairly large Access db (about 1GB) that has been working absolutely fine. Now everytime i attempt to edit some code, or insert new code it deletes the line and gives me an 'out of memory' error Looking at the help it says reduce the amount of public variables - I have 10 of them...

Hello, I open a ADODB recordset using the following SQL (using the connection string CurrentProject.Connection), and the recordset is NULL. If a paste the SQL into an Access query and run - it returns 4 records. I don't understand - is anybody able to shed light on this please? Thanks in...

Hello, I use the following function in a query. It doesn't return any result in the field - but also doesn't return an error. Can you see what's wrong? Thanks in advance Tim create or replace package body UKTV_TOOLS_PKG is FUNCTION Get_Ready_For_TX_Flag(v_prog_media_id NUMBER) RETURN...

Hello, The following query produces an error 'Operation must be an updateable query'. There are many records in dbo_media_audit to one in tbl_Bcst_t_media_root. How can I get round this please? Thanks in advance, Tim UPDATE tbl_Bcst_t_media_root, dbo_media_audit SET...

Hello I'm running a query parameters with dates, which runs from 2 further subqueries. If I set the parameter time to a couple of days, it executes with a minute or so. If i put it to 10 days it can take upto an hour. Is there any system parameters I can change here to speed things up - is...

Hello, I have two fields - date & duration I would like to have a table in the bottom of my report (the report shows each line) showing the duration summed by week. Is this possible? Many thanks Tim

Hello, I would like to add a Primary Key based on Columns House_Number & Prodn_code - but the below doesn't appear to work....anybody any ideas? Thanks Tim ALTER TABLE tbl_bcst_t_ver ADD PRIMARY KEY House_Prod TAG House_Prod ALTER TABLE tbl_bcst_t_ver ALTER COLUMN House_Number...

Hi The following SQL takes an exceptionally long time to run (over 15 mins) - and is only deleting 500 rows. Has anyone any thoughts on how to improve it, or an alternative way of doing it? strSQLString = "DELETE * FROM tbl_Bcst_T_srs WHERE tbl_Bcst_T_srs.Series_ID NOT IN (Select...

Hi I am changing users Outlook autosignature by code - first copying a template to their profile and then setting a registry value, which is : [user sid]\software\microsoft\office\10.0\common\mailsettings. The value name is NewSignature of type REG_EXPAND_SZ. I initally thought I could pass...

Hi, I'm attempting to get a users SID using loopupaccountname. Would anyone know how to find it using the function please? Public Declare Function LookupAccountName Lib "advapi32" _ Alias "LookupAccountNameA" _ (ByVal lpSystemName As String, _ ByVal lpAccountName As String, _ Sid...

Hi, Could anybody suggest a cheeky bit of code that would check if an NT service is running on a specific machine please? Thanks Tim

Hi there, I would like to embed to SQL from query 5 into query 6 as I need to embed the SQL in code outside of access. Would anybody be able to tell me what the combined string would be please? Query 5: SELECT tblScheduleDataForExport.HouseNumber, dbo_Prog_Versions.Version_Sys_Id...

Hi, I have 20 or so text boxes on a Word doc - named txtTextBox1 txtTextBox2 txtTextBox3 etc Firstly - can you set them up as a control array as you can in VB? If not, is it possible to reference them through a FOR loop rather than having to reference each explicitly, eg For i = 1 to 20...

Hi there, I'm using XP Home Edition. When the machine arrived on my desk in wasn't booting - I recovered the system files using the Recovery console. The system now boots - but freezes both in normal & safe mode. Recovery console now asks for an administrator password which the user doesn't...

Hi there, Attempting to connect to the server through SQL*Plus and I get the error message "TNS Protocol Adapter Error" - ODBC is working fine, tests are fine - TNSPING is ok - I can view the linked tables in Access fine Any help greatly appreciated! Thanks Tim

Hi, I have 2 tables: tbl_Bcst_T_Ver tbl_Bcst_T_Prg A field exists in both called House_Number. The field in _prg is populated uniquely, _Ver is empty. I need to update the contents from _prg into _ver - understanding some records may duplidate (a one to many relationship exists) I thought...