Solved

Form To Just Add Records Only

Posted on 2007-11-28
2
174 Views
Last Modified: 2010-04-23
I have a form that has a dataset for a single table in my database with many fields in it.  What is the easiest way to open the form and have all of the fields in the table ready to accept a new entry and not display any current records.  I am trying to do this without a datagrid.
0
Comment
Question by:H-SC
2 Comments
 
LVL 3

Accepted Solution

by:
bnaveke earned 500 total points
ID: 20369292
In your toolbox look under common controls.  You can set the properties of these controls to dataset fields.
or
put these controls on a form and let the person populate them with the information.  Have them click a save button and update the data using sql commands.
0
 
LVL 1

Author Comment

by:H-SC
ID: 20382242
bnaveke,

a simple insert or update sql command is what I have been using, but wanted to make sure that there were no other auto/wizard options to set the form to only accept new records.  I have been used to ms access and the whole idea of making a form data entry only and just drag all of my fields onto the form via a linked table.  Your response confirms what I thought might be the case for the visual studio side of things as it relates to the comit data process through forms.

thanks again
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now