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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Use filter on 2 search criteria on a form
I've tried to search on the forums, but couldn't find my answer. I have a question I know it's working on one criteria as follows DoCmd.ApplyFilter , "DATE like #8/5/2002#" Is it possible to use applyfilter on 2 search criteria? Thanks- peini
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
-
replace part of the field
I've tried to use the update query to update the table, I thought I can use replace function but it doesn't work, any other way to do it Thanks. Update table1 Set col1=replace(col1,"-","") Where instr(Col1,"-")>0- peini
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
-
Microsoft vbscript regular expressions 5.5
I need to reference "Microsoft vbscript regular expressions 5.5", so I can use RegExp object. The path for that is c:\winnt\system32\vbscript.dll\3 I could do it in Access 2000 (cause it's already show on the reference list, p.s. you couln't type in the path, it won't recognize the...- peini
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
query between startdate and enddate
I have created a QBF, which depends on what the search criteria users enter into the form. The form variables will be feed into the query criteria dynamic. The problem is I want the user be able to search based on the date, there're startdate and enddate on the search form, and those are all...- peini
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
