Navigation buttons Access 2007

[Chris]

I am learning Access with the 2007 version. Does anyone know...

frmClient is single form, navigation buttons=yes; the search component
works fine.

frmClientNotes (memo type field) is a continuous subform of frmClient,
navigation buttons are set true/false with VBA. The search component is not
working. I expect it to return a record (or records) of
frmClient-frmClientNotes per the subform's navigation buttons search input.
No joy!

Each form is query based with no filters.

 

[Allen Browne]

Normally, a subform displays the data from a related table, showing only the
records that relate to the one in the main form. So, your main form
(frmClient) would show a client, and your subform (frmClientNotes) would
display only the notes for that client. It does this via the
LinkMasterFields/LinkChildFields properties of the subform control.

Since the subform does not show all records form its table (i.e. only the
notes for the client in the main form), when you search it, you will not
find any of the records that are not loaded (i.e. you will not find the
records for other clients.)

If you do need to create a search that filters the main form such that it
contains only those clients who have a match from the client notes table,
see:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

If that's not what you are trying to do, please post a reply so we can try
to help.

 

[Chris]

Thanks for the reply, Allen.

Yes, the subform is already "filtered" for a given client's notes. I wish
to search those notes -- only that client's notes -- for the search term.
The search would relevent to only on one control, a memo type. There can be
quite a few notes for each client.

The filter, search and caption features are new to '07. They aren't at all
critical to what my user's need is -- but the search is a nice feature.

If I cannot search the subform records, I would hope for a way to utilize
the navigation button without filter and search feature showing. I don't
want to confuse the user.

Again...I thank you for your help.

Chris

Normally, a subform displays the data from a related table, showing only the
records that relate to the one in the main form. So, your main form
(frmClient) would show a client, and your subform (frmClientNotes) would
display only the notes for that client. It does this via the
LinkMasterFields/LinkChildFields properties of the subform control.

Since the subform does not show all records form its table (i.e. only the
notes for the client in the main form), when you search it, you will not
find any of the records that are not loaded (i.e. you will not find the
records for other clients.)

If you do need to create a search that filters the main form such that it
contains only those clients who have a match from the client notes table,
see:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

If that's not what you are trying to do, please post a reply so we can try
to help.

 

[Allen Browne]

Okay, I guess I don't understand the problem.

With the cursor in the memo field in the subform, you could try clicking the
Find button (binocular icon), and search for any part of field.

Programmatically, you could find the note that contains "dog" like this:
With Me.RecordsetClone
.FindFirst "[MyMemo] Like ""*dog*"""
If .NoMatch Then
MsgBox "Not found"
Else
Me.Bookmark = .Bookmark
End If
End With

 

[Chris]

Thanks for working with me on this.

Clue: cursor in field to search.

I was trying to search without the cursor in the field. The subform is in
view only state at that point, locked and not enabled; when in edit state,
unlocked and enabled, it works as expected.

So...is there a way to point to that memo control and search, while it is
locked and not enabled? If not, I can live with it, but that would be very
helpful. Remember, I am learning.

--
Thanks for your help,
Chris

Okay, I guess I don't understand the problem.

With the cursor in the memo field in the subform, you could try clicking the
Find button (binocular icon), and search for any part of field.

Programmatically, you could find the note that contains "dog" like this:
With Me.RecordsetClone
.FindFirst "[MyMemo] Like ""*dog*"""
If .NoMatch Then
MsgBox "Not found"
Else
Me.Bookmark = .Bookmark
End If
End With

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks for the reply, Allen.

Yes, the subform is already "filtered" for a given client's notes. I wish
to search those notes -- only that client's notes -- for the search term.
The search would relevent to only on one control, a memo type. There can
be
quite a few notes for each client.

The filter, search and caption features are new to '07. They aren't at
all
critical to what my user's need is -- but the search is a nice feature.

If I cannot search the subform records, I would hope for a way to utilize
the navigation button without filter and search feature showing. I don't
want to confuse the user.

Again...I thank you for your help.

Chris

 

[Allen Browne]

Enabled (so it can take focus) but Locked (so it cannot be changed) should
be ideal?

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks for working with me on this.

Clue: cursor in field to search.

I was trying to search without the cursor in the field. The subform is in
view only state at that point, locked and not enabled; when in edit state,
unlocked and enabled, it works as expected.

So...is there a way to point to that memo control and search, while it is
locked and not enabled? If not, I can live with it, but that would be
very
helpful. Remember, I am learning.

--
Thanks for your help,
Chris

Okay, I guess I don't understand the problem.

With the cursor in the memo field in the subform, you could try clicking
the
Find button (binocular icon), and search for any part of field.

Programmatically, you could find the note that contains "dog" like this:
With Me.RecordsetClone
.FindFirst "[MyMemo] Like ""*dog*"""
If .NoMatch Then
MsgBox "Not found"
Else
Me.Bookmark = .Bookmark
End If
End With
to group, rather than allenbrowne at mvps dot org.

Thanks for the reply, Allen.

Yes, the subform is already "filtered" for a given client's notes. I
wish
to search those notes -- only that client's notes -- for the search
term.
The search would relevent to only on one control, a memo type. There
can
be
quite a few notes for each client.

The filter, search and caption features are new to '07. They aren't at
all
critical to what my user's need is -- but the search is a nice feature.

If I cannot search the subform records, I would hope for a way to
utilize
the navigation button without filter and search feature showing. I
don't
want to confuse the user.

Again...I thank you for your help.

Chris


:

Normally, a subform displays the data from a related table, showing
only
the
records that relate to the one in the main form. So, your main form
(frmClient) would show a client, and your subform (frmClientNotes)
would
display only the notes for that client. It does this via the
LinkMasterFields/LinkChildFields properties of the subform control.

Since the subform does not show all records form its table (i.e. only
the
notes for the client in the main form), when you search it, you will
not
find any of the records that are not loaded (i.e. you will not find
the
records for other clients.)

If you do need to create a search that filters the main form such that
it
contains only those clients who have a match from the client notes
table,
see:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

If that's not what you are trying to do, please post a reply so we can
try
to help.

I am learning Access with the 2007 version. Does anyone know...

frmClient is single form, navigation buttons=yes; the search
component
works fine.

frmClientNotes (memo type field) is a continuous subform of
frmClient,
navigation buttons are set true/false with VBA. The search
component
is
not
working. I expect it to return a record (or records) of
frmClient-frmClientNotes per the subform's navigation buttons search
input.
No joy!

Each form is query based with no filters.

 

[Chris]

Oh yes! Never thought of that...duh! Probably a forest and tree thing.

Thanks so much for the guidance.

Chris

Enabled (so it can take focus) but Locked (so it cannot be changed) should
be ideal?

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks for working with me on this.

Clue: cursor in field to search.

I was trying to search without the cursor in the field. The subform is in
view only state at that point, locked and not enabled; when in edit state,
unlocked and enabled, it works as expected.

So...is there a way to point to that memo control and search, while it is
locked and not enabled? If not, I can live with it, but that would be
very
helpful. Remember, I am learning.

--
Thanks for your help,
Chris

Okay, I guess I don't understand the problem.

With the cursor in the memo field in the subform, you could try clicking
the
Find button (binocular icon), and search for any part of field.

Programmatically, you could find the note that contains "dog" like this:
With Me.RecordsetClone
.FindFirst "[MyMemo] Like ""*dog*"""
If .NoMatch Then
MsgBox "Not found"
Else
Me.Bookmark = .Bookmark
End If
End With
to group, rather than allenbrowne at mvps dot org.

Thanks for the reply, Allen.

Yes, the subform is already "filtered" for a given client's notes. I
wish
to search those notes -- only that client's notes -- for the search
term.
The search would relevent to only on one control, a memo type. There
can
be
quite a few notes for each client.

The filter, search and caption features are new to '07. They aren't at
all
critical to what my user's need is -- but the search is a nice feature.

If I cannot search the subform records, I would hope for a way to
utilize
the navigation button without filter and search feature showing. I
don't
want to confuse the user.

Again...I thank you for your help.

Chris


:

Normally, a subform displays the data from a related table, showing
only
the
records that relate to the one in the main form. So, your main form
(frmClient) would show a client, and your subform (frmClientNotes)
would
display only the notes for that client. It does this via the
LinkMasterFields/LinkChildFields properties of the subform control.

Since the subform does not show all records form its table (i.e. only
the
notes for the client in the main form), when you search it, you will
not
find any of the records that are not loaded (i.e. you will not find
the
records for other clients.)

If you do need to create a search that filters the main form such that
it
contains only those clients who have a match from the client notes
table,
see:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

If that's not what you are trying to do, please post a reply so we can
try
to help.

I am learning Access with the 2007 version. Does anyone know...

frmClient is single form, navigation buttons=yes; the search
component
works fine.

frmClientNotes (memo type field) is a continuous subform of
frmClient,
navigation buttons are set true/false with VBA. The search
component
is
not
working. I expect it to return a record (or records) of
frmClient-frmClientNotes per the subform's navigation buttons search
input.
No joy!

Each form is query based with no filters.