Just 1 record in a table

R

Richard

Hi I am new to access just been using it for a couple of weeks now. I have
access 2000 and i have set up a form with a combo box that gets it's data
from a table. I then take the selected data and place it in another table.
What i want is to have it overwrite the data each time i select it in the
combobox not create a new record each time. Is this possible. Thank in
advance
 
C

Chris

Um, maybe all you need to do is to move back to the first
record. The old value should then appear in the combobox
and you can overwrite it.

HTH

Chris
 
J

John Vinson

Hi I am new to access just been using it for a couple of weeks now. I have
access 2000 and i have set up a form with a combo box that gets it's data
from a table. I then take the selected data and place it in another table.
What i want is to have it overwrite the data each time i select it in the
combobox not create a new record each time. Is this possible. Thank in
advance
Click to expand...

It's possible - set the Cycle property of the form to Same Record, and
the Allow Additions property to False - but I really have to wonder
why you would want to do this!
 
C

Craig Alexander Morrison

In some of our applications we have a table called DefParmInfo, this is a
table on the workstation or the server depending upon whether the setting
applies to all users or just the current user.

What one needs to do is setup a table with at least two fields, the first
being the primary key, let's call it. DefParmInfoParameter and a second
field called DefParmInfoValue.

When you select a value on your form you then run an update query.

UPDATE DefParmInfo SET DefParmInfo.DefParmInfoValue =
[Forms]![cdataLogon]![GroupMemberCode]
WHERE (((DefParmInfo.DefParmInfoParameter)="cdataGroupMemberCode"));

to set the new value.

When you run the form be sure to get the data from the table using, say,
the DefaultValue for the field setting, such as
=DLookUp("[DefParmInfoValue]","[DefParmInfo]","[DefParmInfoParameter] =
'cdataGroupMemberCode'")

The use of a Defaults and Parameters table means that you can remember the
settings selected by the user/administrator for use on subsequent
operations.

This has nothing to do with the central database it is merely an application
processing device.

If you wish to store more than one value for the given "parameter" just add
some more fields to the table.

--
Slainte

Craig Alexander Morrison
 
R

Richard

Becuase i am a beginner. I have been placed in front of the computer to
sort out a database on staff training levels. I use the combo box in that
form to place the selected data in a table in this case someones name. I
then have worked out how to get my query to use the data from my table that
save all the training info hence the query just displays the info of the
particular person. Why becuase everyone else is going to be using it and i
need them to be able to get what they want by just selecting aname and
clicking on a button to get a record of that person. I have done the same to
get the training level for each area on another form just it a area name and
not a person. I suspect that i have just done a massive workaround for a
simple task but with the info you gave me it works with a little help from a
macro that shuts down the form then opens it again so we can go on selecting
Giving you this info so you can have a laugh and mybe piont me into a easier
direction

Once again thanks
 
J

John Vinson

Becuase i am a beginner. I have been placed in front of the computer to
sort out a database on staff training levels. I use the combo box in that
form to place the selected data in a table in this case someones name. I
then have worked out how to get my query to use the data from my table that
save all the training info hence the query just displays the info of the
particular person. Why becuase everyone else is going to be using it and i
need them to be able to get what they want by just selecting aname and
clicking on a button to get a record of that person. I have done the same to
get the training level for each area on another form just it a area name and
not a person. I suspect that i have just done a massive workaround for a
simple task but with the info you gave me it works with a little help from a
macro that shuts down the form then opens it again so we can go on selecting
Giving you this info so you can have a laugh and mybe piont me into a easier
direction
Click to expand...

Well, it seems you may have fallen into the very common misconception
that you must have a Table containing only the data that you want to
display in order to display it.

You can instead display selected data from existing tables using a
Query. I'm not certain how your tables are structured, so I can't
really suggest what that query might be; but if you have a table of
People, you can use a Query (or a form filter, or numerous other
techniques) to display that person's information on a form, without
storing it into a second table as I gather that you're doing now.

Could you please post a description of your tables and the data they
contain? As you say, there is probably an easier way; and I promise
not to laugh at you (though I hope we can have a laugh together after
you get this all working!)
 
Top