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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
The right SQL-statement
Substitute, It seems DLOOKUP does not work. I guess I have to try to write a DLOOKUP-function myself, since VBS does not support it by its own. So what I am going to do, is rewriting a big part of the code, and I guess I can use a few things from your codes. Many thanks for that. Albert van...- Sovetryne
- Post #9
- Forum: Microsoft: Access Queries and JET SQL
-
The right SQL-statement
Dear Substitute, I am really very glad for your work! You have done a lot for me. But I am sorry, it doesn't work. I am using ASP (VBScript), and many functions you are using in your code does not work on ASP. E.g. declarations are without types, so Dim oDB As DAO.Database should be Dim oDB...- Sovetryne
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
The right SQL-statement
Cheerio, thanks for your reply. The problem is not "how to put dashes (or other characters) in front of the subject line", but "how to keep SUBTHREATS together". I already have a field for what you call "depth", I called it "position" :) Substitute, also...- Sovetryne
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
The right SQL-statement
It seems I am the first on the Internet having a problem with this. So either I am trying something impossible, or I am so stupid that nobody needs to write it down on any homepage. My problem is some SQL-statement. I am writing a forum (www.denemarken.prikbord.franl.dk). I use VBScript / ASP...- Sovetryne
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
