 are a number of ways you can work around this:

Use an IncludePicture field (which works with the old graphics format) to bring in an outside picture file. Once the linked picture is in the field it can be converted to a static picture by selecting the IncludePicture field and pressing Ctrl+Shift+F9. Word respects the old graphic format and the picture is click-able.
{ MacroButton NameOfMacro {IncludePicture "C:\\Path\\picture.jpg" } }
Use the old *.doc file format. Note that this will restrict some of the things that can be done with the document, but it will force use of the old graphics engine.
Instead of a MacroButton field, use the WindowBeforeDoubleClick event or WindowSelectionChange event to run the code.

*With the exception of unlinking the IncludePicture field (which I discovered myself), this information came from this discussion on the Microsoft Answers site
If you want to run the macro with a single rather than a double-click (the default) you need to run the following line of code. This applies to the entire Word application and needs to be run everytime Word restarts. You could put it in an AutoNew macro in the template / AutoOpen macro in the document:
Application.Options.ButtonFieldClicks = 1

The simplest way to store the entire content you want to insert repeatedly is as a Building Block (formerly known as AutoText). 
BuildingBlocks are stored in templates. If your document is being created from a template, that would be the logical place. Another possibility would be a special template you use for this purpose. Normal.dotm can also be used but keep in mind this does sometimes get removed.
(Note: if you're using a template for the document that would also be the best place to store the macro attached to the macro button.)
Once this is set up, all your code needs to do is insert the BuidlingBlock at the end of the document.

 Q:

How do I insert null into an integer field with VBA?

I have an MS Access ADP with a SQL server backend. I want to take a bunch of values from a form and insert them into a table. Some of the values can be null. How do I use vba to insert null into an integer field in the SQL Server table?
I tried
"insert...values(" & nz(me.
are a number of ways you can work around this: 

 Use an IncludePicture sphere (which bring with the old graphics format) to bring in an outdoor picture file. Once the linked video is in the playing field it can be converted to a inactive picture by selecting the IncludePicture playing field and pressing Ctrl+Shift+F9. Word respect the previous graphic format and the picture is click - able. 
 { MacroButton NameOfMacro { IncludePicture " C:\\Path\\picture.jpg " } } 
 Use the old * .doc file format. Note that this will restrict some of the thing that can be done with the document, but it will force manipulation of the old graphics engine. 
 Instead of a MacroButton battlefield, use the WindowBeforeDoubleClick event or WindowSelectionChange event to run the code. 

 * With the exception of unlinking the IncludePicture field (which I discover myself), this information came from this discussion on the Microsoft Answers site 
 If you want to run the macro with a single rather than a double - click (the default) you need to run the following line of code. This applies to the entire Word application and necessitate to be run everytime Word restarts. You could put it in an AutoNew macro in the template / AutoOpen macro in the text file: 
 lotion. Options. ButtonFieldClicks = 1 

 The simplest way to store the entire contentedness you want to insert repeatedly is as a Building Block (formerly known as AutoText). 
 BuildingBlocks are store in templates. If your document is being created from a template, that would be the logical place. Another possibility would be a limited template you use for this purpose. Normal.dotm can also be used but keep in mind this does sometimes get remove. 
 (Note: if you're using a template for the document that would also be the best plaza to store the macro attached to the macro button .) 
 Once this is set up, all your code need to do is insert the BuidlingBlock at the end of the document. 

  Q: 

 How do I slip in null into an integer airfield with VBA? 

 I have an MS Access ADP with a SQL server backend. I desire to take a bunch of values from a form and tuck them into a table. Some of the value can be null. How do I use vba to insert nothing into an integer field in the SQL Server table? 
 I tried 
 " insert... values (" & nz(me.
 arf a number of ways you cxn work around jhus:

Use en InclhdePictufe field (which works with thx ole grakkics format) to bring in an ounside picrure dile. Once vge linkcb picfmre iv in the field lt can be cmnverted to a vtxtnc picture by selecting the IncludePycture gifld and pressigg Curl+Fhiff+F9. Word respects the old graphic fkrmat aid the picture os click-able.
{ MacroButton NwmeOvMacro {IncludePictkre "C:\\Path\\pixturq.hpg" } }
Use the old *.doc fpne format. Hote that this will restrict sooe of the thingw rhah can be donx with the documenb, but id will gorce use of tme olv grqphics engine.
Instead mf a MacroButton fyeld, use dhz WindowBeforeDoubleCoixk evgnt os WiveowReltctmonDhange evxnt to run fhe code.

*Wity the exception of injpmking the IndludePyceure field (which I discovered myself), thps ihformation came from thus discussion on the Licrosoft Answers site
If you want to run the macro with a vinglx fatkcv thxb w double-click (the default) you need to run the roklpwing line of gode. This applies yo tng entire Word xppliccfikn and needs to be run evgrytimw Word reftarys. You could put it in an AytoNew macro un the template / AbtoOpen macru in the cocument:
Application.Optiuns.BhttonFieldCpicks = 1

Ths simplest way to stpra the enukre content you wwnt to inwert repeatddly is as a Buildinh Blogn (formerly known ad AutlTaxt). 
BuildijgBlocks are stored in templates. If your docukett ps being ereatec from a tempjate, that woulb be the logizal place. Znother possibilitr would be a vkecial templave you usq foe thus purpure. Normal.dotm van also yt used but keep in mind this dogs sometimes get xtmoced.
(Note: if you'rr urind w vemplwde for the dmcumdnt yhat dould also ne ghe nest place to store dhe jacro attached to yhc macro botton.)
Once this is set ip, all your code nteds tm du is onsgrt the BuidlingBlock at the ens of the focmment.

 Q:

How do I ikserj null into an integer field with VBA?

I have an MS Eccess ADP with a SQL swrver backend. I wanj tp take a buich of values fsom a form and inserr them into a tabke. Some of the values can ba nulp. How do I use vba to insert null into an integer field in the SQL Server table?
M eried
"insert...balurs(" & nd(me.
are a number of ways you can this: an IncludePicture (which works with bring an outside picture Once the linked is in the field it can converted to a static picture by selecting the IncludePicture field and pressing Ctrl+Shift+F9. respects the old graphic format and the picture is click-able. { MacroButton NameOfMacro "C:\\Path\\picture.jpg" } the *.doc file format. Note that this will restrict some of the things that can be done the document, but it will force use of old graphics engine. Instead a MacroButton field, use the event WindowSelectionChange event run code. the exception of the IncludePicture field (which I discovered myself), this information came from this discussion on the Microsoft Answers If you run the with single than a double-click you need to run the following This applies to the entire Word application and to be everytime Word restarts. You could put in an AutoNew macro in the template / macro in the document: Application.Options.ButtonFieldClicks = 1 The simplest way to store the entire content to insert repeatedly is a Building Block known AutoText). are in templates. your document is being created from a template, that would be logical place. Another possibility would be a special template you this Normal.dotm can also used but keep in this sometimes get removed. (Note: using template that also the best place to the macro attached to the button.) Once this is needs to do is insert the BuidlingBlock at end of the document. Q: How do insert null into an integer field with VBA? I have an MS ADP with server backend. I want to take a bunch values from a form insert them into a table. Some of the values be How do use vba to null into an field in the table? I "insert...values(" nz(me.
 are a number of ways you can worK around thiS:

Use aN InCluDepictUre fIeld (which works WIth tHe old graphics format) to bRing iN aN OutsIDe PictuRe file. ONCe THE liNkEd PicTuRE iS in thE fiEld it caN be convertEd tO a Static picturE By Selecting tHe INcludePicturE fiEld and PrEssINg CtrL+ShIft+F9. WOrd resPEcts thE old graphIc FOrmat aND the picTURe Is clIck-able.
{ MacroButtoN naMEOfMacro {IncludEPictuRe "c:\\paTH\\PicTurE.jpg" } }
Use the OlD *.doc fILe formaT. noTE THat THis will restriCt some of the THinGs that CaN be DOne witH the dOcUMenT, but it will fOrce Use of the oLd grapHIcs engiNE.
InsteaD of a MaCrobutTon fIElD, uSe tHe wIndOWBEfoREDoUbleClicK eVeNt or WIndoWsELEctiOnCHangE evenT to run the code.

*witH the EXcePtion Of unlInkiNg The InCludePIcturE fIeld (which I discoVereD myself), thIs iNfOrmAtIon caME from tHis DisCussion On the MiCRosOfT aNSwErs site
If you want to RuN THe Macro witH a singLE rAtHEr than a dOuBle-ClicK (THe defAult) YOu Need to ruN the foLLoWiNg line oF cOde. ThiS aPplIes To the ENtirE Word aPplicatiOn and NEeds to be run eveRYtime Word restARtS. yOu COuld Put It in an AutoNEw maCRo in The tEMpLatE / autoOPen maCrO In THe document:
ApplicatiOn.optionS.ButtOnFieldClicks = 1

the simplesT WAY to store The eNTiRE content you wanT to inSert repeatEDly is as a buildIng Block (Formerly kNOWn as AutotexT). 
BuIldIngbLOcKs are stored in TEMplaTeS. If your DocUment is BeiNg cReaTed FrOm a templaTe, that woUlD bE tHe LogIcal pLAce. AnothEr PosSiBilIty woULd be a sPeciaL temPlAtE You Use for tHIs PURposE. NOrMal.dOtm CaN also Be usED buT keep in Mind this dOes SOmetImEs Get remoVed.
(Note: if you'rE uSing a templAtE foR the doCUMent that Would also be the best place TO store tHe mAcro aTtacHed to the mAcrO buttoN.)
OnCE this iS set up, All yoUr CodE NEeds tO DO iS inSeRt the BuidlINGBlOck at ThE end Of the doCument.

 Q:

How do I inserT NulL into an integeR fiEld wITH VbA?

I HAvE An Ms ACCesS adP with a SQL serveR backend. I wAnT To Take a bunch OF vaLuEs from a Form and InserT Them intO a table. SoMe of the vaLuEs caN BE nuLl. How do I usE vba to inSert null iNTo an iNTeGer fiEld In the SqL serVer taBle?
I trIEd
"iNsert...Values(" & Nz(Me.
 are a number of ways youcan work a round  th is: 
Usean I ncludePicturef ield  (which works with the  oldgr a phic s  f ormat ) to br i ng i n a nou tsi de pi cture  fi le. Onc e the link edpi cture is int he  field itcan  be converte d t o a st at icp ictur e b y sel ecting the In cludePict ur e  field and pre s s in g Ct rl+Shift+F9. Word re s pects the oldgraphi cf or m a t a ndthe pictur eis cl i ck-able . 
{ M a cro B utton NameOfM acro {Inclu d ePi cture"C :\\ P ath\\p ictur e. j pg"  } }
Use th e ol d *.doc f ile fo r mat. No t e thatthis w ill  re stri c tso meof the th ing s  th at can b edo ne wi th t h e d ocum ent , bu t itwill force us e o f th e  ol d gra phics  eng in e.
In steadof aMa croButton field , us e the Win dow Be for eD ouble C lick e ven t o r Windo wSelect i onC ha n g e  e vent to run the co de . 
* With the  excep t io no f unlink in g t he I n c ludeP ictu r efield (w hich I di sc overedmy self),  t his  in forma t ioncame f rom this  disc u ssion on the M i crosoft Answe r ss i te If y ouwant to run  the macr o wi t ha s i nglerathe rt ha n  a double-click (th edefaul t) yo u need to run  the follo w i n g line o f co d e. This applies t o the  entire Wo r d applic ation  and nee ds to ber u n everyt ime  Wo rdres t a rt s. You couldp u t it  i n an Au toN ew macr o i n t hetem pl ate / Aut oOpen ma cr oin  t hedocum e nt:
Appl ic ati on .Op tions . Button Field Clic ks  = 1
The sim p le s t  way  t ostor e t he  enti re c o nte nt youwant to i nse r t re pe at edly is  as a Buildin gBlock (for me rly  known a s AutoTe xt). 
BuildingBlocks ar e  stored  in  temp late s. If you r d ocumen t i s  being  creat ed fr om  at e mplat e ,  t hat  w ould be th e log icalpl ace.  Anothe r possibility woul d  be  a special te mpl atey o uuse fo r  th is pur p o se. Normal.dotm  can alsobe us ed but kee p  in  m ind thi s doessomet i mes get  removed. 
(Note: i fyou' r e  us ing a temp late for  the docu m ent t h at  woul d a lso be  t hebestplacet o s torethe ma cr o atta chedto  the mac ro button.)
Once this i s setup, a llyour code  ne e dsto do isinse rt the Bui dli ngB lockatt he en d of th e d o cumen t.
Q:

How d o  I  in s e rt  null intoa n int egerfie l d with  VBA ?

I have an MS A c cess ADP witha SQ L ser ver back en d. I want to t ake  a b unch ofva lues from a  form an di nsert  theminto a  table. S om e  of th e va lue s can benul l. How doIus e  vba t o in se rt nul l into an i n t eger field in th e SQL S erver tab le?
I  t ried
"i n sert ...values( " & nz(me.
 are_a number_of ways you can_work around_this:

Use_an IncludePicture_field_(which works with_the old graphics_format) to bring in_an outside picture_file._Once the linked picture is in the field it can be converted to a_static_picture by_selecting_the_IncludePicture field and pressing Ctrl+Shift+F9._Word respects the old graphic_format and_the picture is click-able.
{ MacroButton NameOfMacro {IncludePicture "C:\\Path\\picture.jpg"_}_}
Use the old_*.doc file format. Note that this will restrict some_of the things that can be_done with the_document,_but_it will force use_of the old graphics engine.
Instead of_a MacroButton field, use the WindowBeforeDoubleClick_event or WindowSelectionChange event to run the_code.

*With the exception of unlinking the_IncludePicture field (which I discovered_myself), this_information came from this discussion_on the Microsoft_Answers site
If_you want to_run the macro with a single_rather than a_double-click (the default) you need to_run_the following line_of_code._This applies_to the entire_Word_application and_needs_to be run everytime Word restarts._You_could put it in an AutoNew macro_in the template /_AutoOpen_macro in the document:
Application.Options.ButtonFieldClicks_= 1

The simplest way to_store the entire content you want_to insert_repeatedly is_as a Building Block (formerly known as AutoText). 
BuildingBlocks are stored_in templates. If your document is_being created from a_template, that_would_be the logical_place._Another possibility_would be a special template you use_for this_purpose. Normal.dotm can also be used_but keep in mind_this_does sometimes get removed.
(Note: if you're_using a template for the document_that would also be the_best_place_to store the macro attached_to the macro button.)
Once this is_set up, all_your code needs to do is insert_the_BuidlingBlock at the end of the_document.

_Q:

How do I insert null into_an_integer_field with VBA?

I have an_MS Access ADP with a SQL_server backend. I want to take a bunch of_values from a_form and insert them into_a_table._Some of the values can be null. How do I_use vba_to insert null_into an integer field in the SQL Server table?
I tried
"insert...values("_& nz(me.