Thanks so much for your reply. I'm not all that familiar with VBA or SQL yet.
How would I customize the DOCMD.RunSQL "UPDATE examplerow FROM exampletabel WHERE criteria" to fit my problem?
I would like to delete the field "First" in table "tblStudent" and rename...
I don't know much but here's how to issue the command PAUSE to the shell.
Shell Environ("comspec") & " /c pause"
perhaps you can get the shell command to run a batch file?
ie: Shell Environ("comspec") & " /c batchfile.bat"
Hello. I'm a novice in Access VBA.
I have a some fields in a table that i would like to manipulate.
ie. delete a field, rename and set index property.
For example, tblstudent has the fields First and Last
How do I (in VBA):
1. delete the field "First"
2. rename...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.