Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Parsing a string to get a value to the right of another value
MajP, you are ABSOLUTELY right! Your code works fine when I plug it into the RIGHT PLACE. :) Sorry about that and thanks!- cgherman
- Post #7
- Forum: Microsoft: Access Other topics
-
Parsing a string to get a value to the right of another value
Thanks a lot for your responses, but unfortunately, they are not working. Here are a few examples of what is happening, which is the same for each suggestion given to me. Maybe I didn't give enough info, so I hope this clarifies. Using my value of "Segment --> Energy", I get "ergy" Using my...- cgherman
- Post #5
- Forum: Microsoft: Access Other topics
-
Parsing a string to get a value to the right of another value
I have many random values like these and I need a way to grab the part that is to the right of "-->". Geo --> IPD-Embedded IA Segment --> MAG I'm using this code to grab the part that is to the left, but I cannot figure out how to alter it to get the value to the right. LPos =...- cgherman
- Thread
- Replies: 7
- Forum: Microsoft: Access Other topics
-
Running append query from external DB?
Can someone help? I'm simply trying to run an append query from an external DB from code in another DB. Assume the external DB is C:\Quad_Reduction\mdb\Admin.mdb and the query in this DB is called qryTest. Is there an easy way to do this, like with the DoCmd.OpenQuery command when you are...- cgherman
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
