Help!! Problem with query

  • Thread starter Thread starter gene
  • Start date Start date
G

gene

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
 
Here is a very simple test app I am testing with

this is the SQl statment

SELECT Table1.*, Forms!Form1!inviocedate AS Expr1
FROM Table1;

Yes the form is still open
 
I have also opened up the immediate window and I can run ?
[Forms]![Form1]![inviocedate]
and it returns the right value
 
Try wrapping your control reference in CDate([Forms]![Form1]![inviocedate])

--
Duane Hookom
MS Access MVP
--

gene said:
I have also opened up the immediate window and I can run ?
[Forms]![Form1]![inviocedate]
and it returns the right value


Duane Hookom said:
Show us your SQL. The form remains open, correct?
Click to expand...
tried
up
Click to expand...
Click to expand...
 
You are a GENIUS!!!! Thanks so much that worked like a charm. I would never
have thought that was the problem!!!!!



Thanks Again
Duane Hookom said:
Try wrapping your control reference in CDate([Forms]![Form1]![inviocedate])

--
Duane Hookom
MS Access MVP
--

gene said:
I have also opened up the immediate window and I can run ?
[Forms]![Form1]![inviocedate]
and it returns the right value


Duane Hookom said:
Show us your SQL. The form remains open, correct?

--
Duane Hookom
MS Access MVP
--

Yes that happens when thy click on the command button to that runs the
udate
query

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

--
Duane Hookom
MS Access MVP
--

I am having a MAJor issue.

I have an ubond form with a field I am loading with a date. I
Click to expand...
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
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top