Search results

Screen capture of a time code look up, where the description would be key to figuring out which code to use. The description field is long text and the base table doesn't have a short title.

Also would you have expected the FAYT to work with a query that is pulling from 2 connected tables? Back in a previous post, I showed where I was having issues with a joined table field.

I'm learning. My thought was that having some sort of a workflow with popups, undos and taking people to the next form to filter for the value again might help reduce the # of duplicate records in the database and reduce what I have to clean up.

Here's my existing code. Thoughts? Private Sub Define_ID_NotInList(NewData As String, Response As Integer) 'https://datatofish.com/how-to-create-to-a-yes-no-message-box-in-ms-access/ 'Enhanced Message Box Replacement...

It will be a while. I'm trying to clean up my Not on List code now that I've pulled in your FAYT capability.

My scenarios are that I have a tables with acronyms with definitions, regulations with long text summary field, codes with how they are used. In many cases, it's longer that the 255 character short text format. It's to help the deeper searches for a specific field when you need more...

@MajP Narrowing down on the issues with a couple other FAYT combos. I'd like for the FAYT combo to be able to handle the below variations to support my searching. Is it possible? 1) I know the FAYT works using just a field from one table in the query search. 2) Each of the below queries...

Thank you for the final push on the City State cascading combos using FAYT and vba code.

Any thoughts on the City State challenge I'm having?

I wouldn't disagree. It's a hodgepodge database. Unfortunately for me, it compiles. It's interesting that it's running into this error in between 2 FAYTs.

When the vba code hits the public function for the Manager_Name_ID line, it went to Public Function IsBlank, I have in the database. Hovering over the arg shows "arg = "HQDA G-1"". It then appears to be going thru every Organization value in the database on this below loop for some reason...

Making adjustments now and starting test.

Yes, and a couple other fields. Contact_Search: [prefix] & "-" & [Last_Name] & "-" & [First_Name] & "-" & [Email_Address] & "-" & [other_email] & "-" & [t_Organization]![Organization]

@MajP As I'm trying to implement your FAYT capability across my database, I've come across this situation. Error 13 Type mismatch. I've isolated the error message to the Manager_Name_ID and Assistant_Name_ID combo boxes (I commented just them out and the error went away). If we can fix one...

So how do we proceed? I'm liking this direction, just need to figure out what the actual issue is.

Closer but not quite there. The select statement changed. For example the last record I was adding "RI" for the state and the RowSource captured it. BUT when you click on the Combo13 dropdown list, it shows every option. Looking at the Query builder's results But the drop down results are...

Macro is gone, still erroring. V5 attached.

Maybe the quotes aren't quite right in the combo13_Enter code?

@MajP I put your code in and while it's still giving me a error "3061 too few parameters. Expected 1.", it's working.... Can you look around and see if you can figure out what's causing the error?

Take a look at this approach. It has a requery on the State [Combo15] that updates the City list [Combo13] when changed. The data source for the City combo has a criteria of [Forms]![f_Users]![Combo15]. I'm getting a too many parameters error, not sure what's causing it.... But it's working...