I have a table with two fields. I wish to separate all the data in
one field and keep it listed against the information in the other
field. The information within the field TicketStatus, I wish to
separate is
separated with a small box, meaning a tab .There can be up
to twenty separate bits of info in the field.
I would like to get a table in which the information in the field I
am trying to separate (TicketStatus), is individually listed against
the info in the
other field. I am using Access 2000
eg of entry in TicketStatus:
02/01/2007 14:23:35 EDT: Problem Closed. tab 01/04/2007 09:05:31 EDT:
PD Report Published.
tab 01/03/2007 10:37:38 EDT: Problem opened. tab 01/03/2007 12:00:24
EDT: Problem updated.
I have written the tab for illustartion purposes,but you will
understand the same.
Any Suggestions?
Roy 1 3639
On Mar 4, 9:59 am, "Roy" <praish1...@yah oo.comwrote:
I have a table with two fields. I wish to separate all the data in
one field and keep it listed against the information in the other
field. The information within the field TicketStatus, I wish to
separate is
separated with a small box, meaning a tab .There can be up
to twenty separate bits of info in the field.
I would like to get a table in which the information in the field I
am trying to separate (TicketStatus), is individually listed against
the info in the
other field. I am using Access 2000
eg of entry in TicketStatus:
02/01/2007 14:23:35 EDT: Problem Closed. tab 01/04/2007 09:05:31 EDT:
PD Report Published.
tab 01/03/2007 10:37:38 EDT: Problem opened. tab 01/03/2007 12:00:24
EDT: Problem updated.
I have written the tab for illustartion purposes,but you will
understand the same.
Any Suggestions?
Roy
We'll call your existing table [tblOld] and assume its structure is:
TicketNo: Long Integer
TicketStatus: Memo
Create a new table called [tblNew] with the following structure:
TicketNo: Long Integer
TicketStatusIte m: Text(255)
The following code will split the memo field into individual items:
Sub SplitMemo()
Dim rstOld As DAO.Recordset, rstNew As DAO.Recordset
Dim items As Variant, thing As Variant
Set rstOld = CurrentDb.OpenR ecordset( _
"SELECT TicketNo, TicketStatus FROM tblOld", _
dbOpenSnapshot)
Set rstNew = CurrentDb.OpenR ecordset( _
"tblNew", _
dbOpenTable)
Do While Not rstOld.EOF
items = Split(rstOld!Ti cketStatus, vbTab, , vbTextCompare)
For Each thing In items
rstNew.AddNew
rstNew!TicketNo = rstOld!TicketNo
rstNew!TicketSt atusItem = thing
rstNew.Update
Next
rstOld.MoveNext
Loop
rstNew.Close
Set rstNew = Nothing
rstOld.Close
Set rstOld = Nothing
End Sub This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Shyguy |
last post by:
I want to create two buttons on a form. One would allow the user to
Copy the contents of the current records memo field, the other would
allow them to print. I set up a report based on the memo field, and
it works. But, it seems wrong since I had to create a huge text box to
accommodate memo fields with a lot of text.
Thanks for any help,
ShyGuy
|
by: Jeremy |
last post by:
I have a pretty straightforward database that is designed to record
free-form information about products (date, source and a memo field).
This is searched and updated via a form. For new records, the memo
field is usually filled by cutting and pasting from e-mails, web
content and spreadsheets.
The only problem is that some of the memos can be just a few words,
and some can be tens or hundreds of lines, and I've realised that
zooming...
|
by: GorDon |
last post by:
Hi,
I have a report based on a query. The query grabs a memo field from
my main table, yet when I display the memo field in the report it
truncates the memo field (the field needs to hold more than 255
characters). The table holds all the memo text, but the query seems
to truncate the memo field to 255 chars?
This seems like there should be a relatively easy fix, but I can't
seem to find it.
|
by: RMC |
last post by:
Hello,
I'm looking for a way to parse/format a memo field within a report.
The Access 2000 database (application) has an equipment table that
holds a memo field. Within the report, the memo field is printed within
the detailed area. The problem is, the apllication is not setup
properly, thus the users are entering data within the memo field as:
location1 1/1/2005 1/1/2006
|
by: Roy |
last post by:
Hi All,
I have a table in A2K application.I get a memo field via download from
a .csv file.The contents are as below:
field name is TicketStatus,
For example,a single ticket,TicketID 12345 has a track history
contained in TicketStatus field.It starts right from problem opened
until problem closed with date/time.
| |
by: kaplan.gillian |
last post by:
Hi everyone,
I currently have an Access database that includes quite a few
long memo fields. When I create a report of my data, Access
does not allow the memo fields to be split with the page breaks.
In other words, if my memo field is 3 paragraphs long and there
is only space on a report page for 2 paragraphs, rather than
putting 2 paragraphs on one page and the last one on the next
page, all 3 paragraphs are moved to the next page...
|
by: Roger |
last post by:
I've got two tables in sql2005 which have an 'ntext' field
when I linked the first table in access97 last week using an odbc data
source the access-field type was 'memo'
when I link the 2nd table today, it is linked as a text(255) field,
ditto for the first table if I link it today
if I link the 2nd table using access2003 (and the same odbc data
source) it is linked as a memo field
|
by: ARC |
last post by:
This is mainly a speed question.
In this example: I have a QuotesHdr table that has a few memo fields. If
these memo fields are used extensively by some users, and if their are a
large number of records in QuotesHdr, should I break out the memo fields
into a separate table? The thinking here is that, for Quotes selection
dropdowns that display all entries in QuotesHdr for selection, I would think
that the entire record comes down over...
|
by: AdrianJ1980 |
last post by:
Hi,
I apologise for not providing a code basis for my question, but i really am stuck.
Does anyone know how i can split a memo field, such as below, into separate records. (The data comes from the body of daily system generated emails that the database is linked to)
Single Field:
AUS 123 $450 $396 -4 N
AUS 456 $2560 $2860 300 N
AUS 789 $987 $2 -985 P
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |