473,322 Members | 1,345 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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 2893
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******@thistime.com> wrote in message
news:3a*****************@twister.austin.rr.com...
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
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...
4
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...
0
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...
1
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...
6
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. ...
8
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...
7
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
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...
1
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...
3
by: Saucer Man | last post by:
....in Visual Basic.net 2008 Express? -- Thanks!
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.