Command() no longer supported in A2010

[GraeagleBill]

I need to covert an A2003 mdb to A2010. I need replacement functionality for the Command() function. Anyone know what that might be?
Thanks,


Bill Stanton

[JoeM]

I have never used the Command() function in Access myself, but Google searches returned this link regarding Command() and Access 2010. Perhaps it will solve your answer. If not, I am sure that people would need to see how you are using to try to determine what the issue may be.
http://social.msdn.microsoft.com/For...-33df732b1689/

[GraeagleBill]

My use is really simple. I have an Autoexec macro that has a single "Runcode" invoking a general module that contains a Case statement using Command(). The Case structure simple gates the applications behavior.

When I attempt to compile my 2003 mdb, I'm greeted with the error that the Command() function is no longer supported. Maybe there's something in reference library, but I couldn't any.

Bill

[JoeM]

Did you take a look at the link I provided, or the one at the bottom of that link?
http://social.msdn.microsoft.com/For...c-994d1a8b5f19

It might be helpful to others who are familiar with the Command() function if you can post the actual section of code that uses it.

[GraeagleBill]

Here's the code: (This function receives control via the "Runcode" -> TMSGate() coded in the AutoExec macro.)

Public Function TMSGate()
'*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=* =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*==
' This routine simply acts as the opening gate to TMS, in that it determines if we're running
' solely for the purpose of database backup or a normal startup of TMS.
'*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=* =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*==

Select Case Command()

Case "DBDist" 'Invoking syntax include the /cmd "DBDist" parameter?
DBDistribution 'Yes, Just attend to DB distribution

Case "SermonMgr" 'Sermon Manager running as a scheduled task
Call SermonMgrGate

Case Else
ScrRes 'No, get screen resolution and start TMS

End Select

End Function

[RuralGuy]

This link may be helpful: http://social.msdn.microsoft.com/For...b-6526b26fe704

[GraeagleBill]

Here is an example of how the command() functionality is required for one of the applications started tasks: (On a A2007 system)

"C:\Program Files (x86)\Microsoft Office\Office12\MSACCESS.EXE" "C:\GCC\TMS-V9.2.mde" /CMD SermonMgr