Search results

Hello everyone I have a datasheet in split form view. I've added some functionality to it by including a search bar that filters the datasheet based on whatever the user types in. As well as two combo boxes that filter the datasheet based on whatever the user selects. Everything works fine and...

It works, I made the silly mistake of not changing [Complete] to [WSIB Employer Declaration Complete?]. It works perfectly now. Thank you Ridders and everyone else!

Wait a sec, I think I know what I did wrong

I appreciate all the work you put into this. However, when I went to try your code, I was prompted with the Complete dialog box. I typed "Yes" and got some results back. When I clicked on "No" or "All", in the dropdown, nothing came at all. Again I know this is a complicated task. Believe me I...

Hmmmmm...well, I have implemented the code (thanks to MarkK). The datasheet does filter based on yes,no or all. However when I clicked "Yes" the record with (Jan 18/17) is absent. I will continue to play around with it. But this is closer than what I had before. Thank you.

This worked beautifully. Thank you everyone!

Hi Ridders Thank you for your reply. I tried both methods in the after_update property and I get two errors. The first one: Private Sub ComboWSIB_After_Update() Select Case Me.ComboWSIB.Value Case "All" Me.FilterOn = False Case "Yes" Me.Filter = InStr(1, [WSIB Employer...

Hi I put "Yes" just as a test run. And the following error I get is Compile Error: Variable Not Defined with Yes being highlighted. The combo box is set as a Value List (Row Source: "Yes";"No";"All"). I will keep trying and re-look at your reply with the text delimiters. Thank you.

Private Sub ComboWSIB_Click() If (ComboWSIB.Value) = "all" Then Me.FilterOn = False Else Me.Filter = InStr(1, [WSIB Employer Declaration Complete?], ”Yes”) = Me.ComboWSIB Me.FilterOn = True End If End Sub So I tried implementing this code but I still get the...

I tried that but nothing shows up in the combo box. I also I just realized, in the column itself (WSIB Employer Declaration Complete?) some of the records have extra text, for example one record it yes "Yes(Jan 18/17)". How can I have the combo box to display Yes,No,ALL without any of the extra...

Hi everyone So I have a datasheet in split form view. One of the columns is called "WSIB Employer Declaration Complete?" and is has values yes or no. I'd like to add a combo box where the user can select either yes, no or all and based on their selection retrieves either, the records where WSIB...

Actually, it's ok. I got a previous mentor to look at it and they gave me some valuable insight. Thanks though.

Hi sorry I forgot to mention that in the split form view, the datasheet is on the bottom and text boxes bound to their respective field are on top (e.g. Agency, Email, Contact, and Programs, etc.). Programs is the field set as a combo box and all it's items are acronyms (i.e. FHP). Whenever the...

By "multivalue field" I'm aware that this combo box isn't retrieved off another table or query. So whoever inputted these must have done it manually so there fore a Value List. And here is the code in the form Option Compare Database Option Explicit Private Sub cmdReset_Click() Me.txtSearch =...

Hi everyone So I have a datasheet in split form view with 6 columns visible and I have a search box that filters as you type based on data that's in all 6 columns (e.g. user types in "smith" and the query looks if this is present in at least one column and gives me back records where this is...

Never mind guys, I got it working. Turns out it was a matter of correctly naming the variables in the vba. Thanks as always!

Right now it's very messy but I forgot to mention, here is the VBA associated with the search text box Private Sub SrchText_AfterUpdate() Me.SrchText.Requery End Sub Private Sub txtSearch_Change() 'Create a string (text) variable Dim vSearchString As String...

Hi everyone, My goal is to make a search bar in a split form. For now, I want to keep it simple and have the datasheet filter by organization/agency name. Here's the query I have so far: SELECT AgencyINFO.[Organization Entity/Agency Name(Legal Name)], AgencyINFO.[Subsidary Name]...

Hi everyone, So I'm sure many of you are familiar with the famous idle time detection code from https://support.microsoft.com/en-ca/help/128814/acc-how-to-detect-user-idle-time-or-inactivity. I wanted to make a slight change to this code where the users are automatically logged off. The code is...

By this do you mean, essentially importing everything into this empty database? I've heard doing this would be beneficial just never did it before