Recent content by franksirvent

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

Hi there, I've been doing some testing and found that I have the following problem: I get error 91 on the following code (which is part 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...

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 ?