Long data types...?

[Melissa101]

My main data source connection has an auto number field (the primary key)
which is a long interger. I'm assuming that is why "Submit" status is not
allowed since it said so

....long data types are not supported? Is there anything else I can do?..HELP

 

[Adam Harding]

Melissa101

Long integer confusingly is not a long data type so that is not your problem.

What other types of fields do you have?

 

[Melissa101]

Thank you so much for getting back to me
The only other data types are:
AutoNumber
Text
Date/Time
Number
Memo
Date/Time
.................could it be the memo type?

 

[Adam Harding]

memo field is your problem

change that to text and you are fine.

Make sure you set the character limit to the max at 255 characters if this
text field is designed to get many words.

 

[JRERAC]

I am using an InfoPath form to retreive incident information from others and
there is a text field present where the users can enter notes about an event.
Once submitted, the details of each InfoPath form submittal are stored in an
Access database. Is there a way to get a Notes field to store more than 255
characters? Is there a different control type that would allow me to
store/send more than 255 characters of data to my Access database?

Thanks, Jason

 

[Greg Collins [InfoPath MVP]]

Long data types are not natively supported in InfoPath. To use them you will need to write code to directly access your database or better is to use a Web service to connect to your database.

--
Greg Collins [InfoPath MVP]
Visit http://www.BrainTrove.com
Visit http://www.InfoPathDev.com


I am using an InfoPath form to retreive incident information from others and
there is a text field present where the users can enter notes about an event.
Once submitted, the details of each InfoPath form submittal are stored in an
Access database. Is there a way to get a Notes field to store more than 255
characters? Is there a different control type that would allow me to
store/send more than 255 characters of data to my Access database?

Thanks, Jason

 

[JRERAC]

When you say web service, would something like a SharePoint suffice or fit
the need? Currently, I connect directly to MS Access database using the Data
Connections Wizard within the form. Sorry, I am not a coder, more of a
functional user. Can you explain an example of a InfoPath/Web Service/Access
Database architecture and what is required to make it work well and play nice
for storing more than 255 characters? How would use of a web service alone
solve the problem? Would my char length options change for the existing Text
field?

Long data types are not natively supported in InfoPath. To use them you will need to write code to directly access your database or better is to use a Web service to connect to your database.

--
Greg Collins [InfoPath MVP]
Visit http://www.BrainTrove.com
Visit http://www.InfoPathDev.com


I am using an InfoPath form to retreive incident information from others and
there is a text field present where the users can enter notes about an event.
Once submitted, the details of each InfoPath form submittal are stored in an
Access database. Is there a way to get a Notes field to store more than 255
characters? Is there a different control type that would allow me to
store/send more than 255 characters of data to my Access database?

Thanks, Jason

memo field is your problem

change that to text and you are fine.

Make sure you set the character limit to the max at 255 characters if this
text field is designed to get many words.

 

[Greg Collins [InfoPath MVP]]

I don't know that SharePoint would work because you are using a custom Access database and SharePoint wouldn't know about its structure to be able to deal with it. You would need to write your own Web service to do this.

How do you go about writing a Web service to get/send data between Access and InfoPath? I'll have to leave that for someone else who knows more about how to do that.

Good luck!

--
Greg Collins [InfoPath MVP]
Visit http://www.BrainTrove.com
Visit http://www.InfoPathDev.com


When you say web service, would something like a SharePoint suffice or fit
the need? Currently, I connect directly to MS Access database using the Data
Connections Wizard within the form. Sorry, I am not a coder, more of a
functional user. Can you explain an example of a InfoPath/Web Service/Access
Database architecture and what is required to make it work well and play nice
for storing more than 255 characters? How would use of a web service alone
solve the problem? Would my char length options change for the existing Text
field?

Long data types are not natively supported in InfoPath. To use them you will need to write code to directly access your database or better is to use a Web service to connect to your database.

--
Greg Collins [InfoPath MVP]
Visit http://www.BrainTrove.com
Visit http://www.InfoPathDev.com


I am using an InfoPath form to retreive incident information from others and
there is a text field present where the users can enter notes about an event.
Once submitted, the details of each InfoPath form submittal are stored in an
Access database. Is there a way to get a Notes field to store more than 255
characters? Is there a different control type that would allow me to
store/send more than 255 characters of data to my Access database?

Thanks, Jason

memo field is your problem

change that to text and you are fine.

Make sure you set the character limit to the max at 255 characters if this
text field is designed to get many words.

 

[KLaw]

Did you ever find a solution or figure out what writing a Web service was all
about? I also am a non-coder and have an InfoPath Incident Report connected
to an Access Database. I have users type any comments that are longer than
250 characters in a word document and have a file attachement button on the
form for them to use. Not exactly perfect, but it's the best I came up with!

 

[Robert]

Here is a sample of using a web service with an InfoPath form...
http://www.perfectxml.com/InfoPath.asp

A word of caution though, if you have no programming background you may have
to do some research and a little learning before it all starts making sense.

Here is a web services tutorial...
http://www.w3schools.com/webservices/default.asp