[dhsmithii]

Hi, Shot in the dark but wondering if anyone could help. At work I have self-made technical/educational issue tracking system.

Users fill in some information using two InfoPath Forms I set up. They then submit the data to an Access database and generates an email to my account.

Unfortunately, I need fields larger that 255 characters (some employess need to write notes within the form longer than the limitations). Currently, I have set up multiple text fields to mimic the appearance of the memo type data (i.e. 4 separate text boxes that allow up to 255 character being submitted to 4 table fields in access).

Any ideas how I can change the infrastructure to allow me to submit larger field types like Memo? Do you have any suggestions on any other "free" programs to utilize to get the same general results?

Thanks!!!

[OBP]

Is this Web Based?
If so have you considered using an Access Page (html form) instead of infopath?
If it is Access 2007 then they use Sharepoint, but I don't know anything about it.

[dhsmithii]

Thanks for the reply! It's not web-based (at least not yet). We (myself and a MIS administrator) are beta testing with Joomla as a department KB. I want to use my forms on that, but not sure if they need to be created with a different development tool.

I'm not familiar with the access page. Do you have any "how to" links for that?

Thanks a bunch!!

[OBP]

The Access Page is a special html form that is available in Access 2000-2003. I am pretty sure that you can create a normal form and then save it as an Access Page. Look it up on the Access Help.

If you are using an Intranet Server you can just put the Database on it and access it directly.