Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / November 2004

Tip: Looking for answers? Try searching our database.

SQL Datasource read/write

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nick Monsour - 29 Nov 2004 21:43 GMT
HELP PELASE!

Is it possible to read and write from/to the SQL database data source
that a form is based on?
The issue is if I have information in a database that I wish to display
I would use a query field and that would populate my existing data
files (read only text boxes). Then I wish to add information to the
database tables and I don't want to display the information that the
query would have returned. I want to have blank text boxes that the
form user could enter new information into. How would I keep these
fields from populating?

Thank you,
Nick
em - 30 Nov 2004 09:29 GMT
hi,
I'm not sure to understand your question - but if you want to add "new
elements" to be send to your database - just use the standard context menu to
add new, blank elements to your form which can be filled by the user.
regards
em

> HELP PELASE!
>
[quoted text clipped - 10 lines]
> Thank you,
> Nick
Nick Monsour - 30 Nov 2004 13:54 GMT
What I mean is I want to display information that exists in a table
based on a query field (lets say employee information) and then I want
to display the same fields but blank for data entry. Here is the
scenario: an employee has access to computer systems so there is a User
employee information table joined to a user_system table (system
information i.e. system name, date added, logon id, password) and the
system names are populated by a look up table to avoid a large and
static number of columns in a single table. I want to modify a users
system access information so I query on the user and have a repeating
table shows what accesses they currently have and then below I want to
have a repeating table with blank drop down lists and user_sytem text
boxes that will still accept information but that did not populate when
the query above is run.
What is happening is when the query is run all fields are populating
with the employee information. So how do I keep the fields I want bound
to the same tables but blank?

Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.