Data input

A

Artemida

I have a problem. If somebody could help me, I'd appreciate it very much. I
am a beginner in this field. I have to know how I can realise data input
through form? I made a form, but I cann't make a new record. Thank you very
much.
 
R

Rick Brandt

Artemida said:
I have a problem. If somebody could help me, I'd appreciate it very much. I
am a beginner in this field. I have to know how I can realise data input
through form? I made a form, but I cann't make a new record. Thank you very
much.
Click to expand...

Databases store data in tables. Did you build a table and bind your form to
that table?
 
S

scubadiver

If you have created a basic form, there is a set of navigation buttons in the
bottom left hand corner. click on the far-right button that looks like ">*"
or click on the "insert" menu and choose the first option.
 
A

Artemida

I have created a basic form, but the buttons you are talking about are not
active. The same thing is if I choose an Insert. I don't know why is this
happening?
 
A

Artemida

HELP!!!!!

scubadiver said:
If you have created a basic form, there is a set of navigation buttons in the
bottom left hand corner. click on the far-right button that looks like ">*"
or click on the "insert" menu and choose the first option.
Click to expand...
 
S

scubadiver

That is wierd.

Do you know how to get to the properties for the form? Click on the black
square in the top left corner in design view.
 
A

Artemida

I've checked out, and this option was already on "yes". I can see this
simbols for new record and for delete record, but I cann't click on them.
They are not active. If I take Insert there is also possibility to choose New
record. But also it is not active. I really don't know what to do. I've lost
1 day looking for resolving this issue. How is it possible?
 
S

Steve Schapel

Artemida,

Can you also check that the Allow Additions property of the form is set
to Yes.
 
S

Steve Schapel

Artemida,

Please welcome this as a great learning experience for you. You have
told us you are a beginner, and as such there will of course be things
you will need help with. Please persevere - it will be worth it, and
much preferable to the alternative (paying a professional Access
developer/consultant to do it for you).
 
A

Artemida

It is : SELECT [Cliente II].[codice cliente], [Cliente II].[nome di cliente],
[Cliente I].adresse, Luogo.[codice luogo], Luogo.[nome di luogo],
Cantone.[codice cantone], Cantone.[nome di cantone], Clasificazione.[codice
clasificazione], Clasificazione.[nome di clase], Marca.[codice marca],
Marca.[nome di marca], Stato.[codice stato], Stato.[nome di stato] FROM Marca
INNER JOIN (Luogo INNER JOIN ([Cliente II] INNER JOIN (Stato INNER JOIN
(Clasificazione INNER JOIN (Cantone INNER JOIN [Cliente I] ON Cantone.[codice
cantone]=[Cliente I].[codice cantone]) ON Clasificazione.[codice
clasificazione]=[Cliente I].[codice clasificazione]) ON Stato.[codice
stato]=[Cliente I].[codice stato]) ON [Cliente II].[codice cliente]=[Cliente
I].[codice cliente]) ON Luogo.[codice luogo]=[Cliente I].[codice luogo]) ON
Marca.[codice marca]=[Cliente I].[codice marca];
 
R

Rick Brandt

Artemida said:
It is : SELECT [Cliente II].[codice cliente], [Cliente II].[nome di cliente],
[Cliente I].adresse, Luogo.[codice luogo], Luogo.[nome di luogo],
Cantone.[codice cantone], Cantone.[nome di cantone], Clasificazione.[codice
clasificazione], Clasificazione.[nome di clase], Marca.[codice marca],
Marca.[nome di marca], Stato.[codice stato], Stato.[nome di stato] FROM Marca
INNER JOIN (Luogo INNER JOIN ([Cliente II] INNER JOIN (Stato INNER JOIN
(Clasificazione INNER JOIN (Cantone INNER JOIN [Cliente I] ON Cantone.[codice
cantone]=[Cliente I].[codice cantone]) ON Clasificazione.[codice
clasificazione]=[Cliente I].[codice clasificazione]) ON Stato.[codice
stato]=[Cliente I].[codice stato]) ON [Cliente II].[codice cliente]=[Cliente
I].[codice cliente]) ON Luogo.[codice luogo]=[Cliente I].[codice luogo]) ON
Marca.[codice marca]=[Cliente I].[codice marca];
Click to expand...

Well your form is not bound to your table then. It is bound to a SQL Statement
that includes a whole bunch of tables.

Multi-table queries are often not editable and the more tables you include the
less likely that it can be made editable. There is virtually no chance at all
of making your query editable because of all of the joins you have in it.

Multi-table queries are well suited to analysis and reporting. They are not
well suited for editing data. I suggest you start with a simple form bound ONLY
to your main table. That will allow you to edit the data. Then you can work on
adding various lookup mechanisms that allow you to see data from some of those
other tables.
 
T

tina

you have a number of tables in the form's RecordSource that are linked by
INNER JOIN. it's likely that there is no problem with the *form* itself, but
rather that the return recordset from the SQL statement is not updateable
because of one or more of the INNER JOINS.

to test that theory, create a new query but don't add any tables to it. in
query design view, click on View | SQL View from the menu bar, and paste the
SQL statement into the SQL pane. then from the menu bar click View |
Datasheet View, and see if you can add a record directly to the query.

hth


Artemida said:
It is : SELECT [Cliente II].[codice cliente], [Cliente II].[nome di cliente],
[Cliente I].adresse, Luogo.[codice luogo], Luogo.[nome di luogo],
Cantone.[codice cantone], Cantone.[nome di cantone], Clasificazione.[codice
clasificazione], Clasificazione.[nome di clase], Marca.[codice marca],
Marca.[nome di marca], Stato.[codice stato], Stato.[nome di stato] FROM Marca
INNER JOIN (Luogo INNER JOIN ([Cliente II] INNER JOIN (Stato INNER JOIN
(Clasificazione INNER JOIN (Cantone INNER JOIN [Cliente I] ON Cantone.[codice
cantone]=[Cliente I].[codice cantone]) ON Clasificazione.[codice
clasificazione]=[Cliente I].[codice clasificazione]) ON Stato.[codice
stato]=[Cliente I].[codice stato]) ON [Cliente II].[codice cliente]=[Cliente
I].[codice cliente]) ON Luogo.[codice luogo]=[Cliente I].[codice luogo]) ON
Marca.[codice marca]=[Cliente I].[codice marca];

Rick Brandt said:
On the property sheet of the form while in design view. On the { data } tab.
Click to expand...
Click to expand...
 
A

Artemida

Thank you very much. I'll try it now.

Rick Brandt said:
Artemida said:
It is : SELECT [Cliente II].[codice cliente], [Cliente II].[nome di cliente],
[Cliente I].adresse, Luogo.[codice luogo], Luogo.[nome di luogo],
Cantone.[codice cantone], Cantone.[nome di cantone], Clasificazione.[codice
clasificazione], Clasificazione.[nome di clase], Marca.[codice marca],
Marca.[nome di marca], Stato.[codice stato], Stato.[nome di stato] FROM Marca
INNER JOIN (Luogo INNER JOIN ([Cliente II] INNER JOIN (Stato INNER JOIN
(Clasificazione INNER JOIN (Cantone INNER JOIN [Cliente I] ON Cantone.[codice
cantone]=[Cliente I].[codice cantone]) ON Clasificazione.[codice
clasificazione]=[Cliente I].[codice clasificazione]) ON Stato.[codice
stato]=[Cliente I].[codice stato]) ON [Cliente II].[codice cliente]=[Cliente
I].[codice cliente]) ON Luogo.[codice luogo]=[Cliente I].[codice luogo]) ON
Marca.[codice marca]=[Cliente I].[codice marca];
Click to expand...

Well your form is not bound to your table then. It is bound to a SQL Statement
that includes a whole bunch of tables.

Multi-table queries are often not editable and the more tables you include the
less likely that it can be made editable. There is virtually no chance at all
of making your query editable because of all of the joins you have in it.

Multi-table queries are well suited to analysis and reporting. They are not
well suited for editing data. I suggest you start with a simple form bound ONLY
to your main table. That will allow you to edit the data. Then you can work on
adding various lookup mechanisms that allow you to see data from some of those
other tables.
Click to expand...
 
Top