Adding values in to table for appropriate fields only

N

naveen prasad

Hi all i have a table T1

Fields are a1,a2,a3, b1,b2,b3, c1,c2,c3, d1,d2,d3, e1,e2,e3 = 15 fields
created

a1,a2,a3 belongs to 1 group like requests received,time in, time out.

b1,b2,b3 beongs to group like request actioned, time in, time out.

c1,c2,c3 belongs to group like request cleared time in ,time out.

like wise other groups also.

a1,a2,a3 data is say upto 125 records.
b1,b2,b3 data is say upto 100 records
c1,c2,c3 data is say upto 75 records.

i want to create form which will be input to c1,c2,c3 fields only.

when a record is entered it should be entered at 76th record, but it is
entereing at 126th record..
 
G

ghetto_banjo

sounds like you should be setting this up as separate tables (table
for a values, table for b values, etc).

if you look at a record that has a1, a2, and a3 data, well technically
that record has the b and c data as well, even if they are null or
zero.


you would need to do use a recordset or something to find the "first"
record that has null/zeros for c values and then update that existing
record. it would be messy.
 
K

KARL DEWEY

Fields are a1,a2,a3, b1,b2,b3, c1,c2,c3, d1,d2,d3, e1,e2,e3 = 15 fields
created
Your problem stems from trying to use Access as a spreadsheet.
Your 'b' set of fields need to be recording data in the present set of 'a'
fields with an added field (group) if you need to distinguish the information
differently.
Tain't so as all of the fields use the same records.
Unless you included a field to number the records they are not numbered.
Access stores records like a barrel of bricks, just a jumble. To display
them in some specified order they must be sorted, not in the table, but in a
query or SQL statement for the form Record Source.
Seeing as how ALL fields use the same records, when you add records ALL
fields are included.

If you care to explain a little of how you plan to use the data that is
being collected someone might be able to suggest a proper method to store and
retrieve it.
 
N

naveen prasad

I have created a form containing 5 combo boxes.

each appropriate combo box is having distinct information of a1,b1,c1,d1,e1.

like combo1 is a1, combo2 is b1, combo3 is c1 etc...

now when i click/select a combo box, its appropriate corresponding query
will run and fields will be displayed


now i want to create a form to enter data into a1,a2,a3 b1,b2,b3
c1,c2,c3

when i add a1,a2,a3 then it should be added in the data base a1,a2,a3
with out disturbing the existing values of b ,c d,e etc ..

need help
 
K

KARL DEWEY

when i add a1,a2,a3 then it should be added in the data base a1,a2,a3
And will you be wanting to add this data to a new record? If so, set
the Data Entry property to Yes. It will add a new record just like you say
it is doing.

If you do not want to add a new record then how do you determine which
record to update with your entry?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top