Forums | Help | Site Map

Join Bytes
Login

network: 226,471 (2259 online)

bytes

Substrg command in Access

shivnesh is offline

Newbie

Join Date: Feb 2007

Posts: 4

#1: Feb 26 '07

I am using Access 2000.
I need Substrg command in Access 2000.
Kindly send the SQL script for the same in Access 2000.

dorinbogdan dorinbogdan is offline

dorinbogdan is offline

Expert

Join Date: Feb 2007

Posts: 822

#2: Feb 26 '07

re: Substrg command in Access

Use the Mid function.

shivnesh is offline

Newbie

Join Date: Feb 2007

Posts: 4

#3: Feb 28 '07

re: Substrg command in Access

Thanks for your reply.
kindly teach me how to use mid function in Access SQL editor

shivnesh is offline

Newbie

Join Date: Feb 2007

Posts: 4

#4: Feb 28 '07

re: Substrg command in Access

Thankyou.
Kindly teach me how to use mid function in access SQL editor

dorinbogdan dorinbogdan is offline

dorinbogdan is offline

Expert

Join Date: Feb 2007

Posts: 822

#5: Feb 28 '07

re: Substrg command in Access

Expand|Select|Wrap|Line Numbers

 
' Creates text string.

Dim TestString As String 

TestString = "Mid Function Demo"

' Returns "Mid".

Dim FirstWord As String 

FirstWord = Mid(TestString, 1, 3)

' Returns "Demo".

Dim LastWord As String 

LastWord = Mid(TestString, 14, 4)

' Returns "Function Demo".

Dim MidWords As String 

MidWords = Mid(TestString, 5)

Reply

« previous question | next question »

Similar Microsoft Access / VBA bytes

Access 2007 Runtime Error When Clicking Access Close Button (answers)
Combo box, command button placement questions (answers)
Limiting Command Line Executable (answers)
Problem with command buttons on switchboards and forms. (answers)

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,471 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml

it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved