i have problem with date format
hi dears.
i have little problem with date format. i already created one table and there was birthday date/time format.
when i use txtbirth.text="" it was problem.
i am using mask "##/##/####"
what can i do? how can i use date inpuut field and how can i update to database=? i must use cdate() function?
Thanks already
[365 byte] By [
hotshots] at [2007-11-11 8:09:55]
# 1 Re: i have problem with date format
See if this helps:
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B105766
# 2 Re: i have problem with date format
You can also use the Microsoft Date and Time picker control.
Right click toolbox - components and select the microsoft windows common controls-2 6.0.
# 3 Re: i have problem with date format
Thank you very much i added common controls and now is better.. huh.. thank you thank you..
have a nice days.
# 4 Re: i have problem with date format
and i have another question. i am creating report in visual basic. but i want landscape not portrait. because it is appeatring report width is larger than paper width
how can i fix?
# 5 Re: i have problem with date format
Something like this to set the page to landscape:
printer.Orientation = vbPRORLandscape
# 6 Re: i have problem with date format
Yes Benjamin but where i must write this? i want report page should be landscape. i cant see landscape only portrait.
# 7 Re: i have problem with date format
and i have one field med numeric. and if med=1 it must write "female" if 2 it must show onj the rpeort "male"
# 8 Re: i have problem with date format
Hi,
standard the printer is set to portrait, so you have to copy my line of code before the first line you use to print.
To answer your second question, this is an option:
if med=1 then
printer.print "female"
else
printer.print "male"
end if
# 9 Re: i have problem with date format
my code like this
With rapor_goster
Set .DataSource = rst
.DataMember = rst.DataMember
.Sections("Section4").Controls("lblAddress").Caption = "T.C. ALMATI BYKELİLİĞİ" & vbCrLf & " Konsolosluk Şubesi"
'.Sections("Section5").Controls("lblRecCount").Caption = rst.RecordCount & " Kayıt listelendi."
DoEvents
.Show (1)
End With
rst.Bookmark = mvBookMark
End Sub
# 10 Re: i have problem with date format
now is important i must see on screen print preview landscape format.
# 11 Re: i have problem with date format
:eek:
Ok,
my mistake, I'm not familiar with the method you use. :confused:
I rest my case, perhaps somebody else can help you.
# 12 Re: i have problem with date format
Dear Benjamin pls dont understand wrong. i wrote it but still i am seeing portrait on the screen.
# 13 Re: i have problem with date format
I know, but the help I was supporting was for another method.
I now see you use another approach. => I don't even now what this is With rapor_goster
# 14 Re: i have problem with date format
Rapor_goster the name of rapor.dsr
i created one rapor.dsr and i put inside fields.
