I HAVE A TABLE WITH FIELDS ITEM, RATE
I HAVE A FORM BASED ON ABOVE TABLE
IF I TRY TO ADD VALUES IN TABLE USING INPUTBOX , IT DOES NOT GET ADDED.
IF I OPEN THE FORM IN CODE AND ADD THE INPUTBOX VALUE IN [FORMS]!FORMNAME]![FIELD],IT GETS ADDED.
IS IT NECCESSORY TO OPEN FORM TO ADD DATA IN FIELDS...
dear sandy,
thank you for your immediate response.
i can try what you suggested.
but i am affraid because
the records can be indexed in whatever way, but the thing is that, query reads the records only in the order in which they are stored and not in order they are displayed.
can i send the...
dear iainm
thank you for your immediate response.
i have already done this.
i added a field "sl no', with its datatype auto no.
and kept index on
this way the records are displayed in order but still the query does not refer to the indexed table .
can i email the table to you?
regards
arunsule
THE RECORDS GET ADDED RANDOMLY IN A TABLE
AND THE QUERY BASED ON THIS TABLE DOES NOT WORK PROPERLY AS IT CAN NOT READ LAST RECORD CORRECTLY, BECAUSE THE LAST RECORD GETS INSERTED SOMEWHERE IN TABLE AT RANDOM.
WHAT TO DO ,TO ENSURE THAT THE RECORDS GET ADDED ON 'FIRST ADDED FIRST RECORDED' BASIS...
new records in a table get added randomly.
and the query based on this table does not work properly as
it never reads the last record correctly
what to do so that the records get added on first come basis?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.