Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 29th, 2005, 06:14 PM
Authorized User
 
Join Date: Jul 2005
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to rocknrisk
Default Memobox Challenge

Hi all,

Here's a challenge. I do have to do this in a project I'm working on though , so really do need some direction.

I have a Memobox on a Form in which we will copy and paste 6 lines of text - Name, Address1, Address2, Region, Email, Telephone.

I would like to do 2 things:
1. Extract Name, Region, Email, and Telephone
2. Split Name in to Surname and FirstName(including any initials)

Any ideas guys? I'm not looking for code, just directions and ideas. I've not worked with text and memo boxes, or Strings for that matter.

Thank you in advance.
Clinton
 
Old July 29th, 2005, 06:25 PM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Clinton,
Where are you getting the lines to paste from?

Kevin

dartcoach
 
Old July 29th, 2005, 06:53 PM
Authorized User
 
Join Date: Jul 2005
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to rocknrisk
Default

Hey Kevin,

Copy and pasted from and intranet page.

Cheers,
Clinton
 
Old July 29th, 2005, 07:02 PM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Clinton,

Will there be any type of formatting from the intranet page?
I.E.
Line1: LastName,FirstName, MiddleInitial
Line2: Region

etc.

Kevin

dartcoach
 
Old July 29th, 2005, 07:31 PM
Authorized User
 
Join Date: Jul 2005
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to rocknrisk
Default

Hi Kevin,

Name: Clinton Blah
Address: 123 The Road
RM12 4JP Mytown
Email: myself@here.com
Telephone: 1236754987

This is how it translates to text... the forum does that... it would be in HTML in a table... hope that helps... Cheers

Cheers,
Clinton
 
Old July 29th, 2005, 07:36 PM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Clinton,

I know it's late across the pond, but a couple of questions.

1. Is this data stored anywhere else after it's input?
2. Can you cut and paste me EXACTLY what the data would look like?

Kevin

dartcoach
 
Old July 29th, 2005, 08:09 PM
Authorized User
 
Join Date: Jul 2005
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to rocknrisk
Default

Kevin,

How do you turn HTML on on here. Can you? I could paste it as it would be formatted. Only thing, if I use a memo box, it will change it to text. No?

To 1:
Yes - a table mtblContacts - fields: chrFirstName, chrSurname, chrEmail, chrRegion, chrTelephone

Hey, don't worry about the time. I'm working nightshift... And I really do appreciate your help...

Cheers,
Clinton
 
Old July 29th, 2005, 08:12 PM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Ok,

Can you access the table mtblcontacts directly?

By they way - I sent you an email through the forum so if you can check your email, we can correspond outside the forum.

Kevin

dartcoach
 
Old July 30th, 2005, 02:36 AM
Authorized User
 
Join Date: Jul 2005
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to rocknrisk
Default

Kevin,

Thank you for all your help. You are a star. Greatly appreciated.

Cheers,
Clinton





Similar Threads
Thread Thread Starter Forum Replies Last Post
DGV with MemoBox, Datetimepicker rhd110 General .NET 1 April 23rd, 2007 07:27 AM
A little challenge... chacquard Access VBA 7 February 2nd, 2007 11:38 AM
A Challenge... AForgue XSLT 3 November 5th, 2003 04:14 PM
Challenge.... developerz BOOK: ASP.NET Website Programming Problem-Design-Solution 2 September 29th, 2003 04:49 PM
Very tricky challenge 12th_Man SQL Language 3 June 20th, 2003 06:45 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.