Can we sort a form and also be able to enter new records.

  • Thread starter Thread starter Rex
  • Start date Start date
R

Rex

Hi,

It is possible to sort the data on a form and also be able to enter
new and edit the existing records in it.

Cheers!
 
Hi,

It is possible to sort the data on a form and also be able to enter
new and edit the existing records in it.

Cheers!
Click to expand...

I assume you mean "Is it".
The form sort order has nothing to do with editing or adding new
records, so the answer is yes.
If you cannot edit or add new records, make sure the form's record
source, if it is a query, is updateable. Some queries are not.
Open th underlying query. If the Add New Record button is grayed out
the query cannot be edited nor a new record added.

See Access help:
Query + Troubleshoot queries + Select Query + I can't update data
from a query + Data can't be updated
 
Allen Browne also does a very good job of clearly explaining what makes
queries Read-Only here:

http://allenbrowne.com/ser-61.html

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
 
I have a query like the one below and it does not allow me to edit or
add new records in a form. I am using MS Access as front end to MS SQL
Server 2000.

SELECT TOP 100 PERCENT dbo.MemberDNA.trackID,
dbo.MemberDNA.member, dbo.Member.memType, dbo.Member.firstName,
dbo.MemberDNA.dateSentIMVS,
dbo.MemberDNA.analysisType, dbo.MemberDNA.filePath,
dbo.MemberDNA.amount, dbo.MemberDNA.modifier,
dbo.MemberDNA.modified
FROM dbo.MemberDNA INNER JOIN
dbo.Member ON dbo.MemberDNA.member =
dbo.Member.memberID
ORDER BY dbo.Member.memType

I think it is because of the inner join. Is there any other way to
edit or add new records to this query from a form.

Thanks
 
I have a query like the one below and it does not allow me to edit or
add new records in a form. I am using MS Access as front end to MS SQL
Server 2000.

SELECT TOP 100 PERCENT dbo.MemberDNA.trackID,
dbo.MemberDNA.member, dbo.Member.memType, dbo.Member.firstName,
dbo.MemberDNA.dateSentIMVS,
dbo.MemberDNA.analysisType, dbo.MemberDNA.filePath,
dbo.MemberDNA.amount, dbo.MemberDNA.modifier,
dbo.MemberDNA.modified
FROM dbo.MemberDNA INNER JOIN
dbo.Member ON dbo.MemberDNA.member =
dbo.Member.memberID
ORDER BY dbo.Member.memType

I think it is because of the inner join. Is there any other way to
edit or add new records to this query from a form.

Thanks
Click to expand...

Why do you need the inner join in the form's recordsource? What fields are you
updating? Could you instead use a Form based on Member and a subform based on
MemberDNA?

Also... is MemberID the Primary Key of Member, and does Access know that?

Also... sometimes SQL tables are only updateable if they contain a field of
Timestamp datatype. You don't need to do anything with the field, it just
needs to be there.

John W. Vinson [MVP]
 
Why do you need the inner join in the form's recordsource? What fields are you
updating? Could you instead use a Form based on Member and a subform based on
MemberDNA?

Also... is MemberID the Primary Key of Member, and does Access know that?

Also... sometimes SQL tables are only updateable if they contain a field of
Timestamp datatype. You don't need to do anything with the field, it just
needs to be there.

John W. Vinson [MVP]
Click to expand...

Form's recordsource is a query. And the query has an inner join
between MemberDNA and Member table. The reason for this query is I
want to see the records in the form sorted based on Member.memType.
The fields I am updating are the fields in MemberDNA table. The reason
for using Member table is because I want to sort records by
Member.memType.

Yes, MemberID of Member table is a primary Key however, MemberDNA
table has a composite key consisting of trackID and Member (which is
same as MemberID)

I dont have any field with Timestamp datatype in my tables.
 
Back
Top