adding new records

[short]

I have a form where the users finds the information they want through a combo
box and that information is displayed in unbound tables (up to 9 of them).
Each table is inside of a tab as well.
I am having troubles with adding new records into each form. Currently there
is an add new button on each tab that opens up a new form for that table so
it can be entered. It doesn't have any validation or error warnings, if the
user doesn't enter something right, the whole things crashes. Also if there
are check boxes it was not set up for that to be in the adding form.
I was wondering if it's possible to just add onto the table itself, the
problem is the record selector buttons, the one that adds, with the arrow and
* you can not push in. Is there a button that I can put in that will just
have a new blank record appear? Or what I could do to fix the adding new
records form?

 

[Michael Conroy]

I am not sure where to begin. There are many wierd comments in your post.
First of all, how are you displaying the information with "unbound tables"?
Secondly, what do you mean the table was not setup to handle check boxes on
the add new form? And thirdly, the add new button in the navigation bar is
low lighted.

When you create a form, one of the first things you do is establish the
recordsource. In most cases you will set the recordsource to a table. Now
when you create the text and check boxes they can be bound to that table. On
the properties of the form, make sure the "Allow Edits" and "Allow Additions"
options are set to yes. Since you are not checking for user entry errors this
should be enough to solve your problem.

However, to answer your question, there are two ways to enter information
from an unbound form. If you want those answers, write back. But basically,
you could do an append query which would add the information on the form into
the table, or you could use the recordsetclone option and the command addnew,
to put the record on the form into the table. Both would require writing SQL
code in a module. With the hints I have given you, you can search for those
words if that is within your skill level.

 

[John W. Vinson]

I have a form where the users finds the information they want through a combo
box and that information is displayed in unbound tables (up to 9 of them).
Each table is inside of a tab as well.
I am having troubles with adding new records into each form. Currently there
is an add new button on each tab that opens up a new form for that table so
it can be entered. It doesn't have any validation or error warnings, if the
user doesn't enter something right, the whole things crashes. Also if there
are check boxes it was not set up for that to be in the adding form.
I was wondering if it's possible to just add onto the table itself, the
problem is the record selector buttons, the one that adds, with the arrow and
* you can not push in. Is there a button that I can put in that will just
have a new blank record appear? Or what I could do to fix the adding new
records form?

You're causing your own problem, by using an unbound form. Access handles all
that work for you if you use a standard bound form; if you choose to use
unbound forms, then it is YOUR responsiblity to copy all of the data from the
unbound controls to the table (and vice versa), write VBA code to make your
own custom navigation buttons work, etc.

Could you explain why you can't use the builtin Access features, and want to
reinvent them yourself?

 

[short]

I was assigned to this database that was already started and I'm finding more
and more problems with it as I'm trying to fix and add things to it.
Would my best bet be to create a new form with bound tables to it? I'm just
worried that it won't work then because there are two combo boxes (unbound)
that each have a different purpose, one choose what the person wants, say
they want to look at server and the second picks out what server it is and
then the data goes from there. Can I still do that with bound controls? Also
each item, such as a server can have up to nine tables that have different
information on it, would that work?

 

[John W. Vinson]

I was assigned to this database that was already started and I'm finding more
and more problems with it as I'm trying to fix and add things to it.
Would my best bet be to create a new form with bound tables to it? I'm just
worried that it won't work then because there are two combo boxes (unbound)
that each have a different purpose, one choose what the person wants, say
they want to look at server and the second picks out what server it is and
then the data goes from there. Can I still do that with bound controls? Also
each item, such as a server can have up to nine tables that have different
information on it, would that work?

You can certainly have a bound FORM which contains unbound CONTROLS; combo
boxes used to navigate to selected records should always be unbound, for
example.

For the rest you're assuming that I have more knowledge of your database
structure than you have posted. Of course I don't. For example you're using
the term "server" and I don't know what that means in your business model (a
SQL/Server instance? a waitress? a computer?)

 

[short]

After I posted that I realized that you might not have any idea what I'm
talking about with servers (computer it was). I think I might make this
easier for myself and try to work on a new form with easier options for this
database. (i.e., BOUND forms).
Thank you for the help.