Re: Return ID value of inserted record, and populate text box

Ok, the problem is that I am trying to compare STUDENTS.stu_birthday, which
is a date field, to txtDOB, which is text. So, now my problem is, how to I
convert this line...

'"AND s.stu_birthday = '" & Me.txtDOB.Value & "';"

In TSQL I would want 'AND s.stu_birthday = CONVERT(SMALLDATETIME,me.txtDOB,
101)'

Can you tell me how to do this with VB? Thanks for the help.

gsnidow wrote:
Thanks for the quick reply. Well, now I am getting a different error, "Data
type mismatch in criteria expression", so I guess that is progress. Could
that be because the value of STUDENT_ID being returned is number, and
txtSTUDENT_ID is text?

See whether it makes a difference using

[quoted text clipped - 5 lines]
Me.txtStudent_ID = (rsSTUDENT_ID("STUDENT_ID"))
Me.txtUser.Requery

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: OK, mummies are broken
    ... Let me pin down in which ways the new scoring system should be ... system which tries to measure won Crawl games linearly is full ... compare a 3-rune speedrun to a challenge combination full runer. ... a single meter of progress is both traditional and useful. ...
    (rec.games.roguelike.misc)
  • Re: Fill DataTable Progress
    ... You MUST know what the target is before you can compare anything to the ... The dataadapter has no knowledge of how may rows it is going to 'import' ... overhead will be negible but if it is complex and/or inefficient then the ... Having progress information is all very nice, so long as it does not impact ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Western Force: Rome wasnt built in a century
    ... The team is not making the progress we hoped for, ... We could do with some good news. ... they couldn't compare to the woeful displays by the Highlanders and ... Reds/Force game in its entirety, but I watched enough to know that as a ...
    (rec.sport.rugby.union)
  • Re: SA round up
    ... What's your successful ... Kiwis go on about my use of stats, then compare apples and oranges. ... It's progress once you get your inadequate intellect around it. ...
    (rec.sport.rugby.union)