Re: Is there a Stuff() Function or equivalent in MS Access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx>
Date: 7 Oct 2009 01:46:28 GMT

=?Utf-8?B?a3dfdWg5Nw==?= <kwuh97@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:16F52760-181D-4DAF-A5B4-9C397500B1AF@xxxxxxxxxxxxx:

"David W. Fenton" wrote:

"Albert D. Kallal" <PleaseNOOOsPAMmkallal@xxxxxxx> wrote in
news:#cWa4uhRKHA.4592@xxxxxxxxxxxxxxxxxxxx:

Note to readers here, the stuff() function is near identical to
our mid() function WHEN you assign a value on the LEFT side

That's the Mid() STATEMENT instead of the Mid() FUNCTION, right?

I knew it existed but have never found any situation where I
needed it.

Could you elaborate?

On what? My ignorance?!??

Read the help file. If search for Mid() in VBE help in Access,
you'll get two answers, Mid() Function and Mid() Statement, each
with its own Help article and example code.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

References:
- Is there a Stuff() Function or equivalent in MS Access
  - From: kw_uh97
- RE: Is there a Stuff() Function or equivalent in MS Access
  - From: Dorian
- RE: Is there a Stuff() Function or equivalent in MS Access
  - From: kw_uh97
- RE: Is there a Stuff() Function or equivalent in MS Access
  - From: Jack Leach
- RE: Is there a Stuff() Function or equivalent in MS Access
  - From: Dale Fye
- RE: Is there a Stuff() Function or equivalent in MS Access
  - From: kw_uh97
- Re: Is there a Stuff() Function or equivalent in MS Access
  - From: Albert D. Kallal
- Re: Is there a Stuff() Function or equivalent in MS Access
  - From: David W. Fenton
- Re: Is there a Stuff() Function or equivalent in MS Access
  - From: kw_uh97

Prev by Date: Re: what is the difference between a 2dimentional array and a reco
Next by Date: delete warning
Previous by thread: Re: Is there a Stuff() Function or equivalent in MS Access
Next by thread: Re: Is there a Stuff() Function or equivalent in MS Access
Index(es):
- Date
- Thread

Relevant Pages

Re: Access 2007: Creating a local relationship between two remote ODBC tables
... since you're altering something in a Jet MDB ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
(comp.databases.ms-access)
Re: App Crashes on Compact & Repair
... only import into a new MDB from a decompiled and compacted source, ... some of the corrupted code could be carried over ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
(comp.databases.ms-access)
Re: Access not Installed on Pc, Are user still able to use application?
... I'm running an A2K-format MDB in the runtime, ... developed in A2K3. ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
(microsoft.public.access.externaldata)
Re: Snow Storm
... He has an email waiting. ... Uh, please don't interfere. ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
(soc.motss)
Re: Where is the best gay place to live?
... You should be able to figure out who is plonkable by reading a ... couple of posts. ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
(soc.motss)