Record Not Inserted

Dan McClelland

Guest

Posts: n/a

17th Dec 2003

Using Access XP and SQL Server 2000.

Have a form whose recordsource is either an SQL statement
or a stored procedure (more than one table). Unique table
and Resync command properties are set. Form has
AllowAdditions set to false, but New Record button sets it
to true through VBA code and I'm able to begin adding a
record.

Upon closing the form, if I've skipped any of the required
fields, the form closes with no warning and the new record
is not inserted. Why? My users need a warning.

« logon with diffrent name | Under the UPDATE gun »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
inserted pictures are horizontally flipped when inserted	A	Microsoft Word New Users	1	10th Apr 2007 05:34 PM
How to get record ID of just inserted record	wazza_c12@hotmail.com	Microsoft Access Queries	2	21st Feb 2006 05:25 PM
Spaces inserted around text inserted into replies in HTML format	Dan Cooperstock	Microsoft Outlook Discussion	0	9th Jun 2004 02:00 PM
How to get the ID of an item inserted into a database right after it has been inserted	Dino M. Buljubasic	Microsoft ADO .NET	3	4th Dec 2003 03:38 PM
Data Inserted Into Form is not inserted into the table	pys	Microsoft Access Forms	1	30th Oct 2003 06:09 PM