I have upgraded a small local app from Access 2003 to 2007. I have a menu
that calls a few forms.
On the first form I tried to open from the menu, I've noticed that the 'new
record' button on the navigation strip is not enabled. And I'd really like to
add records using the form!
On the form properties I have Data Entry set to 'no', and 'allow additions',
'allow deletions', 'allow edits', 'allow filters' all set to yes.
Any suggestions?
Thank you
|
|
0
|
|
|
|
Reply
|
 Utf
|
6/24/2007 9:22:00 PM |
|
Is the form's Recordset Type set to Dynaset?
If the form is based on a query, open the query directly, and see if you can
add a new record there. If you can't in the query either, then the problem
is not to do with the form.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Chris Smith" <ChrisSmith@discussions.microsoft.com> wrote in message
news:69CC1414-A68A-4F42-9F2B-9EC3F335E442@microsoft.com...
>I have upgraded a small local app from Access 2003 to 2007. I have a menu
> that calls a few forms.
>
> On the first form I tried to open from the menu, I've noticed that the
> 'new
> record' button on the navigation strip is not enabled. And I'd really like
> to
> add records using the form!
>
> On the form properties I have Data Entry set to 'no', and 'allow
> additions',
> 'allow deletions', 'allow edits', 'allow filters' all set to yes.
>
> Any suggestions?
>
> Thank you
|
|
|
0
|
|
|
|
Reply
|
Allen
|
6/25/2007 1:13:40 AM
|
|
|
1 Replies
791 Views
(page loaded in 0.056 seconds)
Similiar Articles: 'new record' button not active in Access 2007 form (old 2003 form ...'new record' button not active in Access 2007 form (old 2003 form) Follow New (Blank) record not active - microsoft.public.access.forms ...How can I let the user insert new records but not allowingthem to uodate ... 'new record' button not active in Access 2007 form (old ... 'new record' button not active ... How to open a blank form for adding a new record - microsoft ...'new record' button not active in Access 2007 form (old ... If the form is based on a query, open the query directly, and see if you can add a new record ... Use Form button to move current record to another table ...... active database, to remove the > > record ... new record ... record to a different table in Access 2007 - Microsoft Access ..... just be able to create a button on the form ... Select Record in query, save as New Record then edit New Record ...Access 2007 ... this active record that is showing in the form ... new one. I would like to keep the old record with it's original ID number. Using a Command Button. Append a database in a form. (New to Access 2007) - microsoft ...'new record' button not active in Access 2007 form (old ... 'new record' button not active in Access 2007 form (old 2003 form) Follow ... And I'd really like to add records ... Add a new record via a popup form - microsoft.public.access ...'new record' button not active in Access 2007 form (old ... And I'd really like to add records using the form! On the form properties I have Data ... Insert Clipart in a Access 2007 Form ? - microsoft.public.access ...'new record' button not active in Access 2007 form (old ... 'new record' button not active in Access 2007 form (old 2003 form) Follow ... form in design view and would like ... Can't add new record to form/query - microsoft.public.access ...... currently=20 being used at the client site with Access 2003 ... 'new record' button not active in Access 2007 form (old ... If the form is based on a query, open the query ... Access 2007 - force form to open with new record - microsoft ...'new record' button not active in Access 2007 form (old ... Access 2007 - force form to open with new record - microsoft ... Access 2007 - force form to open with new ... 'new record' button not active in Access 2007 form (old 2003 form ...'new record' button not active in Access 2007 form (old 2003 form) Follow 'new record' button not active in Access 2007 form (old 2003 form)'new record' button not active in Access 2007 form (old 2003 form) Create New Record using Command button on Separate form: Microsoft ...... Create, New, Record, using, Command, button, on, Separate, form ... populated an Access 2003 table with a complete set of identical records ... have great, active ... Make a command button the Cancel button - Access - Office.com... the form is the active form, you can choose the command button ... Support / Access / Access 2003 ... tables, queries, forms, reports, and macros. In Design view, you can create new ... Order By disables "New (blank) record" button - dBforums... upgraded to Office 2007 from 2003. This issue was not apparent using Access 2003 ... When I sort the form by this Client Name field, the "New (blank) record" button is ... 7/15/2012 7:01:30 AM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
38 followers. 