Cannot Convert Macros to VB in Access

I'm running Access 2010.  Why is the Macro Tools Design Tab  'Convert Macros to Visual Basic' always greyed out whenever I try converting any standard template db's or Northwind?  Is there a workaround?
zpotokAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
 If your working with a "web enabled" database, VBA is not available.  VBA is only available in a "standard" database (one that will not be published to sharepoint).

JimD.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
zpotokAuthor Commented:
So are you saying that all Access Templates available at MS Office downloads plus Northwind  are not 'standard' databases and therefore cannot be used without macros?  
That just doesn't make any sense to me.
0
Rey Obrero (Capricorn1)Commented:
zpotok,
JimD, said "web enabled" database, VBA is not available."  

not ALL
0
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
zpotok,

Would it be  possible fir you to give us a link to one of the templates that are not working?
Or at least teh steps to select the same template.  
0
zpotokAuthor Commented:
TheHiTechCoach:  per your request ---- When Access 2010 opens, file tab>new displays Available Templates.  Some are available under  Office.com Templates.  When I click on one template named Time & Billing it searches and brings up five templates.  I then downloaded 'Time Card' template and the 'Time & Billing' template.  Both have embedded macros but cannot convert due to being [greyed out]please explain and  how the heck does one know if they are web enabled?   Also, I can't imagine that 'Northwind Traders' database that has been around for many years is only available as web enabled.  
 Thanks
0
Rey Obrero (Capricorn1)Commented:
zpotok,

instead of downloading the "Web enabled versions", download the A2007 versions.

see this links

http://office.microsoft.com/en-us/templates/CT010142865.aspx?av=ZAC

http://office.microsoft.com/en-us/templates/CT010142824.aspx?av=ZAC
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
zpotok,

<<Also, I can't imagine that 'Northwind Traders' database that has been around for many years is only available as web enabled>

The Access 2007 version if Nortwind is totally different than any of the prior versions. It is not compatible with  prior versions of Access.  It looks like it went through a major rewrite/update. It know includes inventory control and much more!

Have you tried this::
Open the form in design view and use the Convert Form’s Macro to Visual Basic command.


Curious, why do you want to convert the embedded macros to VBA code?  Is there something you can't do with the improved macros in 2010?
0
zpotokAuthor Commented:
TheHiTechCoach:  Interesting info on Northwind Traders.  Why the heck did MS package only web enabled with their newest program?? Yes, I have opened the form in design view but same problem.  Also, I'm more familiar with vba - well at least more so than macros.

Capricorn:  The links you provide include a mix of both web enabled and standard which is what I was running across in my earlier statement.  It appears to me that one cannot differentiate if the download is web enabled or not until they download and open it.  
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
zpotok,

Since the Northwind database  has a lots of VBA code I won;t not expect it to be a web enabled  database.


I am finally back to my PC with Access 2010 installed. I download a new copy of Norhwind into a trusted location. I get an error trying to convert a form's embedded macros to VBA .

 Error converting
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<< Why the heck did MS package only web enabled with their newest program?? Yes, I have opened the form in design view but same problem.  Also, I'm more familiar with vba - well at least more so than macros.>>

 Starting with 2010, Microsoft has once again focused on macros and is trying to move away from the use of VBA within Access.  The cited reason is for security, as macros are under more control then VBA is.

 There is also a major focus on the use of SharePoint allowing Access DB's to be web enabled.

 Because of this, it doesn't surprise me that all the new templates would be  macro/web based (I haven't looked at any, so I don't know that for sure).  I'll fire up 2010 while I'm getting a cup of coffee a little latter to check.

JimD.
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
It is definitely a bug in Access 2010.  I can be duplicated.

Hopefully this will be fixed in the SP1 release.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

 Good to know.

 As an aside, I figured 2010 would be a more solid 2007 (much the way A97 was a better version of A95, and 2003 a better version of 2000).

  Seems like as we get more and more into 2010 though, that is turning out not to be the case.  I hope a SP comes along soon.

JimD.
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
JimD,

Prior  Access 2007 the Macro editor had not change much. Maybe not at all since Access 2000.

Were not have a new  Macro Design and Macros are that is still  in development in Access 2010. Like the new data macros in Access 2010.

0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Oops ... should have said:

We now have a new  Macro Design.  Macros are still in development in Access 2010. Like the new data macros in Access 2010.
0
zpotokAuthor Commented:
Thanks for the imput
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.