Data Access Page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Steve said:
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
Click to expand...

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.
 
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?
 
Steve said:
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?
Click to expand...

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.
 
I don't have it pointing to the query I have it connected to the table
directly, should I switch to the query?
 
Steve said:
I don't have it pointing to the query I have it connected to the table
directly, should I switch to the query?
Click to expand...

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.
 
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.
 
Steve said:
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.
Click to expand...

OK, thanks for letting me know what happened.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
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:
 
Back
Top