Recent content by heathxp

Hm, I appreciate this. Would this mess up my Referential Integrity? It looks like if I do that access no longer allows me to cascade delete/update. Also, what's the recommended usage of the autonumber in this case? I never use it when I design tables. Does sharepoint use it as some Internal Id...

Hi, I'm attempting to move all the data (Tables) in sharepoint for team colaboration and data centralization. Everytime I'm attempting to export a table, sharepoint automatically resets the primary key to AutoNumber. Because I already have a ton of data in these tables, I certanly need the...

Thanks for the explanation. If I don't use .Text for the first one, the setFocus doesn't work correctly.

Thanks. Ok so I think I figured it out but I'm not sure why it's acting like this. The issue is here: filterTextsearchFirst = searchFirst.Text & "" filterTextsearchLast = searchLast.Text & "" filterTextsearchState = searchState.Text & "" If I change it to ...

I did just that and it's still the same issue? Private Sub txt_searchFirst_KeyUp(KeyCode As Integer, Shift As Integer) On Error GoTo ErrHandler Dim filterTextsearchFirst As String Dim filterTextsearchLast As String Dim filterTextsearchState As String Dim strCriteria As...

I am trying to create a form that allows you to return results based on multiple criteria. I have FirstName field, LastName field, and State Field. I also have text boxes named searchFirst, searchLast, searchState where users can input criteria. How do I build the filter so that it takes the...

Thanks arnelgp, I ended up with this solution. I wish I could hide the (New) line at the end for aesthetics but I think this is acceptable.

Thanks everyone for your suggestions. I really appreciate it. Pretty much every software I know filters the way I have in mind. You start typing text and the form starts filtering, you type too much text and eventually the form is empty because there are literally no results for whatever you...

Haha. That's the whole point why I created this thread. I just want simple and intuitive filtering. "When Filtering Form and no results are returned. Handle the search box gracefully" If I take your example and remove the message if there are no results the list will not be filtered but it...

Simply display an empty list with no results. This is possible if I change the form "Allow Additions" to true. So I might go with the solution arnelgp described to do it programmatically. Although this solution is not proactive, it will still display the * "add new record" line to the end user.

Hi Micron, thank you for those tips. Yes, both of these solutions work but I was trying to make this a bit more user-friendly and not present a message box if there are no results. Instead, I wanted to clear the list and display no results. This is where all the trouble starts.

Thanks arnelgp. This fixes the focus problem but it will leave some results even if there's no match. Meaning if I type quickly some gibberish it will still display all the results instead of an empty list.

Sure. Uploaded the file directly here. Thank you

Micron. Not sure where you see a mouse event. I'm using the key_up event of a search text box. I am indeed refocusing on the textbox everytime I filter but when 0 results are displayed, it looks the form completely removes the focus from any of the form elemets and I cannot set it back so that...

Cannot believe how many hours I spent on this. I have a form that displays some data. I have a textbox that filters the form data after each key press. It seems like VBA just cannot gracefully move on with its life if the Me.Filter returns 0 results. This error happens because this form is...