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 / April 2007

Tip: Looking for answers? Try searching our database.

How to UPDATE queried results?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Reid - 23 Apr 2007 16:41 GMT
Greetings:

I have a simple form that queries on single field(Asset Tag) and
returns the details of the row for that Asset Tag.

I would like to be able to change one of the fields (RAM, harddrive,
etc.) and then update the database.

The query part works great, but I cannot figure out how to get the
update part working.

Is there an easy way to do this?

The database is SQL Server 2000.
The client is running InfoPath 2007.

Thanks,
Reid
Art - 23 Apr 2007 20:22 GMT
Thetable must have a primary key for updates to be allowed

Do you have a primary key set?

> Greetings:
>
[quoted text clipped - 14 lines]
> Thanks,
> Reid
 
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.