MitchR
Last Activity: Feb 4 '21, 06:53 PM
Joined: Oct 16 '06
Location: Greenville SC
-
Thank you so much! I really appreciate your insight, and you are so right! -
Access Query Criteria - working with a Domain "\" user list.
Howdy Folks!
I am working on a project where I have been given Domain\Username s (Contoso\JSmith ) and my data dump has records containing the Domain\ and no user name, Domain\administ rator, and Bogus Domains that I need to remove with delete queries. I am looking to isolate both the left and right of the "\" to remove garbage items, but I need some assistance in doing so. I have attempted to use the following:
...Code:Right([tbl_users].[user_list_Column],InStr([tbl_users].[user_list_Column],'\'))>""
-
MitchR replied to Parse first name space last name from email address containing first dot last namein AccessTeam,
Thank you so much for everyone helping me!
NeoPa, Your solution was absolutely on point. I cannot say thank you enough. As awkward as the query solution can be, it is absolute gold for my process on this app.
I really appreciate everyone's assistance and patience on this one.
Thank you again!
P.S. Indenting my code has been a tremendous help! Thank you!Leave a comment:
-
MitchR replied to Parse first name space last name from email address containing first dot last namein AccessHi NeoPa,
Thank you so much in helping me with a solution. I am so sorry, I was just a little frustrated at the time I wrote my post. The answer to the question is that my formula is from a Query. I was looking for a way to parse the data from within the query itself.Leave a comment:
-
MitchR started a topic Parse first name space last name from email address containing first dot last namein AccessParse first name space last name from email address containing first dot last name
Howdy folks,
I am living the Access Dream as always but, I am in need of some helping hands here. I am looking to find a way to obtain First name space Last name from an email address of firstname.Lastn ame@Domain.com. My table Status_and_Upda tes has a column of Email_ADDR and I want to parse out the Firstname space lastname out of the email address. I can parse out the first name with a left function and I have tried and tried Right and Mid... -
Everyone, I really appreciate your taking time and a great deal of patience out of your day to help me with this app. Thank You!
Rabbit,
Thank you for giving me another way to solve this one! If you have a minute, I would love see about using an update query as you suggested. I would like to optimize the OP as much as possible. Being able to run the Update Query from a SQL statement inside the sub would be awesome. But I will...Leave a comment:
-
Team,
Thank you! Thank you! I really appreciate your time and patience with me and my code. I have been spinning in the mud to make this work and NeoPa's solution was the skeleton key to the lock. I went through and indented all of my code right off the bat. It is so much easier to follow now. Twinnyfo is absolutely on point about fldvar. It is awesome!
The purpose of the op creates an email in outlook and I have a similar...Last edited by zmbd; Jul 13 '18, 04:54 AM. Reason: [z{stepped the code so that it is easier to read}]Leave a comment:
-
RecordSet Do Loop having condition or move to next condition
I need some process help for moving next in a do loop when the if statement condition is met. I am opening a recordset that contains 3 date fields and a serial number. I have 4 If statements.. My Update statements are working well but I cannot figure out how to process the operations to move to the next record and execute the action consistently
1.) If the FirstEmailDate field for the serial number record is not populated then populate... -
MitchR replied to Extract first name space last name from email address with first name dot last namein AccessThank you @twinnyfo and @NeoPa! NeoPa's solution worked like a surgeon's scalpel with a perfect extraction!Leave a comment:
-
MitchR started a topic Extract first name space last name from email address with first name dot last namein AccessExtract first name space last name from email address with first name dot last name
I need some help folks. I am trying to extract the first name space last name from an email address containing first name dot last name. I was able to complete a work around to extract first name. Then I am to extract the last name but not "subtract" the "@Domain.co m from last name portion of the string. I know there is a way to perform this operation with one function.
John.Smith@Doma in.com
I need to... -
My goal is to have the listing of computers connected to my back end @ 2:00am local time emailed to me. I have the lotus notes code working, and I am able to see all of the computers logged in from debug.print. Unfortunately; when I receive the email using Adezii's solution I only see one computername listed. I can see all of the headings. Let me post my entire solution.
...Code:Public Function ShowUserRosterMultipleUsers() DimLeave a comment:
-
Capture debug.print of users logged into database
I am looking to capture the Debug.print of computers connected to the backend of my database. Using the Microsoft example I can see the list of computers connected to my backend. I would like to capture the information displayed in the debug.print and send to my self in an email.
...Code:'Output the list of all users in the current database. Debug.Print rs.Fields(0).Name, "", rs.Fields(1).Name, _ "", -
Need Assistance adding a second series to an excel chart with VB.Net
Hello all! I am in need of some guidance .... please! I am able to place a single series of chart data with my code but I cannot for the life of me figure out how to add a second series. I can add the Series ... I can Select the series but cannot with out errors figure out how to put data the the series' that I am creating ... PLEASE Help! Thank you in advance
Ol' Mitch
xlApp.ActiveCha rt.SeriesCollec tion(1).Values =... -
Thank you so very Much for all of your help!Leave a comment:
-
I do have enough and everything looks great Thanks to all you ... I really appreciate everyone's time and effortLeave a comment:
-
Thanks I will try and let every one know !Leave a comment:
-
Great Questions;
1.) If duplicates exist but where none of them has a [Notes] value of null
Is this possible? - This is not possible.Leave a comment:
-
sorry I edited my replyLeave a comment:
-
Ultimately I DO want to remove all duplicated records leaving one original record containing Serial, Asset, and Name. Furthermore I would like to have the record that is left behind be the record containg notes in it. Otherwise leave one record and move next. This process would batched and run daily thus removing the duplicated records continually, but also allowing fresh new (unduplicated) data to added to the table to worked by the user.Leave a comment:
-
Thanks for Clarifying! The purpose in using code to remove the duplicate entries was that in my searches on the web to remove duplicate entries, I found this to be simple and viable option. Unfortuneately when I executed the code; it worked to well! Meaning that of three duplicated records one of which having text in the notes field... the record with the text would be deleted leaving a record with not text in the field. as this is a used app by...Leave a comment:
No activity results to display
Leave a comment: