If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access: new record button dimmed, allow additions set to Yes. Can.
On one of my forms I cannot add new records even though the allow additions,
etc., properties are all set to yes. The new record button is dimmed on my toolbar as well. I can add new records in the datasheet and the two are linked without referential integrity being inforced. |
#2
|
|||
|
|||
1. If your Form uses a Query as the RecordSource, check to make sure the
Query is updateable. 2. If your Query is updateable, check the "Recordset Type" Prperty of the Form and make sure it is not of "Snapshot" type. -- HTH Van T. Dinh MVP (Access) "Shelley" wrote in message ... On one of my forms I cannot add new records even though the allow additions, etc., properties are all set to yes. The new record button is dimmed on my toolbar as well. I can add new records in the datasheet and the two are linked without referential integrity being inforced. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Button on Access form to open an excel document | Access Newbie | General Discussion | 1 | December 20th, 2004 07:05 PM |
Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
Open Excel File from Access Button | http://www.visual-basic-data-mining.net/forum | General Discussion | 2 | September 16th, 2004 10:51 AM |
Add new record by button only | Phil | Using Forms | 1 | September 5th, 2004 03:38 AM |