473,386 Members | 1,763 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

why show this error

Expand|Select|Wrap|Line Numbers
  1. Do While Not sample.Recordset.EOF
  2.     mk_datechn.Mask = "##/##/####"
  3.     mk_datechn.Mask = CDate(sample.Recordset!cd_flight_Date)
  4.  
  5.         awb_update.RecordSource = "select  sum(awb_master.gross_wt)frtgrswt, sum(awb_master.total_amt)as frttotamt, sum(total_handlingchg) as handling  from awb_master where flight_name='" + Trim(sample.Recordset!cd_flight_name) + "' and stncode='" + Trim(memm.stncodee) + "' and nature_and_quality_of_good='courier' and flight_date ='" + Trim(Str(Year(mk_datechn.Text))) + "/" + Trim(Str(Month(mk_datechn.Text))) + "/" + Trim(Str(Day(mk_datechn.Text))) + "'"
  6.         awb_update.Refresh
this code and getting error type mistake
Trim(Str(Year(mk_datechn.Text))) in this masked_bok here show only ='0_/10/2010' actually i am putting in the date filed is 09/10/2010 and when ever is 9 date 9 month it show this error type mistake
Oct 22 '10 #1
0 776

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Nick | last post by:
How to change the pic to a "show error" image when loading images failed - for example, no image file exists? I tried to add the following statement in the onload event function: if...
2
by: John Sutter | last post by:
I have a webpage which has a few asp:textbox's and an asp:button. I also have a few RequiredFieldValidators for these text boxes. When I click on the button while the textboxes are empty, I don't...
5
by: pmud | last post by:
Hi, I am using a compare validator in asp.net application(c# code). This is used for comparing a value enterd by the user against the primary key in the SQL database. IF the VALUE ENTERED BY THE...
8
by: pmud | last post by:
Hi, I am using a compare validator in asp.net application(c# code). This Custom validator is used for comparing a value enterd by the user against the primary key in the SQL database. IF the...
2
by: ad | last post by:
I have a customErrors section in Web.config. All error except error 403 and 404, will be redirect to GenericErrorPage.aspx. How can I show the e.Message or some explicit statement according...
0
by: John A Grandy | last post by:
visual studio .net 2003 somehow i have changed my vs.net vb.net code-editor configuration so that squiggly underlined errors no longer show the error message when the cursor is placed on them...
2
by: comp.lang.php | last post by:
I am trying to debug an error found somewhere within my suite of scripts. Nothing shows up when there's an error, it just simply dies. I tried using error_reporting(E_ALL); to no avail. I tried...
2
by: Vicente García | last post by:
Hello all, First of all sorry for my bad English... I am making up an application that can't show any error window (e.g. Can't write to memory address) if any...therefore I wish destroy or manage...
0
by: make me rain | last post by:
hai, i am very new ti VB6. how can i show i.e log All the err.number , err.description, error time on a simple VB6 application (it is NOT a data base app) like creating text boxes for each error...
5
by: Enij | last post by:
Hi All, If I type this code (VB.net 2003): Dim myDialog As frmTestDialog myDialog = New frmTestDialog myDialog.Show()
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.