Actually without the #, everything works fine. The only issue is that the date picker inserts the time instead of the date. Access needs the #'s to enter dates from what I understand. This is why can't stand access.
Sent from my iPhone 5S > On Jun 28, 2014, at 10:34 PM, "C. Hatton Humphrey" <[email protected]> > wrote: > > >> On Sat, Jun 28, 2014 at 2:26 PM, Bruce Sorge <[email protected]> wrote: >> >> DoCmd.RunSQL > > > Took a look at > http://bytes.com/topic/access/answers/199515-docmd-runsql-not-reading-variable-combo-box > > Apparently the DoCmd.RunSQL doesn't know the Me object (or so the thread > says). Best help I can give on a short search. > > > Until Later! > C. Hatton Humphrey > http://www.eastcoastconservative.com > > Every cloud does have a silver lining. Sometimes you just have to do some > smelting to find it. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:371121 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
