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?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor 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
 
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
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 MVPConnect With a Mentor Commented:
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 MVPCommented:
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 MVPCommented:
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 MVPCommented:
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 MVPCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.