Recent content by gsfmike

Hello, I am performing a find and replace in a sheet and after the find, when I select replace I am confronted with a open file request. I can't seem to find any mention of this issue in this forum. Google brings up nothing similar. Thanks in advance for anyone who may have experienced this.

Thanks to all. I have started the exercise with VBA. It seems that I have quite a bit to learn. Looking past the 'columns and rows' is quite interesting and powerful. Your assistance has helped me solve my initial issue. Again many thanks.

Bluedragon, I am using vlookup(x,range,x,x) to return the price that I wanted. I will play around with the SUMPRODUCT - which I'm not at all familiar with and get back to you. Thanks again

Bluedragon, Thanks for such a quick response. The lookup colum is a series of product numbers and the second colum holds an effective date colum 3 is a price for the date I tried to do a second lookup, however I did not have a clue how to structure an 'if' statement.

Scenario of data: 12345 6/01/04 ... ... 12345 7/02/04 ... ... 23456 7/15/04 ... ... 32345 6/01/04 ... ... 32345 7/02/04 ... ... 66456 5/12/04 ... ... Is it possible to have vlookup get a 'HIT' and then use a second value to return the correct entry? 12345 is the first value, however I want to...

Ken Thanks for the help. That little piece of info has started the old wheels churning and has helped with many other forms. Please ignore the previous question. It does not apply!!

Ken That was a wonderful solution. Took me a few tries but it works great. I had to create a new query however and the query added brackets to the criteria. Just for info only, any idea why the query could not be modified and work? Thanks very much - you helped out tremendously.

I have a form based on a query where a date is being requested. It populates the form nicely. Currently the requery pops up the request from the query to enter a new date. Not very elegant. I am trying to have a field on the form accept a new date and on the update event requery based on...

mudstuffin, thanks for 'knocking' up the piece of code. It worked. I really appreciate the insight into the use of macros/code to help with other tasks.

I appreciate your repsonses. I was hoping this was not going to be the case, but I guess that it does make sense. The integrity of the sheet would be completely lost if there was a quick method to simply remove the links. Thanks again

I appreciate the quick repsonse Crespy. The links I am speaking about are linked spreadsheets. I can use - Edit - Links to view and or update the linked sheets, but nowhere is there a delete action that I can find. A review of the help files only mentions what you offered. Any other...

I am attempting to remove links in a spreadsheet. The help files only speak about hyperlinks. Can anyone give me some insight into how to accomplish this? Many thanks

I want to switch a form view from Form to DataSheet with a command button. I figured it was as simple as changing the default view to datasheet (Me.defaultview = datasheet) but error 2136 occurs. Can anyone help with this? Thanks

Bryan, Lesson learned.... when things don't make sense - Restart: I created another simple form and the code in the After Update event worked as it should (The form was closed). The problem seems to have been I chose the On Exit event. That event won't allow the form to be closed, in either...

WildHare; I have uncomplicated the process.... but I can't leave it alone as to why the close function is causing the error. I wanted this to be a simple - Enter value - Display information - continue. (Too much information confuses some of the folks here.) Anyway ..... I will spend some time...