Storing a record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Golfinray - 01 Apr 2008 19:41 GMT

I want users to be able to click a command button on a form and that takes
them to another form (I got that part written) where they can add a record to
the second form. That record is then stored in the underlying table of the
first form. Thanks so much!!!

Reply to this Message

Klatuu - 01 Apr 2008 21:26 GMT

Sorry, Golfinray. Is there a question in there?
What part are you having trouble with?

Signature

Dave Hargis, Microsoft Access MVP

> I want users to be able to click a command button on a form and that takes
> them to another form (I got that part written) where they can add a record to
> the second form. That record is then stored in the underlying table of the
> first form. Thanks so much!!!

Reply to this Message

Golfinray - 01 Apr 2008 21:36 GMT

Here is my problem. My query is not editable because the tables the query
runs on are ODBC linked tables to an sql server. I even tried copying and
pasting them as local tables but it still won't allow my query to be
editable. (there is no arrow and asterisk at the bottom, only a forward arrow
and back arrow) Since my query is not editable, my form isn't either. My
users need to be able to add new records to my form and store them in a
table. What is the best alternative? Can I somehow make the query editable
and then the form will be editable also? If not, my question concerned making
a separate form just for storage of new records. If that is possible, how
would I go about coding that? I tried everythin I know to do, including
runcommand accmdrecordsgotonew and setting up me.recorsetclone to try and get
a save table. Thanks so much for your help!! Any suggestions greatly
appreciated!

> Sorry, Golfinray. Is there a question in there?
> What part are you having trouble with?
[quoted text clipped - 3 lines]
> > the second form. That record is then stored in the underlying table of the
> > first form. Thanks so much!!!

Reply to this Message

Klatuu - 01 Apr 2008 22:32 GMT

The query being based on a linked ODBC table is not why it is not editable.
The problem is the query is uneditable because of how it is constructed.
Union, crosstab, Totals, and some queries based on multiple table create
uneditable recordsets.

Let's start with the query. Can you post back with the query's SQL so we
can see what the problem may be, please?

Signature

Dave Hargis, Microsoft Access MVP

> Here is my problem. My query is not editable because the tables the query
> runs on are ODBC linked tables to an sql server. I even tried copying and
[quoted text clipped - 17 lines]
> > > the second form. That record is then stored in the underlying table of the
> > > first form. Thanks so much!!!

Reply to this Message