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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: IamreallyStuck
- Content: Threads
- Order by date
-
Problem using 'Replace' to trim string
Hello, I have a module that strips square brackets from any strings which may contain them. It works fine, unless the string passed into the function is empty, in which case the function returns '#Error'. I've tried to rewrite it to stop this from happening, but i'm new to Access and VBA so I...- IamreallyStuck
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Substitute text in string
Hi, I'm having trouble with using 'Substitute' in my query. I have a table containing two fields, 'Squares' and 'For'. 'Squares' contains text enclosed in square brackets, and I want to get rid of the square brackets but keep the rest of the string. 'For' sometimes contains the word 'for'...- IamreallyStuck
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
-
Conditional field display problem
I am new to Access, so this may be easy to do, but it has got me stuck! I have two fields in a table: 'FilmTitle' and 'Responsibility' The 'Responsibility' field contains details about Film directors, producers, actors, etc. What I need is that if the 'Responsibility' field for a record...- IamreallyStuck
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
