Search results

Hello again, I have a table with 4 fields DomA, Name, Domain, Account. I have 2 queries made, the first pulls the records Based on a specific name in the domain field, so the data I have is DomA and Domain. The second query pulls Does the Same only it excludes the records from the First...

Found the Answer for that as well, add & vbcrlf in the recordset loop, for the strText line now for mine it is .. strText = strText & RS!Name & vbCrLf removed the comma and space. works great.

Okay after a little more work, I was missing a space once that was done had a little more playing around and Now it works great. Now if I could drop the ", " and put one per line it would be the best thing ever. but I can work with this. Thank you very much.

Seem to be what I'm looking for but I replaced your sql string with mine and It error out syntax error in from clause, the query is SELECT qry_PICStatus.Name, qry_PICStatus.user_id, qry_PICStatus.user_id_type FROM qry_PICStatus WHERE (((qry_PICStatus.user_id_type)="y")); So in your...

It queries from another query. table is a list of AD accounts, first query verifies the status, the 2nd query (the one that has the list of names I need) shows me the disabled accounts, I want to write those in to the text box once verified against another query in another table I want to write...

Hello, Here is what I'm trying to do, I have a select query that holds anywhere between 1 to a couple hundred records, I need to take the Name field and populate a textbox which after verification I write to a text file that I later use in a powershell script. So far have tried using VBA to...

Just checking in to see if anyone has any idea's yet.

I have a DB that holds multiple possible email responses, originally set up for just straight up create email based on this information. the Button to created the email works great. Now what I would like to be able to do is Click a 2nd button that instead of creating a new email, it would open a...