473,888 Members | 1,453 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Searching Subforms...

Hi,

I have a form as follows:

Main Form (To Select Customer)
Sub Form 1 (To Select PO Number, by clicking on field) - Continuous
form
Sub Form 2 (To view order details)- Continuous form
_______________ _______

Normally, if I click on a PO Number in Sub-Form 1, Sub-Form 2 displays
the details for that PO Number.

What I am trying to do is have a text box & button on the main form
which just does the same as me using the scroll bar on Sub-Form 1 to
find a PO Number. I still want all the other PO Numbers shown, Just
for the system to select the PO Number from the text box and move to
that record without hiding all the other PO Numbers as maybe the
'Filter' method does.

i.e.

PO Number

5454
87676
7676
7676
656

Normally when the form opens, the very first PO Number is selected
automatically (5454). If I search for PO Number '656' then I want
Sub-Form 1 to show

5454
3w43
656.....<< Selected Record.
90
34543

Sub-Form 2 should then auto display the data for the searched for PO
Number.

I still want our users to be able to search again or scroll through
all the PO Numbers.

I have tried some other code which makes Sub-Form 1 display only the
searched for PO Number & Sub-Form 2, but then I found it impossible to
get both Sub Forms back to their state prior to the search.

Appreciate your help.

David
Nov 13 '05 #1
8 1606
Assuming:
- the record is present in the subform (i.e. it does not match a different
main form record);
- the text box where you enter the number to find is named "txtFind"
then you could put this code into the AfterUpdate event procedure of your
text box.

Private Sub txtFind_AfterUp date()
Dim rs As DAO.Recordset
Dim strWhere As String

If Not IsNull(Me.txtFi nd) Then
strWhere = "[PO Number] = " & Me.txtFind
With Me.[Form1].Form
Set rs = .RecordsetClone
rs.FindFirst strWhere
If rs.NoMatch Then
MsgBox "Not found"
Else
.Bookmark = rs.Bookmark
End If
Set rs = Nothing
End With
End If
End Sub
Notes:
1. If PO Number is a Text type field, you need extra quotes:
strWhere = "[PO Number] = """ & Me.txtFind & """"
2. The found record is displayed at the top of the subform.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"David" <da***@scene-double.co.uk> wrote in message
news:c1******** *************** ***@posting.goo gle.com...
Hi,

I have a form as follows:

Main Form (To Select Customer)
Sub Form 1 (To Select PO Number, by clicking on field) - Continuous
form
Sub Form 2 (To view order details)- Continuous form
_______________ _______

Normally, if I click on a PO Number in Sub-Form 1, Sub-Form 2 displays
the details for that PO Number.

What I am trying to do is have a text box & button on the main form
which just does the same as me using the scroll bar on Sub-Form 1 to
find a PO Number. I still want all the other PO Numbers shown, Just
for the system to select the PO Number from the text box and move to
that record without hiding all the other PO Numbers as maybe the
'Filter' method does.

i.e.

PO Number

5454
87676
7676
7676
656

Normally when the form opens, the very first PO Number is selected
automatically (5454). If I search for PO Number '656' then I want
Sub-Form 1 to show

5454
3w43
656.....<< Selected Record.
90
34543

Sub-Form 2 should then auto display the data for the searched for PO
Number.

I still want our users to be able to search again or scroll through
all the PO Numbers.

I have tried some other code which makes Sub-Form 1 display only the
searched for PO Number & Sub-Form 2, but then I found it impossible to
get both Sub Forms back to their state prior to the search.

Appreciate your help.

David

Nov 13 '05 #2
Allen,

Thanks for your prompt reply.

rs As DAO.Recordset - ERROR: User Defined Type not defined ?????

Any ideas ?

"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message news:<41******* *************** *@per-qv1-newsreader-01.iinet.net.au >...
Assuming:
- the record is present in the subform (i.e. it does not match a different
main form record);
- the text box where you enter the number to find is named "txtFind"
then you could put this code into the AfterUpdate event procedure of your
text box.

Private Sub txtFind_AfterUp date()
Dim rs As DAO.Recordset
Dim strWhere As String

If Not IsNull(Me.txtFi nd) Then
strWhere = "[PO Number] = " & Me.txtFind
With Me.[Form1].Form
Set rs = .RecordsetClone
rs.FindFirst strWhere
If rs.NoMatch Then
MsgBox "Not found"
Else
.Bookmark = rs.Bookmark
End If
Set rs = Nothing
End With
End If
End Sub
Notes:
1. If PO Number is a Text type field, you need extra quotes:
strWhere = "[PO Number] = """ & Me.txtFind & """"
2. The found record is displayed at the top of the subform.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"David" <da***@scene-double.co.uk> wrote in message
news:c1******** *************** ***@posting.goo gle.com...
Hi,

I have a form as follows:

Main Form (To Select Customer)
Sub Form 1 (To Select PO Number, by clicking on field) - Continuous
form
Sub Form 2 (To view order details)- Continuous form
_______________ _______

Normally, if I click on a PO Number in Sub-Form 1, Sub-Form 2 displays
the details for that PO Number.

What I am trying to do is have a text box & button on the main form
which just does the same as me using the scroll bar on Sub-Form 1 to
find a PO Number. I still want all the other PO Numbers shown, Just
for the system to select the PO Number from the text box and move to
that record without hiding all the other PO Numbers as maybe the
'Filter' method does.

i.e.

PO Number

5454
87676
7676
7676
656

Normally when the form opens, the very first PO Number is selected
automatically (5454). If I search for PO Number '656' then I want
Sub-Form 1 to show

5454
3w43
656.....<< Selected Record.
90
34543

Sub-Form 2 should then auto display the data for the searched for PO
Number.

I still want our users to be able to search again or scroll through
all the PO Numbers.

I have tried some other code which makes Sub-Form 1 display only the
searched for PO Number & Sub-Form 2, but then I found it impossible to
get both Sub Forms back to their state prior to the search.

Appreciate your help.

David

Nov 13 '05 #3
You are probably using Access 2000 or 2002, and you need to add a reference
to:
Microsoft DAO 3.6 Library.
Details:
http://members.iinet.net.au/~allenbrowne/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"David" <da***@scene-double.co.uk> wrote in message
news:c1******** *************** ***@posting.goo gle.com...
Allen,

Thanks for your prompt reply.

rs As DAO.Recordset - ERROR: User Defined Type not defined ?????

Any ideas ?

"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:<41******* *************** *@per-qv1-newsreader-01.iinet.net.au >...
Assuming:
- the record is present in the subform (i.e. it does not match a
different
main form record);
- the text box where you enter the number to find is named "txtFind"
then you could put this code into the AfterUpdate event procedure of your
text box.

Private Sub txtFind_AfterUp date()
Dim rs As DAO.Recordset
Dim strWhere As String

If Not IsNull(Me.txtFi nd) Then
strWhere = "[PO Number] = " & Me.txtFind
With Me.[Form1].Form
Set rs = .RecordsetClone
rs.FindFirst strWhere
If rs.NoMatch Then
MsgBox "Not found"
Else
.Bookmark = rs.Bookmark
End If
Set rs = Nothing
End With
End If
End Sub
Notes:
1. If PO Number is a Text type field, you need extra quotes:
strWhere = "[PO Number] = """ & Me.txtFind & """"
2. The found record is displayed at the top of the subform.
"David" <da***@scene-double.co.uk> wrote in message
news:c1******** *************** ***@posting.goo gle.com...
> Hi,
>
> I have a form as follows:
>
> Main Form (To Select Customer)
> Sub Form 1 (To Select PO Number, by clicking on field) - Continuous
> form
> Sub Form 2 (To view order details)- Continuous form
> _______________ _______
>
> Normally, if I click on a PO Number in Sub-Form 1, Sub-Form 2 displays
> the details for that PO Number.
>
> What I am trying to do is have a text box & button on the main form
> which just does the same as me using the scroll bar on Sub-Form 1 to
> find a PO Number. I still want all the other PO Numbers shown, Just
> for the system to select the PO Number from the text box and move to
> that record without hiding all the other PO Numbers as maybe the
> 'Filter' method does.
>
> i.e.
>
> PO Number
>
> 5454
> 87676
> 7676
> 7676
> 656
>
> Normally when the form opens, the very first PO Number is selected
> automatically (5454). If I search for PO Number '656' then I want
> Sub-Form 1 to show
>
> 5454
> 3w43
> 656.....<< Selected Record.
> 90
> 34543
>
> Sub-Form 2 should then auto display the data for the searched for PO
> Number.
>
> I still want our users to be able to search again or scroll through
> all the PO Numbers.
>
> I have tried some other code which makes Sub-Form 1 display only the
> searched for PO Number & Sub-Form 2, but then I found it impossible to
> get both Sub Forms back to their state prior to the search.
>
> Appreciate your help.
>
> David

Nov 13 '05 #4
Allen,
I have a similar problem and have been unable to find a solution that
works.

I have a main form, lets call it frmMain, with a subform control,
called sfrmControl, which has a subform on it called sfrmMain. I want
to put a combobox on the main form, which will filter the main form,
based on a field which is contained in the subform. When I do this
currently, a little box comes up (like a parameter input box) with the
name of the field, and a textbox asking me to type in a value.

I want to do this with filters, so when I select a value in the
combobox on the main form, it will filter the main form based on the
field from the subform, so that the main form will display the
"(Filtered) " part after the number of records.

I have this working now on a different combobox, the only difference
is the combobox that is working is using a field from the main form
instead of a field on the subform. I tried every permutation I could
think of, but I can't seem to be able to get the main form filtered
based on the subform's field.

It would be much appreciated any help that could be supplied. Thanks.
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message news:<41******* *************** *@per-qv1-newsreader-01.iinet.net.au >...
Assuming:
- the record is present in the subform (i.e. it does not match a different
main form record);
- the text box where you enter the number to find is named "txtFind"
then you could put this code into the AfterUpdate event procedure of your
text box.

Private Sub txtFind_AfterUp date()
Dim rs As DAO.Recordset
Dim strWhere As String

If Not IsNull(Me.txtFi nd) Then
strWhere = "[PO Number] = " & Me.txtFind
With Me.[Form1].Form
Set rs = .RecordsetClone
rs.FindFirst strWhere
If rs.NoMatch Then
MsgBox "Not found"
Else
.Bookmark = rs.Bookmark
End If
Set rs = Nothing
End With
End If
End Sub
Notes:
1. If PO Number is a Text type field, you need extra quotes:
strWhere = "[PO Number] = """ & Me.txtFind & """"
2. The found record is displayed at the top of the subform.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"David" <da***@scene-double.co.uk> wrote in message
news:c1******** *************** ***@posting.goo gle.com...
Hi,

I have a form as follows:

Main Form (To Select Customer)
Sub Form 1 (To Select PO Number, by clicking on field) - Continuous
form
Sub Form 2 (To view order details)- Continuous form
_______________ _______

Normally, if I click on a PO Number in Sub-Form 1, Sub-Form 2 displays
the details for that PO Number.

What I am trying to do is have a text box & button on the main form
which just does the same as me using the scroll bar on Sub-Form 1 to
find a PO Number. I still want all the other PO Numbers shown, Just
for the system to select the PO Number from the text box and move to
that record without hiding all the other PO Numbers as maybe the
'Filter' method does.

i.e.

PO Number

5454
87676
7676
7676
656

Normally when the form opens, the very first PO Number is selected
automatically (5454). If I search for PO Number '656' then I want
Sub-Form 1 to show

5454
3w43
656.....<< Selected Record.
90
34543

Sub-Form 2 should then auto display the data for the searched for PO
Number.

I still want our users to be able to search again or scroll through
all the PO Numbers.

I have tried some other code which makes Sub-Form 1 display only the
searched for PO Number & Sub-Form 2, but then I found it impossible to
get both Sub Forms back to their state prior to the search.

Appreciate your help.

David

Nov 13 '05 #5
See:
Filter a Form on a Field in a Subform
at:
http://members.iinet.net.au/~allenbrowne/ser-28.html

The article explains how to effectively filter the main form so it only
contains records that have a match in the subform, by reassigning the
RecordSource of the main form to an INNER JOIN statement.

(It is also possible to achieve the result by using a subquery in the Filter
of the main form.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"user_5701" <us*******@hotm ail.com> wrote in message
news:f1******** *************** ***@posting.goo gle.com...
Allen,
I have a similar problem and have been unable to find a solution that
works.

I have a main form, lets call it frmMain, with a subform control,
called sfrmControl, which has a subform on it called sfrmMain. I want
to put a combobox on the main form, which will filter the main form,
based on a field which is contained in the subform. When I do this
currently, a little box comes up (like a parameter input box) with the
name of the field, and a textbox asking me to type in a value.

I want to do this with filters, so when I select a value in the
combobox on the main form, it will filter the main form based on the
field from the subform, so that the main form will display the
"(Filtered) " part after the number of records.

I have this working now on a different combobox, the only difference
is the combobox that is working is using a field from the main form
instead of a field on the subform. I tried every permutation I could
think of, but I can't seem to be able to get the main form filtered
based on the subform's field.

It would be much appreciated any help that could be supplied. Thanks.
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:<41******* *************** *@per-qv1-newsreader-01.iinet.net.au >...
Assuming:
- the record is present in the subform (i.e. it does not match a
different
main form record);
- the text box where you enter the number to find is named "txtFind"
then you could put this code into the AfterUpdate event procedure of your
text box.

Private Sub txtFind_AfterUp date()
Dim rs As DAO.Recordset
Dim strWhere As String

If Not IsNull(Me.txtFi nd) Then
strWhere = "[PO Number] = " & Me.txtFind
With Me.[Form1].Form
Set rs = .RecordsetClone
rs.FindFirst strWhere
If rs.NoMatch Then
MsgBox "Not found"
Else
.Bookmark = rs.Bookmark
End If
Set rs = Nothing
End With
End If
End Sub
Notes:
1. If PO Number is a Text type field, you need extra quotes:
strWhere = "[PO Number] = """ & Me.txtFind & """"
2. The found record is displayed at the top of the subform.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"David" <da***@scene-double.co.uk> wrote in message
news:c1******** *************** ***@posting.goo gle.com...
> Hi,
>
> I have a form as follows:
>
> Main Form (To Select Customer)
> Sub Form 1 (To Select PO Number, by clicking on field) - Continuous
> form
> Sub Form 2 (To view order details)- Continuous form
> _______________ _______
>
> Normally, if I click on a PO Number in Sub-Form 1, Sub-Form 2 displays
> the details for that PO Number.
>
> What I am trying to do is have a text box & button on the main form
> which just does the same as me using the scroll bar on Sub-Form 1 to
> find a PO Number. I still want all the other PO Numbers shown, Just
> for the system to select the PO Number from the text box and move to
> that record without hiding all the other PO Numbers as maybe the
> 'Filter' method does.
>
> i.e.
>
> PO Number
>
> 5454
> 87676
> 7676
> 7676
> 656
>
> Normally when the form opens, the very first PO Number is selected
> automatically (5454). If I search for PO Number '656' then I want
> Sub-Form 1 to show
>
> 5454
> 3w43
> 656.....<< Selected Record.
> 90
> 34543
>
> Sub-Form 2 should then auto display the data for the searched for PO
> Number.
>
> I still want our users to be able to search again or scroll through
> all the PO Numbers.
>
> I have tried some other code which makes Sub-Form 1 display only the
> searched for PO Number & Sub-Form 2, but then I found it impossible to
> get both Sub Forms back to their state prior to the search.
>
> Appreciate your help.
>
> David

Nov 13 '05 #6
Allen,

After 3 days tearing my hair out, I solved the code by trial & error
along with yours & others postings.

Working Code as follows:

Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim strWhere As String

If Not IsNull(Me.Text5 4) Then
strWhere = "[PONumber] = """ & Me.Text54 & """"
With Me.[Orders Subform].Form
Set rs = .RecordsetClone
rs.FindFirst strWhere
If rs.NoMatch Then
Me.Text54.SetFo cus
MsgBox "PO Number **" & Me.Text54.text & "** does not
exist." & vbCrLf & "Please search again", vbInformation, "Incorrect PO
Number"
Me.Text54.SetFo cus
Else
.Bookmark = rs.Bookmark
Forms![Customer Orders]![OrderLines
Subform].Form![PODisplay].Caption = "** Search Results for PO Number: "
& Me.Text54 & " **"
End If
Set rs = Nothing
End With
End If

_______________ ____

It was the DAO reference that was throwing me.
This was only meant to be a simple search....Great to have it working at
last.

Thanks to everyone.

David

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #7
Well done!

Hope it all makes sense now, and was a worthwhile learning experience.

If you want more info on references, see:
http://members.iinet.net.au/~allenbrowne/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"David Gordon" <da***@scene-double.co.uk> wrote in message
news:41******** **************@ news.newsgroups .ws...
Allen,

After 3 days tearing my hair out, I solved the code by trial & error
along with yours & others postings.

Nov 13 '05 #8
Thank you Allen, that was just what I was looking for. I had a
previous program working by using subqueries but that was a complete
mess - this way was much cleaner and so much easier. I played around
with the sql a little to match what I had, and in about 5-10 minutes
had it working the way I wanted it. Thanks again.
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message news:<41******* *************** *@per-qv1-newsreader-01.iinet.net.au >...
See:
Filter a Form on a Field in a Subform
at:
http://members.iinet.net.au/~allenbrowne/ser-28.html

The article explains how to effectively filter the main form so it only
contains records that have a match in the subform, by reassigning the
RecordSource of the main form to an INNER JOIN statement.

(It is also possible to achieve the result by using a subquery in the Filter
of the main form.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"user_5701" <us*******@hotm ail.com> wrote in message
news:f1******** *************** ***@posting.goo gle.com...
Allen,
I have a similar problem and have been unable to find a solution that
works.

I have a main form, lets call it frmMain, with a subform control,
called sfrmControl, which has a subform on it called sfrmMain. I want
to put a combobox on the main form, which will filter the main form,
based on a field which is contained in the subform. When I do this
currently, a little box comes up (like a parameter input box) with the
name of the field, and a textbox asking me to type in a value.

I want to do this with filters, so when I select a value in the
combobox on the main form, it will filter the main form based on the
field from the subform, so that the main form will display the
"(Filtered) " part after the number of records.

I have this working now on a different combobox, the only difference
is the combobox that is working is using a field from the main form
instead of a field on the subform. I tried every permutation I could
think of, but I can't seem to be able to get the main form filtered
based on the subform's field.

It would be much appreciated any help that could be supplied. Thanks.
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:<41******* *************** *@per-qv1-newsreader-01.iinet.net.au >...
Assuming:
- the record is present in the subform (i.e. it does not match a
different
main form record);
- the text box where you enter the number to find is named "txtFind"
then you could put this code into the AfterUpdate event procedure of your
text box.

Private Sub txtFind_AfterUp date()
Dim rs As DAO.Recordset
Dim strWhere As String

If Not IsNull(Me.txtFi nd) Then
strWhere = "[PO Number] = " & Me.txtFind
With Me.[Form1].Form
Set rs = .RecordsetClone
rs.FindFirst strWhere
If rs.NoMatch Then
MsgBox "Not found"
Else
.Bookmark = rs.Bookmark
End If
Set rs = Nothing
End With
End If
End Sub
Notes:
1. If PO Number is a Text type field, you need extra quotes:
strWhere = "[PO Number] = """ & Me.txtFind & """"
2. The found record is displayed at the top of the subform.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"David" <da***@scene-double.co.uk> wrote in message
news:c1******** *************** ***@posting.goo gle.com...
> Hi,
>
> I have a form as follows:
>
> Main Form (To Select Customer)
> Sub Form 1 (To Select PO Number, by clicking on field) - Continuous
> form
> Sub Form 2 (To view order details)- Continuous form
> _______________ _______
>
> Normally, if I click on a PO Number in Sub-Form 1, Sub-Form 2 displays
> the details for that PO Number.
>
> What I am trying to do is have a text box & button on the main form
> which just does the same as me using the scroll bar on Sub-Form 1 to
> find a PO Number. I still want all the other PO Numbers shown, Just
> for the system to select the PO Number from the text box and move to
> that record without hiding all the other PO Numbers as maybe the
> 'Filter' method does.
>
> i.e.
>
> PO Number
>
> 5454
> 87676
> 7676
> 7676
> 656
>
> Normally when the form opens, the very first PO Number is selected
> automatically (5454). If I search for PO Number '656' then I want
> Sub-Form 1 to show
>
> 5454
> 3w43
> 656.....<< Selected Record.
> 90
> 34543
>
> Sub-Form 2 should then auto display the data for the searched for PO
> Number.
>
> I still want our users to be able to search again or scroll through
> all the PO Numbers.
>
> I have tried some other code which makes Sub-Form 1 display only the
> searched for PO Number & Sub-Form 2, but then I found it impossible to
> get both Sub Forms back to their state prior to the search.
>
> Appreciate your help.
>
> David

Nov 13 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
7479
by: JJMM | last post by:
Hi, I have a form (form1) with a large number of subforms inside it (around 20 subforms), There is the possibility of filtering the data using a pop-up form that create/change a query (all the subforms are linked to that query), Once that I create/change the query (using the pop-up form), Is there any easy way to update all the 20 subforms inside form1?. Normally I use to change the recordsource in each subform to show the
3
4010
by: Evil | last post by:
Hi, i have a problem with a treeview and some subforms in MS Access97. I have a form with a treeview on the left side which lets me navigate thru some projects. Then on the right side, i have several Tabs, each with a subform. Now, my tree view nodclick code goes like: sProjNum = me.tvwX.SelectedItem.Key
1
3000
by: M Wells | last post by:
Hi All, I am developing an Access 2003 project application with the back end in SQL Server 2003. I have a master form that tracks projects, and several subforms on it that track various aspects of the project. On the masterform I have two unbound listboxes that I populate with information regarding the current record in one of the subforms.
2
3013
by: Jack | last post by:
Hi all, I searched the archives and found everyone happy with Stephen's MouseWheel On/Off code except for those with subforms. Stephen's page indicates that he has added code to handle subforms ("Bug Fix for SubForms with ScrollBars. Bug fix for SubForms without visible ScrollBars.") - BUT I still can't get it to work on my app with my subforms. I'm using Access 2000, It works fine on the main forms but not on the
0
2248
by: Jack | last post by:
Gday everyone, I'm dearly hoping Stephen Lebans is going to update his masterpeice to stop the mouse wheel scrolling to work on subforms *he has indicated this to me but of course beggers can't be choosers here so I have no idea when this would be done*. I'm just wondering if anyone has gotten around the problem some other way? --Original Thread---
0
1445
by: Jason | last post by:
I would like to be able to place a command button on a primary (parent) form that opens up a subform. I want to use this subform to search for or limit the recordset of data in the primary form. The database is setup as follows: the primary form is named "TestDataCleanup" which is based on a table named "Test_Results". This primary form has multiple subforms associated with it, including "Names_Display" and "SiteAddresses_Display". The...
0
1550
by: Jason | last post by:
I would like to be able to place a command button on a primary (parent) form that opens up a subform. I want to use this subform to search for or limit the recordset of data in the primary form. The database is setup as follows: the primary form is named "TestDataCleanup" which is based on a table named "Test_Results". This primary form has multiple subforms associated with it, including "Names_Display" and "SiteAddresses_Display". The...
5
2643
by: Richard Stanton | last post by:
Hello all My database has a main form linked to table1. It has several subforms on the main form, all linked to table2. Table1 and Table2 are linked by primary/foreign key, no duplicates allowed, one-to-one. If I update field(s) on a single subform it works fine but when I update fields on multiple subforms ie without closing the form between updates, I get the following error:
7
4550
by: john | last post by:
In my form I have a master table and a details table linked 1xM. I can search through the whole parent table but I also like to be able to search through the child table fields to find parent records. Should I design a new form for this or can I somehow make this work in the same form. Thanks in advance, john
4
6079
by: Harlequin | last post by:
I have a question concerning the need to trigger events within a "child" subform which is itself enbedded within a master "parent" form and which is accessible via a tab in the parent form. Becuase this is all very difficult to explain in words, please bear with me as I endevour to explain what it is I am trying to do. It would be helpful if I could attach a graphics file to this posting that would help explain what it is I'm trying to achieve...
0
9961
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
11181
Oralloy
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...
0
10778
jinu1996
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...
1
10886
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10439
tracyyun
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...
0
9597
agi2029
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...
0
5819
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6014
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4245
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.