Search results

I am trying to open MX Excel using a command button. I have tried using a hyperlink a various codes that i have found online with no luck. The Excel file is being used by the Access as it bring data from the spreadsheet a displays it within a subform. (I think this is where the problem occurs)...

Hi Mihail, Of course i can help you i am not on yahoo but, if you ever need help with your English my email address is parksey_y2k1@hotmail.com

Hi Mihail, Of course i can help you i am not on yahoo but, if you ever get stuck with your English let me know my email address is parksey_y2k1@hotmail.com

Thanks for your help today!

i have sorted it now thanks Mihail! i have already turn on the the option explicit and i had already changed the names of all the textbox to suit my DB. The problem was that it was retrieving a null file so would not load fully. I have sorted it by changing: TextToFind = txtFindWhat to...

YES!! that worked thank you!!

Can someone help me debug this. I have found the error leads to this line but how can i stop the error? Run-time error '94': Invalid use of Null. Option Compare Database Option Explicit Dim Msg As VbMsgBoxResult Dim StartText As Long Dim TextToFind As String Dim TextToBeSearched As String...

Run-time error '94': Invalid use of Null This error was coming up a the start and all i have done is changed names of the textboxes. Option Compare Database Option Explicit Dim Msg As VbMsgBoxResult Dim StartText As Long Dim TextToFind As String Dim TextToBeSearched As String Private Sub...

Hi Mihail, just a quick question i am probably missing something but i am getting an error saying 'Run-time error '94': Invalid use of Null. Any idea how to stop this? it seems to refer to the line - TextToFind = txtFindWhat

Thank you, Thank you, Thank you!! If there is aything i can ever do to help you please let me know!! again Thank you this is just what i was looking for!!

HI Mihail, this function does not allow you to search the specific textbox. is there code that i could put with a button so that when i have typed data in one textbox it searches through another one (with a lot of data in) to find the specific text. Thanks.

Deal, lol! Thanks... Sorry to be a pain I have changed the functionality of doing this. I Have now decided a better and probably easier way. Is it possible to create a search box (textbox) which searches through another textbox with a lot of information in? The way i am trying to do this is i...

How do I do it?!?!

Could you use the send object function? This could allow you to push the objects in one form through to another

I am trying to allow a calendar to search through a text box with a large amount of data in which will have headings using the date so i wanted to use a calendar search. Hopefully this will be be like the find function in word where you type (or in this case select a date) then click search or...