I have a 2003 db, that if I have sort or a filter on, will not let me add a
record.
I added code to clear the filter when add record is done, but now find that
sort is a problem also.

Just doesn't sound right. Don't feel I need to add the code for either, may
be another problem.

Not a VB expert.

Thanks

On Sat, 15 Nov 2008 10:02:01 -0800, Dennis M <Dennis
(E-Mail Removed)> wrote:

>I have a 2003 db, that if I have sort or a filter on, will not let me add a
>record.
>I added code to clear the filter when add record is done, but now find that
>sort is a problem also.
>
>Just doesn't sound right. Don't feel I need to add the code for either, may
>be another problem.
>
>Not a VB expert.
>
>Thanks

No VBA is needed to either filter or sort a recordset. You can't sort or
filter a database - a Database in Access jargon is the .mdb or .accdb file, a
container for multiple tables, forms, reports, etc. Also you say "is a problem
also" without any indication of the nature of the problem.

What are you ACTUALLY doing? Do you have a Form? If so what is its
Recordsource property? Or are you using a query datasheet? If so what's the
SQL view of the query?
--

John W. Vinson [MVP]

"John W. Vinson" wrote:

> On Sat, 15 Nov 2008 10:02:01 -0800, Dennis M <Dennis
> (E-Mail Removed)> wrote:
>
> >I have a 2003 db, that if I have sort or a filter on, will not let me add a
> >record.
> >I added code to clear the filter when add record is done, but now find that
> >sort is a problem also.
> >
> >Just doesn't sound right. Don't feel I need to add the code for either, may
> >be another problem.
> >
> >Not a VB expert.
> >
> >Thanks
>
> No VBA is needed to either filter or sort a recordset. You can't sort or
> filter a database - a Database in Access jargon is the .mdb or .accdb file, a
> container for multiple tables, forms, reports, etc. Also you say "is a problem
> also" without any indication of the nature of the problem.
>
> What are you ACTUALLY doing? Do you have a Form? If so what is its
> Recordsource property? Or are you using a query datasheet? If so what's the
> SQL view of the query?
> --
>
> John W. Vinson [MVP]
>

John,

This is a Sql server with about 6800 records. This is when we are entering
new license in the database, the operator sorts and filters on license names
and numbers when they have to edit a record. Then to add a new record they
couldn't if a filter was on one of the fields, we have several types of
licenses in the db. The "is also a problem" is if it is sorted alpa numeric
causes the add new record to go gray. I dont have the db in front of me now,
its at work, was developed in 2003 in access and the forms are just relinked
every year to a new table with new year dates. We are changing all out later
next year so we just need to get this one working a little better. If they
rememebr to clear the sort and the filter you canadd a new record. The forms
use querys and select statements. My expertice was in Fox Pro but not in
programming

"John W. Vinson" wrote:

> On Sat, 15 Nov 2008 10:02:01 -0800, Dennis M <Dennis
> (E-Mail Removed)> wrote:
>
> >I have a 2003 db, that if I have sort or a filter on, will not let me add a
> >record.
> >I added code to clear the filter when add record is done, but now find that
> >sort is a problem also.
> >
> >Just doesn't sound right. Don't feel I need to add the code for either, may
> >be another problem.
> >
> >Not a VB expert.
> >
> >Thanks
>
> No VBA is needed to either filter or sort a recordset. You can't sort or
> filter a database - a Database in Access jargon is the .mdb or .accdb file, a
> container for multiple tables, forms, reports, etc. Also you say "is a problem
> also" without any indication of the nature of the problem.
>
> What are you ACTUALLY doing? Do you have a Form? If so what is its
> Recordsource property? Or are you using a query datasheet? If so what's the
> SQL view of the query?
> --
>
> John W. Vinson [MVP]
>

On Sat, 15 Nov 2008 15:22:01 -0800, Dennis M
<(E-Mail Removed)> wrote:

>John,
>
>This is a Sql server with about 6800 records. This is when we are entering
>new license in the database, the operator sorts and filters on license names
>and numbers when they have to edit a record. Then to add a new record they
>couldn't if a filter was on one of the fields, we have several types of
>licenses in the db. The "is also a problem" is if it is sorted alpa numeric
>causes the add new record to go gray. I dont have the db in front of me now,
>its at work, was developed in 2003 in access and the forms are just relinked
>every year to a new table with new year dates. We are changing all out later
>next year so we just need to get this one working a little better. If they
>rememebr to clear the sort and the filter you canadd a new record. The forms
>use querys and select statements. My expertice was in Fox Pro but not in
>programming

Very interesting... but not what we'll be needing, I fear!

Again... *We cannot see the database*.

You have not posted any description of the Table.
You have not posted the Recordsource for the form.
You have not posted the code or method used to "sort or filter", nor indicated
why that is necessary in order to enter data..
You have not posted what you mean by "go gray".

We'll try to help, but you will need to help us understand the structure of
the database before we will be able to do so.
--

John W. Vinson [MVP]

There are 4 tables and 30 colums in license table, 10 in Corpheadquarters, 5
in lictype, 5 in licstatus
The License table is updated by the data entry people from main lic form
Sort is using access tools to sort, no special code. We also have combo
boxes for selection on type and status.

I will send screen shot if you like, it is the * at the bottom of the form
that grey out that means you can't add a record, excape won't clear that
either.

Filtersa nd sort ar not necessary to enter new records just to find them
quickly. That is when they can't update to new record


"John W. Vinson" wrote:

> On Sat, 15 Nov 2008 15:22:01 -0800, Dennis M
> <(E-Mail Removed)> wrote:
>
> >John,
> >
> >This is a Sql server with about 6800 records. This is when we are entering
> >new license in the database, the operator sorts and filters on license names
> >and numbers when they have to edit a record. Then to add a new record they
> >couldn't if a filter was on one of the fields, we have several types of
> >licenses in the db. The "is also a problem" is if it is sorted alpa numeric
> >causes the add new record to go gray. I dont have the db in front of me now,
> >its at work, was developed in 2003 in access and the forms are just relinked
> >every year to a new table with new year dates. We are changing all out later
> >next year so we just need to get this one working a little better. If they
> >rememebr to clear the sort and the filter you canadd a new record. The forms
> >use querys and select statements. My expertice was in Fox Pro but not in
> >programming
>
> Very interesting... but not what we'll be needing, I fear!
>
> Again... *We cannot see the database*.
>
> You have not posted any description of the Table.
> You have not posted the Recordsource for the form.
> You have not posted the code or method used to "sort or filter", nor indicated
> why that is necessary in order to enter data..
> You have not posted what you mean by "go gray".
>
> We'll try to help, but you will need to help us understand the structure of
> the database before we will be able to do so.
> --
>
> John W. Vinson [MVP]
>

On Sun, 16 Nov 2008 05:14:02 -0800, Dennis M
<(E-Mail Removed)> wrote:

>There are 4 tables and 30 colums in license table, 10 in Corpheadquarters, 5
>in lictype, 5 in licstatus
>The License table is updated by the data entry people from main lic form
>Sort is using access tools to sort, no special code. We also have combo
>boxes for selection on type and status.
>
>I will send screen shot if you like, it is the * at the bottom of the form
>that grey out that means you can't add a record, excape won't clear that
>either.
>
>Filtersa nd sort ar not necessary to enter new records just to find them
>quickly. That is when they can't update to new record
>

The screenshot isn't really necessary or much help. Please instead open the
Form in design view; view its Properties. Select the Data tab and click the
.... icon by the Record Source property. What's there? If it's a Query (as is
likely given the symptoms) please click the ... icon by it to open a query
design window, and select View... SQL; post the SQL string here.
--

John W. Vinson [MVP]