Solved

Form To Just Add Records Only

Posted on 2007-11-28
2
191 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

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…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

837 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