Re: Help!! Problem with query

From: Duane Hookom (duanehookom_at_NoSpamHotmail.com)
Date: 04/30/04 

Date: Thu, 29 Apr 2004 21:00:35 -0500

Have you moved your focus on the form out of the date text box? 

-- 
Duane Hookom
MS Access MVP
--
"gene" <gene@gte.net> wrote in message
news:%23JbtFOlLEHA.2932@TK2MSFTNGP12.phx.gbl...
> I am having a MAJor issue.
>
> I have an ubond form with a field I am loading with a date. I then run an
> update query to update a table pulling in the field from the form using
the
> fully qualified name of the field. When I look at the query as a select
the
> field is blanck even though I can see the date on the screen.
>
> I used to do the very same thing in an access 97 database and it STILL
works
> with out a problem I am trying to do it in Access 2002 I have tried up
> grading to sp2 and sp3 still no help. I have tried it on 2 different
> mahcines. I am stumpted I would appreciate ANY help on this matter
>
> thanks
>
>

Relevant Pages

  • Re: Loop through records
    ... >> It doesn't get an more efficient or easier than an update query: ... >> Duane Hookom ... >> MS Access MVP ... >>> Dim rs As Recordset ...
    (microsoft.public.access.formscoding)
  • Re: Can I use a query to find and replace a word in a string?
    ... You could create an update query like: ... MS Access MVP ... "Duane Hookom" wrote: ... example if the field said Routed to NAAO TelePartner .....I only want ...
    (microsoft.public.access.queries)
  • Re: Update Query - Expression to Delete Rows
    ... Duane Hookom ... MS Access MVP ... >I setup an Update Query and I would like to Build and Expression to ...
    (microsoft.public.access.queries)
  • Re: Fill Field in same value
    ... This is a bit like hitting a moving target. ... MS Access MVP ... "Duane Hookom" wrote: ... create an update query with sql like: ...
    (microsoft.public.access.gettingstarted)
  • Re: Help!! Problem with query
    ... "gene" wrote in message ... > I have also opened up the immediate window and I can run? ... > "Duane Hookom" wrote in message ... >> MS Access MVP ...
    (microsoft.public.access.queries)