473,406 Members | 2,549 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Substrg command in Access

I am using Access 2000.
I need Substrg command in Access 2000.
Kindly send the SQL script for the same in Access 2000.
Feb 26 '07 #1
4 1766
dorinbogdan
839 Expert 512MB
Use the Mid function.
Feb 26 '07 #2
Thanks for your reply.
kindly teach me how to use mid function in Access SQL editor
Feb 28 '07 #3
Thankyou.
Kindly teach me how to use mid function in access SQL editor
Feb 28 '07 #4
dorinbogdan
839 Expert 512MB
Expand|Select|Wrap|Line Numbers
  1. ' Creates text string.
  2. Dim TestString As String 
  3. TestString = "Mid Function Demo"
  4. ' Returns "Mid".
  5. Dim FirstWord As String 
  6. FirstWord = Mid(TestString, 1, 3)
  7. ' Returns "Demo".
  8. Dim LastWord As String 
  9. LastWord = Mid(TestString, 14, 4)
  10. ' Returns "Function Demo".
  11. Dim MidWords As String 
  12. MidWords = Mid(TestString, 5)
  13.  
  14.  
  15.  
Feb 28 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Klaus Baumgarten | last post by:
Hi! I' m sitting here now for days and I still get no conclusion on my problem. I have an MS ACCESS .mdb File and I would like to export it with dtswiz.exe (from MS SQL Utility Tools) via...
2
by: Chris Bolus | last post by:
I'm a teacher using MS Access on an RMConnect 2.4 network. On some workstations both I and my students sometimes get an error message when attempting to insert a command button on a form which...
5
by: randyelliott | last post by:
Good Day, I have a MS Access (Access 2000 now upgraded to 2003) database that tracks customer information. One function of this database is to create an encrypted license file for our software,...
4
by: FluffyCat | last post by:
New on November 29, 2005 for www.FluffyCat.com PHP 5 Design Pattern Examples - the Command Pattern. Since you all enjoyed the Visitor Pattern so much yesterday, today I have the Command Pattern...
14
by: Kevin | last post by:
A couple of easy questions here hopefully. I've been working on two different database projects which make use of multiple forms. 1. Where's the best/recommended placement for command buttons...
2
by: tonytony24 | last post by:
Hi All: I was wondering if there's a simple way to call a MS Access Module through either Command Prompt MS Script any other way... Thanks for the response.
13
by: Terry Olsen | last post by:
I'm using OleDb to connect with an Access Database. I have anywhere from 10 to over 100 records that I need to either INSERT if the PK doesn't exist or UPDATE if the PK does exist, all in a single...
5
by: Tony | last post by:
I am continuing to develop an Access 2007 application which was originally converted from Access 2003. In Access 2003 I was able to disable the Access Close button in the top righthand corner of...
4
by: sarabonn | last post by:
hallo everyone, Iam using access database and visual c# 2008. Iam tried to insert data into table with lot of method but nothing works, i dont know what is wrong. here...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.