We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Help with 2007 Access Template Combo Box Record Search

zpotok
zpotok asked
on
Medium Priority
1,217 Views
Last Modified: 2013-11-27
The following MS Office 2007 Access Template <Faculty> link:

office.microsoft.com/en-us/templates/faculty-TC001225346.aspx

...has a nice record search displaying the selected record in a textbox (actually this is pretty generic in most of their 2007 templates).  I've been trying to incorporate this into my form but I want nothing to do with embeded macros.  Stick with VBA.
Can someone please provide the After Update and On Got Focus for their cboGoToContact combo so it will show in the textbox exactly as in the Faculty Details Form on the Template using event procedures instead of the macros.  .  
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016

Commented:
you can convert those macros to VBA codes

open form in design view,
from ribbon
        Database tools > Macro
             Convert from's macro to Visual Basic

Author

Commented:

Where is Database Tools > Macro? I'm using Access 2010


 Database Tools Macro
CERTIFIED EXPERT
Top Expert 2016

Commented:
for Access 2010, click Design, it will be at the Right  most part of the ribbon, but
as we have discussed before, this is a known bug in A2010.

wait till i get home and i will convert it using A2007 and post the VBA codes here.
CERTIFIED EXPERT
Top Expert 2016
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thanks (once again) for your help.

sure wish they would come out with a A2010 service patch....
CERTIFIED EXPERT
Top Expert 2011

Commented:
The Office 2010 SP1  should be coming out soon.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.