Re: Identify Delimiters

From: "Albert D. Kallal" <PleaseNOOOsPAMmkallal@xxxxxxx>
Date: Wed, 17 Oct 2007 00:39:19 GMT

Line Input #1, str1

if instr(str1,";") > 0 then
str2 = Split(str1, ";"))--the days when semi-colonis used
else
str2 = Split(str1, vbTab)--the days when tab is used
end if

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx

.

References:
- Identify Delimiters
  - From: Roy

Prev by Date: Re: need help on count over a second group in Access reports
Next by Date: Accessing a table field
Previous by thread: Re: Identify Delimiters
Next by thread: Re: Identify Delimiters
Index(es):
- Date
- Thread

Relevant Pages

Re: Moving between forms
... you could use a tab contorl...and that would allow 15 pages... ... you launch another form to the SAME record. ... Albert D. Kallal (Access MVP) ...
(microsoft.public.access.forms)
Re: in vb how do I have the enter key move to next line?
... In the properties for the text box, in the "other" tab, you will find a ... setting for enter key behaviour. ... Albert D. Kallal (Access MVP) ...
(microsoft.public.access.forms)
Re: disable background forms
... Simply set each form to model (in the other tab). ... A very large portion of my forms are thus model... ... Albert D. Kallal (Access MVP) ...
(microsoft.public.access.forms)
Re: Print All VB Code for a Project
... For the forms tab, go select all, and them MAKE SURE YOU click on he options ... and de-select the controls..and everything else..you want JUST the ... Albert D. Kallal (Access MVP) ...
(microsoft.public.access.formscoding)
Re: Pass variable between forms
... Dave Hargis, Microsoft Access MVP ... Albert D. Kallal ...
(microsoft.public.access.formscoding)