If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#10
|
|||
|
|||
Try putting in a
MsgBox Format(Me.txtTransactionDate, "\#mm\/dd\/yyyy\#;;;\N\u\l\l") and see whether it's converting the value correctly. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Jan Il" wrote in message ... Hi Doug :-) Assuming TransactionDate is a Date-type field, you need to enclose the date in # characters (or else use the CDate function) .Fields("TransactionDate") = Format(Me.txtTransactionDate, "\#mm\/dd\/yyyy\#;;;\N\u\l\l") or .Fields("TransactionDate") = CDate(Me.txtTransactionDate) (See http://www.mvps.org/access/datetime/date0005.htm at "The Access Web" for other formats to use if TransactionDate contains time as well as the date) Here is what I have now tried: .Fields("TransactionDate") = Format(Me.txtTransactionDate, "\#mm\/dd\/yyyy hh\:nn\#\N\u\l\l") However, now I am getting an Error: Data type conversion error. The TransactionDate is a date data type, with the date format of mm/dd/yyyy hh:nn" P". It is a Required field. The format I tried is the one I found on the link you provided that is closest to the date format I am using; "\#mm\/dd\/yyyy hh\:nn\:ss\#;;;\N\u\l\l", but, I removed the seconds and whatever the ;;; are, as I did not think they were needed. I've been able to find out some about this error on the web, but, not having much luck in finding a cure. I can't figure out what is generating the error. Jan -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Jan Il" wrote in message ... Hi Andi :-) On Wed, 22 Dec 2004 14:00:54 -0500, "Jan Il" wrote: have you missed that? the error is he your table needs the TransactionDate set to a Value, because addnew adds this field with a Null Value .Fields("TransactionDate") = me.TransactionDate .Update I added the above to the existing code in the Transaction control NotInList event code, in the area where it appears it should go, and I am now getting a type mismatch error: Here is what I added and where in the code: With rst .AddNew .Fields("Transaction") = NewData .Fields("TransactionDate") = Me.txtTransactionDate .Update The txtTransactionDate is the name of the control on the form. It does compile alright, but, when I click OK on the Add box, the error message is fired. Sorry to be so dense, but, obviously I'm not doing it right. Thank you. Jan If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message MW |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Barcodes | TarponZeke | General Discussion | 4 | October 25th, 2004 08:04 PM |
Form to generate a Report code | Pat Coleman | Setting Up & Running Reports | 4 | July 16th, 2004 12:58 PM |
Hide or show Control Button on Form in Access 97 | Pete Sperling | Using Forms | 8 | July 13th, 2004 04:13 PM |
Is it possible to include Begin And End Transaction code in VBA ? | Jean | New Users | 10 | June 29th, 2004 11:31 PM |