Data Access Page

[Steve]

I created a DAP to do my invoicing but when I change the "DataEntry" to true
so I can input data it goes blank????

Thank you in advance Steve

 

[Vincent Johns]

I created a DAP to do my invoicing but when I change the "DataEntry" to true
so I can input data it goes blank????

Thank you in advance Steve

If I correctly understand what you're doing, it's working correctly.
"DataEntry" means ONLY data entry, and it doesn't display anything else.
If you turn that off, you get to see all the records, and if your
dataset is updateable (as you can determine by checking that the little
asterisk in the navigation buttons is not grayed out), then you can
enter data into the new blank record at the bottom of the Form.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Steve]

Unfortunately, it is grayed out, I do not mind seeing all the records I would
just like to edit/add/delete data. I have two group levels, does that matter?

 

[Vincent Johns]

Unfortunately, it is grayed out, I do not mind seeing all the records I would
just like to edit/add/delete data. I have two group levels, does that matter?

It might. Can you enter data using the Query underlying your Form?
Some Queries allow you to enter data, others don't. If you can't edit
via your Query, then you can't edit via the Form based on that Query either.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Steve]

I don't have it pointing to the query I have it connected to the table
directly, should I switch to the query?

 

[Vincent Johns]

I don't have it pointing to the query I have it connected to the table
directly, should I switch to the query?

Not necessarily, but it might help in debugging. Can you edit the Table
directly (in Table Datasheet View)? Usually, you'd use your Form for
editing, but for debugging I think it helps to strip away layers that
might hide what's happening. If you can edit the Table, and there's no
Query or SQL statement in your Form, then the problem is apparently in
the Form.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Steve]

Figured it out, I did not have the key in the update area as soon as I placed
it there it allowed me to update.

 

[Vincent Johns]

Figured it out, I did not have the key in the update area as soon as I placed
it there it allowed me to update.

OK, thanks for letting me know what happened.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Alex]

Hi,
I appear to be having the same problem you originally described. You wrote
that " I did not have the key in the update area as soon as I placed it there
it allowed me to update." What key and which update area?

Thank you ahead of time, Alex

"Steve" skrev:

 

[Sylvain Lafontaine]

He talking about setting a primary key for all tables used in the query.