SQL Data - Retrieval for display only, please help

[VBA-Beginner]

PLEASE HELP..

OK I find all kinds of info on how to update SQL tables but all I want to do
is pull the data from a SQL view and display it on a form so that users can
use it to submit requests.

I have created a form with a combination of fields that only a few of which
I would like to have display selections from a SQL view.
Another field I would like to have auto fill from outlook which is where
this form will be sent from.

Can someone tell me how to link the SQL field so that is displays or
captures all records in the view. the user will then place a check in a
check box next to the selections.

ALSO how to et the sent by field to automatically default to the USERID ???

I greatly appreciate any assistance, I am so new to InfoPath....

 

[Scott L. Heim [MSFT]]

Hi,

It sounds as if you are simply trying to get to a "read-only" type of
InfoPath solution - is my understanding correct?

If so, the following should give you what you need:

- Disable the ability to add/delete any sections, tables, etc. (Right-click
on each, select Properties and uncheck the option: Allow users to insert
and delete the sections.)

- Remove the ability to submit the form back to SQL Server (From the Tools
menu, choose Submitting Forms and then select the option: "Do not enable
submit")

This will still allow your users to query for records but they will not be
able to send any changes back to SQL.

I hope this helps!

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[VBA-Beginner]

Thank you, just getting ready to leave, I will try that Monday.

The SQL Administrator here has asked me to find out if InfoPath can read
from or work with a stored procedure. Do you have any information on how
this is done??

Thanks again, very much for your time.

 

[Scott L. Heim [MSFT]]

Hi,

InfoPath can work with a stored procedure but you will need to write custom
script. Here is a Knowledge Base article that may help:

827007: How to work with stored procedures by using script in an Office
InfoPath 2003 form
http://support.microsoft.com/default.aspx?scid=kb;EN-US;827007

Have a great weekend!

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[VBA-Beginner]

Thanks Much...