Recent content by rekrabnai

Okay, apologies for the delay but I found a 'temporary' solution on technet. MSAccess needs to be ALWAYS 'Run as Administrator'. (Although i have 'administrator' rights on my pc, this is not enough) The link for instructions was found here...

Hi all, We have recently moved to Oracle 11g and now when I try to use some current code I have created to connect to the tables on an ORACLE Server, it fails with an error 3000 ?????? 1. The names of the tables I wish to connect to are stored in an MSAccess Table (OracleTables) the field...

Just to clarify. Do you require an excel file with more than one worksheet in it (1 for each query) or an excel file with a single worksheet (all query results in a single sheet)? Sometimes if you want to put a nail in a piece of wood, you just gotta hit it with a hammer!!

This may be worth a try. I created a button on my form (btnExport) and on the 'onClick' event I wrote the following Private Sub btnExport_Click() Dim x As Boolean x = ExportQuery("qryAllArea", "C:\temp\output.xls") End Sub Public Function ExportQuery(qryName As String, ExportFName As String)...

Hi Ensure that the property 'MultiSelect' is set to 'Simple' or 'Extended' on the listbox and try the following code in your 'OnClick' event of the checkbox Dim i If chkPOSFilter.Value = True Then For i = 0 To lstARlstbox.ListCount - 1 lstARlstbox.Selected(i) = True Next i Else...

Could you post the EXACT values you have for the 'report_dir' and 'timestamp' Sometimes if you want to put a nail in a piece of wood, you just gotta hit it with a hammer!!

Hi dhookom Thanks for the reply. If you are asking if I went into Administrative toos & ODBC administrator then yes. I set both ODBC links to both the 10g and the 11g environment using the same userid and they both worked. This suggested to me that : a) There were no rights issues on the...

Hi all I created some code (which has been used without issue time and again) to create linked tables to an Oracle 10g Database. Recently one of our servers has been upgraded ro Oracle 11g and now my code will not work. The code refers to a table 'OracleTables' to get the tablenames I wish to...

Hi, thanks for the response. I should have definately added more info. my apologies. Have finally managed to resolve the issue but will fill in the blanks as it may help others if they are all as 'slow' as me. I am using a 'Print' button within the code itself and I needed just a portion of...

Hi All, I have developed a small application in .NET but have trouble printing....however, here's the 'odd' bit. Scenario 1 I use my local version of Internet Explorer to access my local version of the site (using localhost). When I click on the print button on my web page.... all good...

Hi, the only time i ever have problems with date comparisons is when the db seems to be comfused as to the format of it. eg what I think should be 8th February 09 (08/02/2009 - UK side of the pond) seems to be treated and 2nd August 2009 (02/08/2009). Is there any merit in using the following...

Hi People, Has anyone come across an issue with sharepoint where the message 'converter failed to save the file.' A user is getting an error when trying to open an Excel document from SharePoint that he uploaded. No one else gets the error when viewing the document, and he doesn’t get the...

Job Done.... Many thanks.... thankyou people... just what the doctor ordered.... I love this site! Regards Ian

Hi SkipVought Thanks for the quick reply. I obviously didnt explain it too well... it's the VB code snippet that I am after for inserting a picture into the Email itself. Thankyou anyway for the response. Ian

Hi, Am new to the world of Outlook 2007 (and its macros). Please could someone help!!! I autogenerate and email from an Access 2007 DB. All is fine except that the email contains TEXT only.I would like to create a macro in Outlook 2007 to insert a picture into the Email content. The Picture...