Search results

Yes the combos have 2 bound columns (with ID hidden). I take it you merged all of them into a single search button? Will give it a try and let you know. Much appreciated.

i won't use the AND and OR for that last one as it will make things way too complicated. So it's only gonna be AND

I kept the checkboxes mostly for consistency to be similar to the other 2, but if it unnecessarily complicates things, I can do without. The combos contain lookup values like position, interviewer, rating etc.. the only textbox is for a feedback field.

No they are not part of an option group, the 2 boxes on the left each search in a different table, and I need to do the same for the 3rd one. List box on the right displays results, and textbox below is only temporary showing me the constructed sql statement just to double check.

Private Sub cmdPerson_Click() On Error GoTo errHandler Dim msg$, title$ Dim cptn$ Dim SQL$, where$ Dim fn%, ln% title$ = "PEOPLE SEARCH" ' Commence construction of SELECT statement for list box's RowSource SQL SQL$ = _ "SELECT ID, " & _ "[Last Name] & chr(44) & chr(32) &[First...

Hi everyone, I am building a search form for my DB, and added 5 checkboxes, with comboboxes/textboxes next to them to let the user make a search selection. They are cbPosition, cbDepartment, cbInterviewer, cbFeedback, cbRating and cboPosition ,cboDepartment ,cboInterviewer ,txtFeedback...

Cheers mate.

Hello everyone, I found a function online that returns years/months/days for a date difference, and using it in a form to give me a contract duration between 2 dates. But the result textbox displays #Type! before entering the dates, how do I keep it blank instead? Am pretty sure it's quite...

Cheers mate, will give it a shot.

I have a large data set that I split in 3 for data entering to speed things up so it will be (I hope) a one time thing. I have 3 different people entering the data (each one with a different set, but there might be a couple of duplicates that we missed in the original set that I will delete...

Hello everyone. I have 3 similar databases containing multiple tables with different data, that I need to merge into one. How can I do it while preserving data integrity since the main AutoID will change. Let's say 3 tables Contacts Interviews JobHistory Interviews and JobHistory will have...

I am an old school access user where we'd make tables for everything to enforce referential integrity. It's not gonna be a big db, so no harm done here. I've created a basic db and also added an excel with some data. As I said, I mostly need to figure out what work should be done in excel, prior...

I am aware of that, but other than manually entering names, what would be the best approach?

Hello everyone, I am an ex access developer, but haven't done any work in the past 15+ years so am quite rusty. Would love it if you could give me some insight as to how to proceed with my issue(s). I've decided to get out of retirement and help a friend of mine who's in HR, and migrate her data...