Kamis, 31 Oktober 2013

Re: [belajar-access] Auto Requery/Refresh daftar pada combo box

 

Pak Momod, mohon maaf kalau saya reply lagi...adakah alternatif lain jika dari combo box hal tersebut tidak bisa dilakukan?

Salam
HW


2013/10/26 Heru Wibowo <heru.wibowo4456@gmail.com>
 

Dear all,

Sepertinya memang jika langsung di lekatkan di Combo Box tidak bisa diterapkan yah?

Salam,
HW


2013/10/23 Heru Wibowo <heru.wibowo4456@gmail.com>
 
[Attachment(s) from Heru Wibowo included below]

Dear All,

Rekan-Rekan...tolong dibantu.
Saya ingin menampilkan data yang muncul di combo box hanya menurut kata yang diketik saja, tidak memunculkan semua daftar yang ada.

Pendekatan/idenya seperti pada field search-nya google, jadi jika ketik kata maka hanya akan memunculkan kata- kata yang identik (like) saja.

Jadi pada intinya daftar combo box hanya akan menampilkan daftar yang identik (like) saja.
Berikut lampirannya.

Demikian, mohon bantuannya yah.

Salam,
HW




__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___
Diposting oleh di Tidak ada komentar:

[belajar-access] Kekuatan data microsoft access

Dear milliser access,
Mau bertanya,Saya membuat aplikasi dengan microsoft access 2003,aplikasi billing rumah sakit dengan inputan sekitar 300 orang perhari,dengan 2 komputer,yang jadi masalah kadang ada problem data hilang,apakah access kurang kuat untuk solusi penyimpanan data,disamping itu juga lambat,ada solusi lain utk access sendiri biar data bisa lebh kuat dan cepat pengaksesan datanya?
Terima kasih sebelumnya
Sent from my BlackBerry®
powered by Sinyal Kuat INDOSAT

------------------------------------

SPAM IS PROHIBITEDYahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)

<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/

Diposting oleh di Tidak ada komentar:

[MS_AccessPros] How to combine several memo fields into one memo field? Why bother?

 

I really, really, really wouldn't do this. You can't sort on memo fields - i.e. if someone writes something you want, you have to skim the memo messages to find it, unless you have a tag/topic field to sort.
The only time I use a memo field is when I'm writing up a listing to sell something. That record also has a tag field, so that I can find and sort the memos by item (subject).
I make notes on books I've read, and comments on stocks I'm interested in using a text field. In both cases I have a seq field that I use if a comment runs longer than the text limit. 1 is the first part of the comment, 2 is the second part, etc. It's easy enough to concatenate fields.

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

[MS_AccessPros] Informix stored procedure?

 

I'm so close but still no cigar.  I find numerous examples on how to execute an Informix Routine (Stored Procedure) using ADO, but for reasons I have not yet figured out, the 'user defined function' fails at the >>>

 

Function ExecuteProcedureAdox()
    'Purpose:   Execute a parameter query using ADOX.
    Dim cat As New ADOX.Catalog
    >>>Dim cmd As ADODB.Command
    Dim lngCount As Long

 

I have a 64bit install of Windows 7, IBM Connect (IBM Informix ODBC Driver) 4.10.00 and I've tried using both Access 2010 Pass-through query and simple module.  The module simple fails (see above) but the pass-through (Call "sp_agent_state_data"('2013-09-01 00:00:00','2013-09-03 00:00:00')) runs several minutes before returning an empty table.

 

Have any of you tacked this before and can tell me what I'm missing?  I'd really rather not re-create the routines if it can be avoided.  Thanks!

 

Craig

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

RE: RE: [MS_AccessPros] How to combine several memo fields into one memo field?

 

Thanks for your reply as well, John! I am grateful for all of your helps. Tim 



---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:

Tim-

It would help to know the layout of your tables. If you have multiple memo
fields in one record, that won't work. You need one record per note.
Perhaps:

CUSIP
MemberID
CommentDate
Comment


John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)



-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Thursday, October 31, 2013 3:38 PM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] How to combine several memo fields into one
memo field?

Tim,

I assume the notes/memo records are one (company) to many (notes). I would
use a subreport of the notes table in the detail section of the company main
report.

If you really don't want to try the subreport, you can find a generic
concatenate function
at http://www.rogersaccesslibrary.com/forum/generic-function-to-concatenate-
child-records_topic16.html

Duane Hookom MVP
MS Access
________________________________
> From: timdbui@...
>
> Duane,
>
> I am creating a database to keep all of our members' comments. Say,
> "John" follows the company IBM and he keeps his notes on IBM separated
> by dates. In the course of the year, he might put in 5 or 10 notes on
> various dates. I also created a form so that any member can enter the
> ticker IBM and click print to retrieve a report that would contain all
> data kept on IBM as well as all of the notes that John had entered. If
> I can create a memo field that combines all of John's notes and put it
> in the report so others can read John's notes. I think if I cannot
> create a combined memo field, I have to create a number of memo fields
> for each of John's notes, right?
>
>
> Another problem is other members might put in their notes on IBM on
> various dates as well. A memo field that combines everyone's note
> would be very helpful so that everyone can see each other's notes on IBM.
>
>
>
> Thanks, Duane!
>
>
> ---In MS_Access_Professionals@yahoogroups.com,
> <ms_access_professionals@yahoogroups.com> wrote:
>
> Tim,
> Why is it necessary to combine the memo field values into a single
> field? Reports can easily render one record under another like a
> continuous form/datasheet.
>
> Are the notes typically as brief as your examples? Is the date part of
> the memo field or a separate field?
>
> Duane Hookom MVP
> MS Access
>
> ________________________________
>> From: timdbui@...<mailto:timdbui@...>
>>
>> Hi, Would any of you please help me on this topic? I keep notes of
>> companies over time and I would like to add these notes into one memo
>> field in a report.
>>
>> For example, on Jan 1, 2013, my note is xxxxxx, on Mar 1, 2013, my
>> note is yyyyy, and on April 1, 2013, my note is aaaaaa. How can I
>> combine these notes into one memo field in a report so that the final
>> field will have three lines of xxxxx, yyyyy, and aaaaa. Thanks in advance
for
>> your help! Tim

------------------------------------

Yahoo Groups Links

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (10)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

RE: RE: [MS_AccessPros] How to combine several memo fields into one memo field?

 

Thanks, Duane! Let me try both the SQL and the subreport. 


Regards,


Tim



---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:

Tim,

I believe the concatenate function allows you to enter the delimiter in the function call. You can use
Concatenate("SQL STATEMENT",Chr(13) & Chr(10))

Personally, I would try a subreport.

Duane Hookom MVP
MS Access

________________________________
> To: MS_Access_Professionals@yahoogroups.com
> From: timdbui@...
> Date: Thu, 31 Oct 2013 07:50:49 -0700
> Subject: RE: RE: [MS_AccessPros] How to combine several memo fields
> into one memo field?
>
>
>
>
> Duane,
>
> Concatenate is exactly what meant to ask. Just couldn't come up with
> the right term.
>
>
> Yes, it is one company to many notes.
>
>
> I read the link that you gave and understand it.
>
>
> Do you know how can I break the concatenation by a new line, rather
> than by a comma? It would be easier to read if each of the note is
> separate by a blank line, rather than a period or a comma.
>
>
> Thanks again, Duane!
>
>
> ---In MS_Access_Professionals@yahoogroups.com,
> <ms_access_professionals@yahoogroups.com> wrote:
>
> Tim,
>
> I assume the notes/memo records are one (company) to many (notes). I
> would use a subreport of the notes table in the detail section of the
> company main report.
>
> If you really don't want to try the subreport, you can find a generic
> concatenate function
> at http://www.rogersaccesslibrary.com/forum/generic-function-to-concatenate-child-records_topic16.html
>
> Duane Hookom MVP
> MS Access
> ________________________________
>> From: timdbui@...<mailto:timdbui@...>
>>
>> Duane,
>>
>> I am creating a database to keep all of our members' comments. Say,
>> "John" follows the company IBM and he keeps his notes on IBM separated
>> by dates. In the course of the year, he might put in 5 or 10 notes on
>> various dates. I also created a form so that any member can enter the
>> ticker IBM and click print to retrieve a report that would contain all
>> data kept on IBM as well as all of the notes that John had entered. If
>> I can create a memo field that combines all of John's notes and put it
>> in the report so others can read John's notes. I think if I cannot
>> create a combined memo field, I have to create a number of memo fields
>> for each of John's notes, right?
>>
>>
>> Another problem is other members might put in their notes on IBM on
>> various dates as well. A memo field that combines everyone's note would
>> be very helpful so that everyone can see each other's notes on IBM.
>>
>>
>>
>> Thanks, Duane!
>>
>>
>> ---In
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>,
>>
> <ms_access_professionals@yahoogroups.com<mailto:ms_access_professionals@yahoogroups.com>>
> wrote:
>>
>> Tim,
>> Why is it necessary to combine the memo field values into a single
>> field? Reports can easily render one record under another like a
>> continuous form/datasheet.
>>
>> Are the notes typically as brief as your examples? Is the date part of
>> the memo field or a separate field?
>>
>> Duane Hookom MVP
>> MS Access
>>
>> ________________________________
>>> From: timdbui@...<mailto:timdbui@...>
>>>
>>> Hi, Would any of you please help me on this topic? I keep notes of
>>> companies over time and I would like to add these notes into one memo
>>> field in a report.
>>>
>>> For example, on Jan 1, 2013, my note is xxxxxx, on Mar 1, 2013, my note
>>> is yyyyy, and on April 1, 2013, my note is aaaaaa. How can I combine
>>> these notes into one memo field in a report so that the final field
>>> will have three lines of xxxxx, yyyyy, and aaaaa. Thanks in advance for
>>> your help! Tim
>
>
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (9)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

RE: [MS_AccessPros] How to combine several memo fields into one memo field?

 

Tim,

I believe the concatenate function allows you to enter the delimiter in the function call. You can use
Concatenate("SQL STATEMENT",Chr(13) & Chr(10))

Personally, I would try a subreport.

Duane Hookom MVP
MS Access

________________________________
> To: MS_Access_Professionals@yahoogroups.com
> From: timdbui@gmail.com
> Date: Thu, 31 Oct 2013 07:50:49 -0700
> Subject: RE: RE: [MS_AccessPros] How to combine several memo fields
> into one memo field?
>
>
>
>
> Duane,
>
> Concatenate is exactly what meant to ask. Just couldn't come up with
> the right term.
>
>
> Yes, it is one company to many notes.
>
>
> I read the link that you gave and understand it.
>
>
> Do you know how can I break the concatenation by a new line, rather
> than by a comma? It would be easier to read if each of the note is
> separate by a blank line, rather than a period or a comma.
>
>
> Thanks again, Duane!
>
>
> ---In MS_Access_Professionals@yahoogroups.com,
> <ms_access_professionals@yahoogroups.com> wrote:
>
> Tim,
>
> I assume the notes/memo records are one (company) to many (notes). I
> would use a subreport of the notes table in the detail section of the
> company main report.
>
> If you really don't want to try the subreport, you can find a generic
> concatenate function
> at http://www.rogersaccesslibrary.com/forum/generic-function-to-concatenate-child-records_topic16.html
>
> Duane Hookom MVP
> MS Access
> ________________________________
>> From: timdbui@...<mailto:timdbui@...>
>>
>> Duane,
>>
>> I am creating a database to keep all of our members' comments. Say,
>> "John" follows the company IBM and he keeps his notes on IBM separated
>> by dates. In the course of the year, he might put in 5 or 10 notes on
>> various dates. I also created a form so that any member can enter the
>> ticker IBM and click print to retrieve a report that would contain all
>> data kept on IBM as well as all of the notes that John had entered. If
>> I can create a memo field that combines all of John's notes and put it
>> in the report so others can read John's notes. I think if I cannot
>> create a combined memo field, I have to create a number of memo fields
>> for each of John's notes, right?
>>
>>
>> Another problem is other members might put in their notes on IBM on
>> various dates as well. A memo field that combines everyone's note would
>> be very helpful so that everyone can see each other's notes on IBM.
>>
>>
>>
>> Thanks, Duane!
>>
>>
>> ---In
> MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>,
>>
> <ms_access_professionals@yahoogroups.com<mailto:ms_access_professionals@yahoogroups.com>>
> wrote:
>>
>> Tim,
>> Why is it necessary to combine the memo field values into a single
>> field? Reports can easily render one record under another like a
>> continuous form/datasheet.
>>
>> Are the notes typically as brief as your examples? Is the date part of
>> the memo field or a separate field?
>>
>> Duane Hookom MVP
>> MS Access
>>
>> ________________________________
>>> From: timdbui@...<mailto:timdbui@...>
>>>
>>> Hi, Would any of you please help me on this topic? I keep notes of
>>> companies over time and I would like to add these notes into one memo
>>> field in a report.
>>>
>>> For example, on Jan 1, 2013, my note is xxxxxx, on Mar 1, 2013, my note
>>> is yyyyy, and on April 1, 2013, my note is aaaaaa. How can I combine
>>> these notes into one memo field in a report so that the final field
>>> will have three lines of xxxxx, yyyyy, and aaaaa. Thanks in advance for
>>> your help! Tim
>
>
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (8)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

RE: RE: [MS_AccessPros] How to combine several memo fields into one memo field?

 

Duane,

Concatenate is exactly what meant to ask. Just couldn't come up with the right term.


Yes, it is one company to many notes.


I read the link that you gave and understand it.


Do you know how can I break the concatenation by a new line, rather than by a comma?  It would be easier to read if each of the note is separate by a blank line, rather than a period or a comma.


Thanks again, Duane!



---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:

Tim,

I assume the notes/memo records are one (company) to many (notes). I would use a subreport of the notes table in the detail section of the company main report.

If you really don't want to try the subreport, you can find a generic concatenate function at http://www.rogersaccesslibrary.com/forum/generic-function-to-concatenate-child-records_topic16.html

Duane Hookom MVP
MS Access
________________________________
> From: timdbui@... 
>
> Duane,
>
> I am creating a database to keep all of our members' comments. Say,
> "John" follows the company IBM and he keeps his notes on IBM separated
> by dates. In the course of the year, he might put in 5 or 10 notes on
> various dates. I also created a form so that any member can enter the
> ticker IBM and click print to retrieve a report that would contain all
> data kept on IBM as well as all of the notes that John had entered. If
> I can create a memo field that combines all of John's notes and put it
> in the report so others can read John's notes. I think if I cannot
> create a combined memo field, I have to create a number of memo fields
> for each of John's notes, right?
>
>
> Another problem is other members might put in their notes on IBM on
> various dates as well. A memo field that combines everyone's note would
> be very helpful so that everyone can see each other's notes on IBM.
>
>
>
> Thanks, Duane!
>
>
> ---In MS_Access_Professionals@yahoogroups.com,
> <ms_access_professionals@yahoogroups.com> wrote:
>
> Tim,
> Why is it necessary to combine the memo field values into a single
> field? Reports can easily render one record under another like a
> continuous form/datasheet.
>
> Are the notes typically as brief as your examples? Is the date part of
> the memo field or a separate field?
>
> Duane Hookom MVP
> MS Access
>
> ________________________________
>> From: timdbui@...<mailto:timdbui@...>
>>
>> Hi, Would any of you please help me on this topic? I keep notes of
>> companies over time and I would like to add these notes into one memo
>> field in a report.
>>
>> For example, on Jan 1, 2013, my note is xxxxxx, on Mar 1, 2013, my note
>> is yyyyy, and on April 1, 2013, my note is aaaaaa. How can I combine
>> these notes into one memo field in a report so that the final field
>> will have three lines of xxxxx, yyyyy, and aaaaa. Thanks in advance for
>> your help! Tim

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

RE: [MS_AccessPros] How to combine several memo fields into one memo field?

 

Tim-

It would help to know the layout of your tables. If you have multiple memo
fields in one record, that won't work. You need one record per note.
Perhaps:

CUSIP
MemberID
CommentDate
Comment

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Thursday, October 31, 2013 3:38 PM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] How to combine several memo fields into one
memo field?

Tim,

I assume the notes/memo records are one (company) to many (notes). I would
use a subreport of the notes table in the detail section of the company main
report.

If you really don't want to try the subreport, you can find a generic
concatenate function
at http://www.rogersaccesslibrary.com/forum/generic-function-to-concatenate-
child-records_topic16.html

Duane Hookom MVP
MS Access
________________________________
> From: timdbui@gmail.com
>
> Duane,
>
> I am creating a database to keep all of our members' comments. Say,
> "John" follows the company IBM and he keeps his notes on IBM separated
> by dates. In the course of the year, he might put in 5 or 10 notes on
> various dates. I also created a form so that any member can enter the
> ticker IBM and click print to retrieve a report that would contain all
> data kept on IBM as well as all of the notes that John had entered. If
> I can create a memo field that combines all of John's notes and put it
> in the report so others can read John's notes. I think if I cannot
> create a combined memo field, I have to create a number of memo fields
> for each of John's notes, right?
>
>
> Another problem is other members might put in their notes on IBM on
> various dates as well. A memo field that combines everyone's note
> would be very helpful so that everyone can see each other's notes on IBM.
>
>
>
> Thanks, Duane!
>
>
> ---In MS_Access_Professionals@yahoogroups.com,
> <ms_access_professionals@yahoogroups.com> wrote:
>
> Tim,
> Why is it necessary to combine the memo field values into a single
> field? Reports can easily render one record under another like a
> continuous form/datasheet.
>
> Are the notes typically as brief as your examples? Is the date part of
> the memo field or a separate field?
>
> Duane Hookom MVP
> MS Access
>
> ________________________________
>> From: timdbui@...<mailto:timdbui@...>
>>
>> Hi, Would any of you please help me on this topic? I keep notes of
>> companies over time and I would like to add these notes into one memo
>> field in a report.
>>
>> For example, on Jan 1, 2013, my note is xxxxxx, on Mar 1, 2013, my
>> note is yyyyy, and on April 1, 2013, my note is aaaaaa. How can I
>> combine these notes into one memo field in a report so that the final
>> field will have three lines of xxxxx, yyyyy, and aaaaa. Thanks in advance
for
>> your help! Tim

------------------------------------

Yahoo Groups Links

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

RE: [MS_AccessPros] How to combine several memo fields into one memo field?

 

Tim,

I assume the notes/memo records are one (company) to many (notes). I would use a subreport of the notes table in the detail section of the company main report.

If you really don't want to try the subreport, you can find a generic concatenate function at http://www.rogersaccesslibrary.com/forum/generic-function-to-concatenate-child-records_topic16.html

Duane Hookom MVP
MS Access
________________________________
> From: timdbui@gmail.com 
>
> Duane,
>
> I am creating a database to keep all of our members' comments. Say,
> "John" follows the company IBM and he keeps his notes on IBM separated
> by dates. In the course of the year, he might put in 5 or 10 notes on
> various dates. I also created a form so that any member can enter the
> ticker IBM and click print to retrieve a report that would contain all
> data kept on IBM as well as all of the notes that John had entered. If
> I can create a memo field that combines all of John's notes and put it
> in the report so others can read John's notes. I think if I cannot
> create a combined memo field, I have to create a number of memo fields
> for each of John's notes, right?
>
>
> Another problem is other members might put in their notes on IBM on
> various dates as well. A memo field that combines everyone's note would
> be very helpful so that everyone can see each other's notes on IBM.
>
>
>
> Thanks, Duane!
>
>
> ---In MS_Access_Professionals@yahoogroups.com,
> <ms_access_professionals@yahoogroups.com> wrote:
>
> Tim,
> Why is it necessary to combine the memo field values into a single
> field? Reports can easily render one record under another like a
> continuous form/datasheet.
>
> Are the notes typically as brief as your examples? Is the date part of
> the memo field or a separate field?
>
> Duane Hookom MVP
> MS Access
>
> ________________________________
>> From: timdbui@...<mailto:timdbui@...>
>>
>> Hi, Would any of you please help me on this topic? I keep notes of
>> companies over time and I would like to add these notes into one memo
>> field in a report.
>>
>> For example, on Jan 1, 2013, my note is xxxxxx, on Mar 1, 2013, my note
>> is yyyyy, and on April 1, 2013, my note is aaaaaa. How can I combine
>> these notes into one memo field in a report so that the final field
>> will have three lines of xxxxx, yyyyy, and aaaaa. Thanks in advance for
>> your help! Tim

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:

RE: RE: RE: [MS_AccessPros] How to combine several memo fields into one memo field?

 

Duane,

I forgot to answer your other questions:

- Each note is normally less than 5 lines (about 1 paragraph).

- The date for each of the note is on a separate field so that I can sort.


Thanks,

Tim 



---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:

Duane,


I am creating a database to keep all of our members' comments. Say, "John" follows the company IBM and he keeps his notes on IBM separated by dates. In the course of the year, he might put in 5 or 10 notes on various dates. I also created a form so that any member can enter the ticker IBM and click print to retrieve a report that would contain all data kept on IBM as well as all of the notes that John had entered. If I can create a memo field that combines all of John's notes and put it in the report so others can read John's notes. I think if I cannot create a combined memo field, I have to create a number of memo fields for each of John's notes, right? 


Another problem is other members might put in their notes on IBM on various dates as well. A memo field that combines everyone's note would be very helpful so that everyone can see each other's notes on IBM.



Thanks, Duane!



---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:

Tim,
Why is it necessary to combine the memo field values into a single field? Reports can easily render one record under another like a continuous form/datasheet.

Are the notes typically as brief as your examples? Is the date part of the memo field or a separate field?

Duane Hookom MVP
MS Access

________________________________
> From: timdbui@...
>
> Hi, Would any of you please help me on this topic? I keep notes of
> companies over time and I would like to add these notes into one memo
> field in a report.
>
> For example, on Jan 1, 2013, my note is xxxxxx, on Mar 1, 2013, my note
> is yyyyy, and on April 1, 2013, my note is aaaaaa. How can I combine
> these notes into one memo field in a report so that the final field
> will have three lines of xxxxx, yyyyy, and aaaaa. Thanks in advance for
> your help! Tim

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)
Recent Activity:
.

__,_._,___
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)