473,795 Members | 3,151 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Data Form Wizard

I am developing my First "Real" app and i am running in to the following
problem.
I use the data form wizard to create a form, so i do not have to manually do
all the binding.
But the only thing i want the user to be able to do on this form is Add a
record.

I tried moving the fill dataset in to the form load to get rid of the "load"
button and that worked but it also loads data into my textboxes.
Ok i could code around that ....
But it also generates the insert , update and delete commands ... and i am
getting lost .. when i click "add" it increments the navigation counter yet
i remain on the same record and am unable to get to the new record and no
record is actually inserted. in the database because it is satying in my
dataset!!!!.... HELP!!!
am i supposed to click add , then update .. or enter my vales and then click
add then update....
because when i go back and look in the database sometimes i get a blank
record but usually it just updates whichever record is the last one ...
being that i cannot navigate to the newly created record in my dataset to
edit it and send it back to the database.

My idea was to have a form for users to enter data and seperate forms for
the update and delete to prevent certain users from being able to add
records.

Thanks,
Jeff Brown
aka BrntPhish
Nov 20 '05 #1
1 2942
OK i decided to hand code ALL (10 - 15 Tables , 15 - 20 fields per) of my
bindings and queries, probably more efficient that way.i didnt particlaurly
want to use the wizard but i thought it might save a few hundred keystokes

"Jeff Brown" <no******@thist ime.com> wrote in message
news:3a******** *********@twist er.austin.rr.co m...
I am developing my First "Real" app and i am running in to the following
problem.
I use the data form wizard to create a form, so i do not have to manually do all the binding.
But the only thing i want the user to be able to do on this form is Add a
record.

I tried moving the fill dataset in to the form load to get rid of the "load" button and that worked but it also loads data into my textboxes.
Ok i could code around that ....
But it also generates the insert , update and delete commands ... and i am
getting lost .. when i click "add" it increments the navigation counter yet i remain on the same record and am unable to get to the new record and no
record is actually inserted. in the database because it is satying in my
dataset!!!!.... HELP!!!
am i supposed to click add , then update .. or enter my vales and then click add then update....
because when i go back and look in the database sometimes i get a blank
record but usually it just updates whichever record is the last one ...
being that i cannot navigate to the newly created record in my dataset to
edit it and send it back to the database.

My idea was to have a form for users to enter data and seperate forms for
the update and delete to prevent certain users from being able to add
records.

Thanks,
Jeff Brown
aka BrntPhish

Nov 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
2125
by: David C. Allen | last post by:
I am following thru the examples in the book I am studying for my MCSD. This is the web applications book. One example is to use the data form wizard to create a simple data form on the northwind customers table.When I try to run the code after the wizard has generated the form I get several compile errors like this: D:\Projects\DOTNET\MCSD\70-305\305C05\dsCustOrders.vb(86): Reference required to assembly 'System.Xml' containing the...
4
2712
by: Stuart E. Wugalter | last post by:
Hi folks! I have a user who wants to see all the data in a memo field when she clicks on the cell in the table. I suspect that I will have to make a form first (which I prefer her to use). Has anyone done this before? TIA Stuart E. Wugalter Zilkha Neurogentic Institute University of Southern California wugalter@usc.edu
0
358
by: AZ Jack | last post by:
I have been using a form generated with the Data Form Wizard as a model to generate a standard update form. The wizard uses BindingContext to tie a form to a Database Table. I am using the Authors table on the Pubs database on the SQL Server. In the wizard, I use "single record" with "individual controls" and select all buttons. My problem is that when the form has a checkbox control, the ADD button does not work correctly. Without...
1
1162
by: AndrwChau | last post by:
I just want to know how many user are use the Data Form wizard to generate the input form. Is most of programmer use the wizard to generate the input form or they are create one by themself. Is there any third party form wizard on the market? -- Andrew
6
6001
by: Bob | last post by:
I've located instruction as to how to add the Data Form Wizard into a VB.NET 2005 project at this location. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/html/vburfdataformwizard.asp However no matter how hard I look I can't locate it. Any ideas what is wrong or is the documentation in error and this feature has been removed from VS.NET 2005
8
24530
by: gracealic | last post by:
I am new to access can someone tell me how do we send the data entered from an inquiry form to a table. say i have a form which has fields client name client address client phone client email
7
1342
by: Darhl Thomason | last post by:
Does VB2005 have a wizard for creating a form based on an Access db? I know that VB6 had this, but I can't seem to find anything similar in VB2005. Thanks! Darhl
3
1994
by: Peter Newman | last post by:
i have used the data wizard form to create a data form with a datagrid on it. What i want to do is add a new coloum and put a Button in it. can anyboody showm me how to do this .... I will need the onclick event for the button as well eg cell 1 cell2 cell3 text text Button
1
306
by: cypher_key | last post by:
I want to write a simple application for my own use. I've already have the data populated in a database and I have a data source setup. I can use the wizards to generate a master detail data form (I believe that's what it's called) and I get a form with input controls for each field in the table. My question is that 2 of the fields in the table are numeric IDs which are foreign keys to other tables. For example, I have a customerID and...
3
6166
by: Saucer Man | last post by:
....in Visual Basic.net 2008 Express? -- Thanks!
0
9672
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9519
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
7540
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6780
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5437
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5563
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4113
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3727
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2920
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.