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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Extract Characters from Left through pattern "||"
I have a key text field (created in Cache)i.e., 1||987, 2345||2, 567||24. What I want to extract are the number (characters) after the || pattern. So I want to return 987, 2, 24. A little help would be appreciated.- jimdltn
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Perform subquery in different order
How would I rearrange or rewrite this query to perform the AdminSurvey filter before it grabs the Max Date between dates? As written, it Selects the Max Dates in the date range and then filters out the AdminSurvey and I loose data. What I want is to find all records that are not AdminSurveys and...- jimdltn
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
-
Error Loading non-existing Form
I have DB created with Access 2000 and I am opening it with Access 2003. I am getting Visual Basic Error message: An error occurred while loading 'Form_Bose'. Do you want to continue loading the project? If I press no, I get the message repeated. If I press yes it goes away. This form no longer...- jimdltn
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
