Solved

Form To Just Add Records Only

Posted on 2007-11-28
2
204 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

615 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