Search results

I'm confused the listbox only allows me to input values from a table in a box: The wizard creates a listbox which displays a list of values from another table or query. I will type in the values that I want. *I want the listbox to get the values from another table or query. * I will type in...

Basically, person opens access database, there's a list of queries on the left hand side. They double click first one and then the other queries execute one after another. Of course, not all the queries would execute. But a good 15 for one task and then a good 15 for another task. For that other...

Thanks for responses. When you say event, so basically I can double click the first query and in the vba editor I specify that on that click, then do something?

Hey all, I'm trying to figure out a simple way to run queries one after another. For example, I have these queries: defense_query (a create query) append to defense (append query) finalize defense (create query) There's several other queries. But they will all still run successively. I did...

Out of curiousity, do you know why it still highlights AS even when I add the closing brace to the second IIF? It says missing operator in query expression. It looks to me no oeprator is missing.

Yeah but there's no other way around it. So I would just have to be aware of that.

Why would it fail? If there are matching first names and last names between the two sources, then it should return the same first and last name, with the addition of the middle initial. The chances of two names where first and last are the same would rarely happen and if it does, then I accept...

I do an initial query. It finds 95% of matches. However, the reason it doesn't find the 5% is mostly because of database contains middle initial and external data sheet doesn't or database contains middle initial and external data sheet contains entire middle name spelled out. So I remove the...

I do have normalized data, but this query is for data that couldn't matched due to differences between database data and data I need to compare it against, which is unpredictable. Sometimes data cannot be normalized in certain situations, especially with name variability. These are one of those...

FinalForgotten only contains one field called aname. The field could either look like Smith John or Smith,John. So both last and first name are in same field and delimited by either space or comma. The defense field contains three fields: first_name,last_name,middle_initial. The first_name field...

Thanks for response. I have to check if finalforgotten has a comma or not" Smith John Smith,John Smith,Jane Because if I don't, then i will get an "invalid procedure call" error.

Hey all, I have a table called FinalForgotten which contains this: aname (field) Smith John Smith,John Smith,Jane I have a table called defense_final which contains this: last_name (field) first_name (field) middle_initial (field) Smith John T Smith,John Ruby Smith,Jane Lis Marie,Ann Sam...

Hey all, I have this query, but it's giving me syntax errors: SELECT s.fullname INTO SummaryJudgment_FinalForgottenWithMiddle FROM ( SELECT( (SELECT Left([aname],InStr(1,[aname],",")-1)) As lastname FROM SummaryJudgment_FinalForgotten) & " " & (SELECT RIGHT([aname],InStr(1,[aname],",")+1)) As...

Thanks for responses. I added BrianWornock's suggestion to two empty fields in Design View and for Criteria I put the two functions. One thing is though that there's two names I am comparing: TheName of uniSelectedContacts and fullname of possibles. So basically I just want to check if middle...

Those appear to be visual basic functions. So I presume I can't incorporate them into the query itself. And if not, would I have to iterate through the records in vba and then do something with what you posted there? Thanks for response.

first name and last name will always be present. Middle initial may be in one but not in another or it may be spelled out in one (e.g. Joan) and initial only given in another (e.g. J).

Thanks for responses. For example: Heller,Gary (this had a middle initial in uniSelectedContacts but not in possibles) Auerbach,Allen (this had a middle initial of sanders in uniSelectedContacts but not in possibles) PRICE,LISA (had a middle initial of butler in uniSelectedContacts but didn't...

Hey all, I had a query taking over half hour to run. It was too long. So I cleaned up data so I could use this, which only takes less than 20 seconds to run: SELECT possibles.fullname, uniSelectedContacts.addresses, uniSelectedContacts.cities, uniSelectedContacts.us_states_and_canada...

Hey all, I have this macro below: Sub extract_deeds() Dim LR As Long LR = Range("A" & Rows.Count).End(xlUp).Row Range("B1:B" & LR).FormulaR1C1 = _ "=IF(ISNUMBER(FIND("","", A2)),A2,"""")" Range("B1:B" & LR).Copy Range("B1").PasteSpecial xlPasteValues End Sub It's...

EDITED removing duplicate records even when zip codes aren't really duplicates I am editing the question. It didn't make sense what I wrote. I have this query: SELECT * INTO KeepThese_SummaryJudgment FROM final_output_summary_judgment AS f LEFT JOIN (SELECT t.fullName FROM...