Search results for query: *

it says Excel Bookwork

thanks, but Ive done a seach and personal.xls file doesnt show up....no add ins ib eleive as I just reinstalled excel...

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

dear xlhelp thanks !!! that does it !!! I must have unticked by error !!!!! thanks again !!!"

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 thanks both for your input The second option Hap007 advises works well so I'll stay with that. Thanks again!

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

...of the module which has the problem already mentioned) I believe this might be causing the problem Find below part of the code. I am marking with ***** the line which is causing error number 91: If anyone can see the problem, I'll appreciate you tell me what I have done wrong. Thanks Set...

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

that works! great ! thanks!

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

thanks! that's what I was looking for ! thanks again

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 Cindy thanks for your input. I have thought about resizeable pops but, at the moment, I would like to see if there is a way of doing it via VBA instead for a number of reasons (I don't want people having to resize the subforms, etc etc) AceMan, I am not sure what you are trying to say but...

Thanks for your input I cannot use the TAB CONTROL because I must be able to see both forms at once...even if one of them I can only see 80%, the fields which I do see are important. I have to be able to check the left subform with the right subform at the same time. Any other ideas ?

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

yes, I can several reports opened from the Access application but they are closed after we are finished with them. The problem still occurs even if all excel sheets are closed.

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

THANKS MATE !!!! great ! it works great !!! exactly what I was looking for !!! thank you again !!!

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