C
Corey-g via AccessMonster.com
Hi All,
I have a form that has a textbox that has a phone number input mask --> !\
(999") "000\-0000;;_
that gets it value automatically set when a user makes a choice in a combo
box. This was working great when it 'was' an unbound textbox - but I had to
make changes to the form...
Side Note: ( I am building an order entry screen and wanted to have the Order
details and the order items to be on the same form, but I couldn't figure out
how to do this - Oracle BE and ADO)
Main Form - has Details
sfrm - had order items
Couldn't get the form to display maore than 1 record...
So, I changed the logic to use 2 Access tables as temp tables, and when the
order is finalized I will then send all data to BE.
I than added in the Links (Child & Master) and set all of my unbound forms to
be bound to the appropriate fields. Now when I enter/pick from the combo box,
I get an error saying that 'The value I entered isn't valid for the field".
When I debug, I see that the value is "1234567890" (test data of course - but
should still fit...)
I noticed that the field has a zero ('0') sitting in it when the form loads,
so I tried to first blank the filed and then assign it - no go. I tried to
convert the string into a number using the 'VAL' function - didn't work
either.
So, I am completely lost as to why this happened since making the change. I
have ensured that the field in the temp Access table is set to number - sorry
- found it set to long int - way to small...
Changed to double and seems okay now...
Anyone have a better idea that this for working around the issue that caused
me to change in the first place?
Thanks,
Corey
I have a form that has a textbox that has a phone number input mask --> !\
(999") "000\-0000;;_
that gets it value automatically set when a user makes a choice in a combo
box. This was working great when it 'was' an unbound textbox - but I had to
make changes to the form...
Side Note: ( I am building an order entry screen and wanted to have the Order
details and the order items to be on the same form, but I couldn't figure out
how to do this - Oracle BE and ADO)
Main Form - has Details
sfrm - had order items
Couldn't get the form to display maore than 1 record...
So, I changed the logic to use 2 Access tables as temp tables, and when the
order is finalized I will then send all data to BE.
I than added in the Links (Child & Master) and set all of my unbound forms to
be bound to the appropriate fields. Now when I enter/pick from the combo box,
I get an error saying that 'The value I entered isn't valid for the field".
When I debug, I see that the value is "1234567890" (test data of course - but
should still fit...)
I noticed that the field has a zero ('0') sitting in it when the form loads,
so I tried to first blank the filed and then assign it - no go. I tried to
convert the string into a number using the 'VAL' function - didn't work
either.
So, I am completely lost as to why this happened since making the change. I
have ensured that the field in the temp Access table is set to number - sorry
- found it set to long int - way to small...
Changed to double and seems okay now...
Anyone have a better idea that this for working around the issue that caused
me to change in the first place?
Thanks,
Corey