Forwarding currency to next record

  • Thread starter Thread starter Balmora via AccessMonster.com
  • Start date Start date
B

Balmora via AccessMonster.com

Ok thanks for all your help in advance, i have found with some help that if
you right

Private Sub datatotal_AfterUpdate()
With Me.datatotal
.DefaultValue = .Value
End With
End Sub

in vb, it will send the number to the next record in datatotal that is good
and i have also found that if you right

Private Sub datatotal_AfterUpdate()
If Not IsNull(Me.datatotal) Then
Me.data1.DefaultValue = Me.datatotal.Value
End If
End Sub

in vb, it will send the number to the next reccord but to a difrent field in
this case datatotal would be send to data1 in the next record that is cool
but the problem is that the moment i use a value with decimals like 21.50 it
wont transfer :( in the field i will find #Name? , what can i do with all the
rest of my code all is fine
 
Check the data type of the field bound to data1
My guess is it is not a single, double, or currency.
 
Klatuu said:
Check the data type of the field bound to data1
My guess is it is not a single, double, or currency.
Ok thanks for all your help in advance, i have found with some help that if
you right
Click to expand...
[quoted text clipped - 19 lines]
wont transfer :( in the field i will find #Name? , what can i do with all the
rest of my code all is fine
Click to expand...
Click to expand...


I checked and the data type for data1 is currency thanks any ways
 
I had no problem doing it either! Corruption of some kind?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
 
Linq said:
I had no problem doing it either! Corruption of some kind?
Click to expand...

Can you tell me what you have done exactly, because a have tryed it in a new
data base and still does not work, i have no clue to what im doing wrog
 
Balmora said:
Can you tell me what you have done exactly, because a have tryed it in a new
data base and still does not work, i have no clue to what im doing wrog
Click to expand...

I just did it again, it works when i use a hole number like 30.00$ and if i
enter a number like 30.50$ i get #Name? y?
 
Balmora said:
Can you tell me what you have done exactly, because a have tryed it in a new
data base and still does not work, i have no clue to what im doing wrog
Click to expand...

I just did it again, it works when i use a hole number like 30.00$ and if i
enter a number like 30.50$ i get #Name? y?
 
Balmora said:
Ok thanks for all your help in advance, i have found with some help that if
you right

Private Sub datatotal_AfterUpdate()
With Me.datatotal
.DefaultValue = .Value
End With
End Sub

in vb, it will send the number to the next record in datatotal that is good
and i have also found that if you right

Private Sub datatotal_AfterUpdate()
If Not IsNull(Me.datatotal) Then
Me.data1.DefaultValue = Me.datatotal.Value
End If
End Sub

in vb, it will send the number to the next reccord but to a difrent field in
this case datatotal would be send to data1 in the next record that is cool
but the problem is that the moment i use a value with decimals like 21.50 it
wont transfer :( in the field i will find #Name? , what can i do with all the
rest of my code all is fine
Click to expand...


Well thank you guys for all your help, i found out what to do i will show you
just so you know and help anyone how has the same problem

Private Sub datatotal_AfterUpdate()
If Not IsNull(Me.datatotal) Then
Me.data1.DefaultValue = """" & Me.datatotal.Value & """"
End If
End Sub

Cool :) hop it can help!
 
Back
Top