Search results for query: *

I have several .XLS files with .XLS extension. However when I open them with Excel, change anything and try to save them, the dialog box has the file name field in Quotes like this "MY FILE.XLS" and the SAVE AS Field has TEXT (tab delimited) (.txt) I don't understand what's wrong, as I...

Until recently everytime I opened a new Excel Workbook, on my Windows Start Bar I will get a new instance of Excel. However from a few days back, I get all the workbooks in the same Excel application, so all the Workbooks are displayed together, having to minimize one to jump to the next...

Hi there I have a code which creates a complex excel sheet from Access. After formatting etc the Excel Sheet, i want a MessageBox to pop up advising that "the process is finished." However, although the Excel sheet has the focus at all times (and users can see how it is being formatted etc...

Hi there i have a problem which I cannot work out whats wrong I have an Access application which runs through all the emails in an Outlook directory, which usually only contains within 5-20 emails maximum. It goes through each email and, if it matches certain parameters, it then saves the...

Hi, I am creating an excel sheet report from Access data... The VB code in Access which creates the excel report is all great, except that the Pagebreak I am trying to insert, I get an error... This is the code which supposely adds a PageBreak in the CELL selected (the_Rows is the row on the...

Hi there I have the following link which I need to use on a web page. basically the webpage needs to have a field (PO#) and a SEARCH button. When I press the SEARCH BUTTON I need it to open a new window linked to the following link, and the 123456 being the PO# as added on the PO# field...

Hi there I have a MainForm with two subforms, left and right. Unfortunately I have to much information to display on each (which are identical) so I need to set with VBA each subform to be sent to the front and/or back depending on which subform has the focus. So if the right subform has the...

Hi there I have an Access application which it looks like, after running for a while, it makes Excel not work properly. The only problem is that, when I try to open an Excel sheet, it only opens 'part of' Excel, while the sheet itself is not visible. i have noticed it happens to users which...

Hi I have a report which I would like to show the data/fields on the Group0Header section but only from the first record...after that, I need the Group0Header to become invisible. Could anyone help? thanks in advance

Hi there I have an Access form which creates a formatted Excel report when a button is pressed. It all works nicely, however the Excel sheet has a Combobox which filters the data on the sheet depending on the selection made. When the report is created, all records are shown and I would like...

Hi there I have an Access form which creates a formatted Excel report when a button is pressed. It all works nicely, however the Excel sheet has a Combobox which filters the data on the sheet depending on the selection made. When the report is created, all records are shown and I would like...

Hi there I have spent hours on this and can't understand what's going on... i have a combobox in EXCEL with 3 options, after any of the options is selected it runs the following code. It runs ok HOWEVER the first time you run it, the user gets an error: Error :1004, Failure on Method Autofilter...

Hi there i am trying to close Excel Application after I have finished with the XLS sheet and I have saved, but it leaves the main Excel Window open (the sheet itself dissapears but I want the whole of Excel to close itself) This is (part of) the code I am using... Thanks in advance...

Hi there I have the following code (part of) which goes through a folder in Outlook and saves the attachments to C:\attachments It all works well, however if there are 3 emails in the folder, it only reads the first 2. So it seems to leave 1 email till the next time code is run... Is there a...

Hi there I get this error while running the following code from Access: "User type not defined" (more or less, as it has been translated from Spanish) The code I have copied from one of the examples in this great Forum...Dim ns As NameSpace is the line giving me the problem...any ideas what's...

Hi I have a database done in Access 2000 Although it runs ok with Access 2003, I get the following error: "DLL Library Error" it happens when it reaches the following code: Set dbs = CurrentDb() <<<STOPS HERE WITH THE ERROR SQLLINE = "SELECT [No de Facturas].Id, [No de Facturas].[No] FROM [No...

Hi there I am running a loop (for 1=1 to 5000, next i etc) within VB All runs well, however the following code gives me an error If Range("'QUOTES'!A" & i).Value = Range("C3").Value then... Apparently the Range("'QUOTES'!A" & i).Value is wrong. I want to refer to a cell on Sheet called...

Hi, I have a macro which filters the excel form based on values entered on certain cells However I am unable to filter between two dates. The routine below works well, however I need the 20/07/2006 to be a variable (which is foundon CELL D4) Selection.AutoFilter Field:=2...

Hi there, I have a database with 10 fields shown on an Access form which I would like to automatically 'transfer' to 10 fields on an Internet site. The problem is that I don't know (in code) how to 'call' the Internet Window (which is opened) and, using the TAB code (I assume) go one by one of...

hi, I am creating a table via SELECT ... INTO.... etc It all runs well, however a MEMO field which is over 255 characters in length some of the data, the new table has the field as TEXT instead of MEMO How do I 'force' the query to create the new table, and keeping the correct format for each...