Senin, 29 Februari 2016

RE: [MS_AccessPros] Re: programming the "find" window location

 

Got it. Thanks Bill!



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

Doyce

That difference is that any control in the detail section is really a copy on that control for each row. In other words, if you select a value in an unbound control for one record all the records will have that control with that value.

Putting it in the form header assures a unique unbound control for the entire form.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



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

Question for Bill or one of the other pros, is there a difference whether this combo box lookup is put in the header section or the detail section? I understand the difference in a header section and detail section in a report but I'm not sure what difference there is between a header section on a form and the detail section.


Doyce



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

Thanks Bill!  I'll check it out. 

 

First I gotta fix a new project that went over 2 gb.  I'm in line for an sql server for it, but in the interim I have to fix this issue.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, February 26, 2016 11:18 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: programming the "find" window location

 



Liz

 

here is a simple one using a combo box in the main form's header:

 

Private Sub cboSearch_AfterUpdate()

    Dim rs As DAO.Recordset

 

    If Len(Me.cboSearch & vbNullString) = 0 Then Exit Sub

 

    Set rs = Me.Recordset

    rs.FindFirst "ProjectNum=" & Me.cboSearch

    

    'Clear search box

    cboSearch = Null   

    Set rs = Nothing

End Sub

 

-Bill



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

Hello Bill!  You know, I didn't know I could do it this other way.  If I put controls in the forms header the code that corresponds to that wouldn't be the f&r header?

I'm just using code that had been built from the wizards and never pursued any other method.  Wow.

 

What does your code look like behind the forms header controls?

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, February 26, 2016 9:28 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: programming the "find" window location

 



Hi Liz

 

No, I don't think so. You will have to make your own find & replace form or put the controls in the form's header. That's the way I usually do it. Why are you automatically opening the F&R window?

 

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP

My nothing-to-do-with-Access blog

 



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

Pros, is there! a way to force the location for the find window that pops up?

From: Bob Davis
Sent: Thursday, February 25, 2016 11:28 PM
To: Liz Ravenwood
Subject: Back Shop Tracker

Good Morning Liz,

Question:

When we open Back Shop Tracker we immediately open the FIND THE WO TO EDIT at the top left of the screen. It then opens another smaller window called FIND AND REPLACE. When this window opens, it opens right in the middle top portion of the screen. A weird place! We then have to drag it over to the empty space to the right where I illustrate in the attached file. Is it a problem to change the code so that when we open that tab, it automagically appears in THIS location? No a huge problem in the scope of life's issues, but it would make it nicer and cleaner for us.

Thank you kindly, Now enjoy your Friday!




 

__._,_.___

Posted by: winberry.doyce@roadsysinc.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (10)

.

__,_._,___

Re: [MS_AccessPros] Re: programming the "find" window location

 

Thanks John. I understand why it would be necessary in a form with continuous view.


Doyce



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

Doyce-

I always put such unbound "search" combo boxes in the Header of a bound form - particularly if the form is in Continuous view.

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 
(Paris, France)



On Feb 29, 2016, at 2:19 PM, winberry.doyce@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Question for Bill or one of the other pros, is there a difference whether this combo box lookup is put in the header section or the detail section? I understand the difference in a header section and detail section in a report but I'm not sure what difference there is between a header section on a form and the detail section.


Doyce



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

Thanks Bill!  I'll check it out. 

 

First I gotta fix a new project that went over 2 gb.  I'm in line for an sql server for it, but in the interim I have to fix this issue.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, February 26, 2016 11:18 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: programming the "find" window location

 



Liz

 

here is a simple one using a combo box in the main form's header:

 

Private Sub cboSearch_AfterUpdate()

    Dim rs As DAO.Recordset

 

    If Len(Me.cboSearch & vbNullString) = 0 Then Exit Sub

 

    Set rs = Me.Recordset

    rs.FindFirst "ProjectNum=" & Me.cboSearch

    

    'Clear search box

    cboSearch = Null   

    Set rs = Nothing

End Sub

 

-Bill



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

Hello Bill!  You know, I didn't know I could do it this other way.  If I put controls in the forms header the code that corresponds to that wouldn't be the f&r header?

I'm just using code that had been built from the wizards and never pursued any other method.  Wow.

 

What does your code look like behind the forms header controls?

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, February 26, 2016 9:28 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: programming the "find" window location

 



Hi Liz

 

No, I don't think so. You will have to make your own find & replace form or put the controls in the form's header. That's the way I usually do it. Why are you automatically opening the F&R window?

 

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP

My nothing-to-do-with-Access blog

 



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

Pros, is there! a way to force the location for the find window that pops up?

From: Bob Davis
Sent: Thursday, February 25, 2016 11:28 PM
To: Liz Ravenwood
Subject: Back Shop Tracker

Good Morning Liz,

Question:

When we open Back Shop Tracker we immediately open the FIND THE WO TO EDIT at the top left of the screen. It then opens another smaller window called FIND AND REPLACE. When this window opens, it opens right in the middle top portion of the screen. A weird place! We then have to drag it over to the empty space to the right where I illustrate in the attached file. Is it a problem to change the code so that when we open that tab, it automagically appears in THIS location? No a huge problem in the scope of life's issues, but it would make it nicer and cleaner for us.

Thank you kindly, Now enjoy your Friday!




This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.


[Non-text portions of this message have been removed]





This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

 
 







This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Posted by: winberry.doyce@roadsysinc.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (9)

.

__,_._,___

RE: [MS_AccessPros] Re: programming the "find" window location

 

Doyce


That difference is that any control in the detail section is really a copy on that control for each row. In other words, if you select a value in an unbound control for one record all the records will have that control with that value.

Putting it in the form header assures a unique unbound control for the entire form.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



---In MS_Access_Professionals@yahoogroups.com, <winberry.doyce@roadsysinc.com> wrote :

Question for Bill or one of the other pros, is there a difference whether this combo box lookup is put in the header section or the detail section? I understand the difference in a header section and detail section in a report but I'm not sure what difference there is between a header section on a form and the detail section.


Doyce



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

Thanks Bill!  I'll check it out. 

 

First I gotta fix a new project that went over 2 gb.  I'm in line for an sql server for it, but in the interim I have to fix this issue.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, February 26, 2016 11:18 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: programming the "find" window location

 



Liz

 

here is a simple one using a combo box in the main form's header:

 

Private Sub cboSearch_AfterUpdate()

    Dim rs As DAO.Recordset

 

    If Len(Me.cboSearch & vbNullString) = 0 Then Exit Sub

 

    Set rs = Me.Recordset

    rs.FindFirst "ProjectNum=" & Me.cboSearch

    

    'Clear search box

    cboSearch = Null   

    Set rs = Nothing

End Sub

 

-Bill



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

Hello Bill!  You know, I didn't know I could do it this other way.  If I put controls in the forms header the code that corresponds to that wouldn't be the f&r header?

I'm just using code that had been built from the wizards and never pursued any other method.  Wow.

 

What does your code look like behind the forms header controls?

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, February 26, 2016 9:28 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: programming the "find" window location

 



Hi Liz

 

No, I don't think so. You will have to make your own find & replace form or put the controls in the form's header. That's the way I usually do it. Why are you automatically opening the F&R window?

 

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP

My nothing-to-do-with-Access blog

 



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

Pros, is there! a way to force the location for the find window that pops up?

From: Bob Davis
Sent: Thursday, February 25, 2016 11:28 PM
To: Liz Ravenwood
Subject: Back Shop Tracker

Good Morning Liz,

Question:

When we open Back Shop Tracker we immediately open the FIND THE WO TO EDIT at the top left of the screen. It then opens another smaller window called FIND AND REPLACE. When this window opens, it opens right in the middle top portion of the screen. A weird place! We then have to drag it over to the empty space to the right where I illustrate in the attached file. Is it a problem to change the code so that when we open that tab, it automagically appears in THIS location? No a huge problem in the scope of life's issues, but it would make it nicer and cleaner for us.

Thank you kindly, Now enjoy your Friday!




 

__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (8)

.

__,_._,___

Re: [MS_AccessPros] Re: programming the "find" window location

 

Doyce-


I always put such unbound "search" combo boxes in the Header of a bound form - particularly if the form is in Continuous view.

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 
(Paris, France)



On Feb 29, 2016, at 2:19 PM, winberry.doyce@roadsysinc.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Question for Bill or one of the other pros, is there a difference whether this combo box lookup is put in the header section or the detail section? I understand the difference in a header section and detail section in a report but I'm not sure what difference there is between a header section on a form and the detail section.


Doyce



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

Thanks Bill!  I'll check it out. 

 

First I gotta fix a new project that went over 2 gb.  I'm in line for an sql server for it, but in the interim I have to fix this issue.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, February 26, 2016 11:18 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: programming the "find" window location

 



Liz

 

here is a simple one using a combo box in the main form's header:

 

Private Sub cboSearch_AfterUpdate()

    Dim rs As DAO.Recordset

 

    If Len(Me.cboSearch & vbNullString) = 0 Then Exit Sub

 

    Set rs = Me.Recordset

    rs.FindFirst "ProjectNum=" & Me.cboSearch

    

    'Clear search box

    cboSearch = Null   

    Set rs = Nothing

End Sub

 

-Bill



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

Hello Bill!  You know, I didn't know I could do it this other way.  If I put controls in the forms header the code that corresponds to that wouldn't be the f&r header?

I'm just using code that had been built from the wizards and never pursued any other method.  Wow.

 

What does your code look like behind the forms header controls?

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, February 26, 2016 9:28 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: programming the "find" window location

 



Hi Liz

 

No, I don't think so. You will have to make your own find & replace form or put the controls in the form's header. That's the way I usually do it. Why are you automatically opening the F&R window?

 

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP

My nothing-to-do-with-Access blog

 



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

Pros, is there! a way to force the location for the find window that pops up?

From: Bob Davis
Sent: Thursday, February 25, 2016 11:28 PM
To: Liz Ravenwood
Subject: Back Shop Tracker

Good Morning Liz,

Question:

When we open Back Shop Tracker we immediately open the FIND THE WO TO EDIT at the top left of the screen. It then opens another smaller window called FIND AND REPLACE. When this window opens, it opens right in the middle top portion of the screen. A weird place! We then have to drag it over to the empty space to the right where I illustrate in the attached file. Is it a problem to change the code so that when we open that tab, it automagically appears in THIS location? No a huge problem in the scope of life's issues, but it would make it nicer and cleaner for us.

Thank you kindly, Now enjoy your Friday!




This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.


[Non-text portions of this message have been removed]





This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

 
 







This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Posted by: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)

.

__,_._,___

RE: [MS_AccessPros] Re: programming the "find" window location

 

Question for Bill or one of the other pros, is there a difference whether this combo box lookup is put in the header section or the detail section? I understand the difference in a header section and detail section in a report but I'm not sure what difference there is between a header section on a form and the detail section.


Doyce



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

Thanks Bill!  I'll check it out. 

 

First I gotta fix a new project that went over 2 gb.  I'm in line for an sql server for it, but in the interim I have to fix this issue.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, February 26, 2016 11:18 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: programming the "find" window location

 



Liz

 

here is a simple one using a combo box in the main form's header:

 

Private Sub cboSearch_AfterUpdate()

    Dim rs As DAO.Recordset

 

    If Len(Me.cboSearch & vbNullString) = 0 Then Exit Sub

 

    Set rs = Me.Recordset

    rs.FindFirst "ProjectNum=" & Me.cboSearch

    

    'Clear search box

    cboSearch = Null   

    Set rs = Nothing

End Sub

 

-Bill



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

Hello Bill!  You know, I didn't know I could do it this other way.  If I put controls in the forms header the code that corresponds to that wouldn't be the f&r header?

I'm just using code that had been built from the wizards and never pursued any other method.  Wow.

 

What does your code look like behind the forms header controls?

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, February 26, 2016 9:28 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: programming the "find" window location

 



Hi Liz

 

No, I don't think so. You will have to make your own find & replace form or put the controls in the form's header. That's the way I usually do it. Why are you automatically opening the F&R window?

 

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP

My nothing-to-do-with-Access blog

 



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

Pros, is there! a way to force the location for the find window that pops up?

From: Bob Davis
Sent: Thursday, February 25, 2016 11:28 PM
To: Liz Ravenwood
Subject: Back Shop Tracker

Good Morning Liz,

Question:

When we open Back Shop Tracker we immediately open the FIND THE WO TO EDIT at the top left of the screen. It then opens another smaller window called FIND AND REPLACE. When this window opens, it opens right in the middle top portion of the screen. A weird place! We then have to drag it over to the empty space to the right where I illustrate in the attached file. Is it a problem to change the code so that when we open that tab, it automagically appears in THIS location? No a huge problem in the scope of life's issues, but it would make it nicer and cleaner for us.

Thank you kindly, Now enjoy your Friday!




This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.


[Non-text portions of this message have been removed]





This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

 

 






This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Posted by: winberry.doyce@roadsysinc.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)

.

__,_._,___

Minggu, 28 Februari 2016

[belajar-access] Query denga kriteria IF dari Form [1 Attachment]

 
[Attachment(s) from nur kholis nur_ceper@yahoo.co.id [belajar-access] included below]

mau tanya apakah criteria di query bisa menggunakan IIF ya ... saya ingin membuat laporan harian berdasarkan form kok belum nemu ... jadi misal di form dipilih photo query yang muncul adalah yang hanya kriteria foto, apabila dipilih non photo yang keluar yang selain poto,

klo diquery dah bisa pake Like dan Not Like ... masalah timbul ketika ingin saya sambungkan dengan form ....

mohon bantuan semua .....


best regard,

__._,_.___

Attachment(s) from nur kholis nur_ceper@yahoo.co.id [belajar-access] | View attachments on the web

1 of 1 File(s)


Posted by: nur kholis <nur_ceper@yahoo.co.id>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
SPAM IS PROHIBITED

.

__,_._,___