form limiting sql insert to 120 bytes ???

[KenHigg]

Hum... I'm sure this is a no brainer - I just can't figure it out. Maybe Pat or Mile or Rich will take a look... Looks like some kind of text box limit.(?)

Sorry - We tried...

ken

 

[KenHigg]

One last question- You're not doing something like:

forms.mycontrol.text to reference the text in your text box are you?

ken

 

[skiefer]

nope - nothing like that. just doing the append with the syntax we discussed.

you're right, this has got to be a silly no-brainer!! thanks for all the help.

 

[skiefer]

Anyone got any ideas??

Anyone there?? Any ideas would be helpful. I've created a new db from scratch and am still getting the exact same problem.

HELP!!!!!

 

[KenHigg]

Can you put together enough of the offending db and make it small enough to post?

ken

 

[skiefer]

ok, here is my database stripped down to the bare minimum. You will see two buttons - one that uses as sql insert command and one that uses an append query. They both produce the same result.

 

[KenHigg]

Strange it didn't work, then it worked...

I don't understand why you would want to past it into a field when you can just bind the form to the table, but

Try it now...

ken

 

[skiefer]

Ken,

did you change anything? still doesn't work on this end... did it work for you?

The only reason I'm trying to pass the field in is because I want the user to be able to press a button to save. It never seems right to me to have a record save without the user actually asking it to.

I guess maybe I will have to change my entire database plan if this is not going to work.

I can't believe that no one's ever experienced this before .... i'm not doing anything unique here.

Steph

 

[KenHigg]

Well, It didn't work when I first got it. Then I monkeyed around for few minutes and it appeared as though it had started working. The kicker is that it won't let you add but a certain number of char's to the text box - much less do a sql insert...

Seems if you bind the form to the table, as in your example, then do an insert, that you would have duplicate records...

BTW - there is a vba command to save a record.

ken

 

[skiefer]

Please Help!!!

Isn't there anyone out there who can tell me why my form won't let me add more than 128 characters to my table field??? I'm about to scrap access altogether and find another database that will let me do what I want.

I've spent hours getting this whole db to do exactly what I need and it works 100% until I try to add more than 128 characters to the instructions field. I get the same result with an sql insert and an append query.

Please someone look at this db and tell me what i'm doing wrong.

 

[skiefer]

new database

new database w/ minor change.