Trying to add new Transaction code

On Tue, 4 Jan 2005 11:14:19 -0500, "Jan Il"
wrote:


I'm using a sample test copy, which has limited files for test purposes, so
it's only 166 KB zipped.

then send it to my adress, but don't forget the magic word, else the
message gets deleted without reaching me.

---
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW

then send it to my adress, but don't forget the magic word, else the
message gets deleted without reaching me.

'k...on it's way...but, without the quotes. Right?

Jan


---
If you expect an answer to a personal mail, add the word "manfred" to the
first 10 lines in the message
MW

On Tue, 4 Jan 2005 13:07:49 -0500, "Jan Il"
wrote:

then send it to my adress, but don't forget the magic word, else the
message gets deleted without reaching me.

'k...on it's way...but, without the quotes. Right?

one time would have been enough, with or without quotes in the middle
of a single word, this all doesnt matter, luckely the spammers didn't
use this german name (only one I got delivered till now)

mm.dd.yyyy hh:nn" P"

how can you use this in a table field format? Without seeing it I
would have never thought about this.

You should store it as a normal date and use this format only on
forms, to show this.

Are you using Access97? because it is cluttered with DoCmd.DoMenuItem

look for Manfred in the sourceCode, I changed a few things when I
walked into errors and I added to every form to lines on top:
Option Compare Database
Option Explicit
and found a few typos as expected.

The db will be on the way right now.




---
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW

Hi Andi :-)

Are you using Access97? because it is cluttered with DoCmd.DoMenuItem

No.....I'm using Access 2002 XP

look for Manfred in the sourceCode, I changed a few things when I
walked into errors and I added to every form to lines on top:
Option Compare Database
Option Explicit
and found a few typos as expected.

The db will be on the way right now.

I have received the zip file. However......I do not find any Manfred at all
in the db. Nor, do I find any changes that you mention.

Thank you for your time and help. I appreciate it.

Jan







---
If you expect an answer to a personal mail, add the word "manfred" to the
first 10 lines in the message
MW

On Tue, 4 Jan 2005 19:30:05 -0500, "Jan Il"
wrote:

Hi Andi :-)

Are you using Access97? because it is cluttered with DoCmd.DoMenuItem

No.....I'm using Access 2002 XP

Then you should change it

I have received the zip file. However......I do not find any Manfred at all
in the db. Nor, do I find any changes that you mention.


go to the vba press ctlr-F ; change to whole project and type in my
name, you will find it at least 10 times.



---
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW

Hi Andi :-)


I have received the zip file. However......I do not find any Manfred at
all
in the db. Nor, do I find any changes that you mention.


go to the vba press ctlr-F ; change to whole project and type in my
name, you will find it at least 10 times.

I have now found the name items, and 2 log tables I assume you created.

I am still getting the error message Error: Data type conversion error on
with the frmCkEntry form when trying to enter a new record in the
Transaction field.

I am now getting the error message "Error: The field
'MYCreditCardRegister.TransactionDate' cannot contain a Null value because
the required property for the field is set to True. Enter a value in this
field" for the frmCreditCardEntry form when trying to enter a new record. I
also get "Error: 'MYSavingsRec.TransactionDate' cannot contain a Null value
because the required property for the field is set to True. Enter a value in
this field." When I try to enter a new record in the Transaction field on
this form.

Thank you.

Jan

On Wed, 5 Jan 2005 11:23:41 -0500, "Jan Il"
wrote:

I am still getting the error message Error: Data type conversion error on
with the frmCkEntry form when trying to enter a new record in the
Transaction field.
got to the debugger:

go to:
Private Sub cmbTransaction_NotInList(NewData As String, Response As
Integer)

on this line press F9, this sets a break-point

add something new to your combobox

with F8 you step through your code

and then see what your code is doing:
it is calling himself

due to the maximizing you don't see how much forms are open.

do this with all your problems to see where your error is, but first
comment the On error goto ... out that you know which line

---
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW

I am still getting the error message Error: Data type conversion error on
with the frmCkEntry form when trying to enter a new record in the
Transaction field.
got to the debugger:

go to:
Private Sub cmbTransaction_NotInList(NewData As String, Response As
Integer)

on this line press F9, this sets a break-point

add something new to your combobox

with F8 you step through your code

and then see what your code is doing:
it is calling himself

due to the maximizing you don't see how much forms are open.

do this with all your problems to see where your error is, but first
comment the On error goto ... out that you know which line

In the frmCkEntry form, doing as you suggested, after creating the break
point, and adding a new name into the Transaction field and tabbing to the
next field, I get the ...add it? message, clicking ok opens the debugger to
the code, and when I press F8, it settles on the line here and fires the
error message again. Set rst = CurrentDb.OpenRecordset("MyCheckRegister").
continuing with the F8, it gets to here .Fields("TransactionDate") =
Format(Me.txtTransactionDate, "mm\.dd\.yyyy\ hh\:nn\ P") and give a RunTime
error of 3421, Data type conversion error. When I click End, a message box
comes up that says 'The text you entered is not an item in the list. Select
an item from the list, or enter text that matches one of the items listed.'

It won't debug any further.

Set rst = CurrentDb.OpenRecordset("MySavingsRec") - same error

Next is here in the same form: Update, and the error is: 'The text you
entered is not an item in the list. Select an item from the list, or enter
text that matches one of the items listed.' I can go no further.

and he Set rst = CurrentDb.OpenRecordset("MyCreditCardRegister") -
triggers the add it message. Upon click I get the message of a RunTime
error 3314.

Next is he Update - and the error is: 'The text you entered is not an
item in the list. Select an item from the list, or enter text that matches
one of the items listed.' I can go no further here either.

Jan

On Wed, 5 Jan 2005 16:32:05 -0500, "Jan Il"
wrote:

look at your mail, I changed this sub totally.

---
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW

Hi Andi :-)

look at your mail, I changed this sub totally.

Yes...I have it now. The form is working correctly now. Very interesting.

Thank you very much for all your time and help, I truly appreciate it. :-)

Jan