Jumat, 26 Februari 2016

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

 

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@beaerospace.com> 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@beaerospace.com> 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: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

.

__,_._,___

Tidak ada komentar:

Posting Komentar