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!
-
Docmd.RunSQL problem... Access 2000
I used a RunSQL statement like the following in Access97, but Access2K does not like the Left and Right functions? It says they don't exists... Is there a replacement or am I going crazy? Docmd.RunSQL "SELECT [EN], (Left([EN],6) & Right([EN],4)) AS ESMA INTO [New Table] FROM [Old...- bondm007
- Thread
- Replies: 7
- Forum: Microsoft: Access Other topics
-
Docmd.RunSQL problem... Access 2000
I used a RunSQL statement like the following in Access97, but Access2K does not like the Left and Right functions? It says they don't exists... Is there a replacement or am I going crazy? Docmd.RunSQL "SELECT [EN], (Left([EN],6) & Right([EN],4)) AS ESMA INTO [New Table] FROM [Old...- bondm007
- Thread
- Replies: 10
- Forum: Microsoft: Access Modules (VBA Coding)
-
Outlook MailItem ReplyTime property???
When looking at mail messages in my Sent Items, I can see the reply time and the received time. I have successfully been able to return the received time but am unable to find a propery for the reply time. Is there any way in VBA to accomplish this?- bondm007
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Multiple Fields with Grouping & Multiple Columns(Access97)
I have a report the has 3 grouped headers and I would like to have multiple columns in the detail section for the 4th, 5th and 6th fields. Is this possible? I have already tried the multiple columns in page setup. I got multiple columns for everything (not just the detail section). Thanks...- bondm007
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
