Microsoft Access: Command() doesn’t return command-line text
Microsoft Access: Command() doesn’t return command-line text
I wrote this plea for help for a project I’m working on. I can’t get the command line option to pass into Access correctly. I use Command() to try to access the options, but get Null.
UPDATE:
Turns out that the Microsoft Access wizard for creating switchboards creates a field called [Command]. Bad practice! Don’t use reserved words for field names! So, in referring to Command(), I was actually getting [Command]. By qualifying the statement as Interaction.Command I was able to get the command-line. Whew.
So, apparently the fellow that wrote the switchboard never tried to read command-line entries and the guy that wrote the command-line entry code never used a switchboard!
