Search results for query: *

You'll get this message if the record shown on the form doesn't pass validation criteria. For example, there may be validation rules for a field that this record doesn't meet, or it might create a duplicate record, etc.<br><br>Have you first checked to see if the record is valid?<br>

Note that Elizabeth's solution is form based, while my solution and advpay's solution are table based. All are appropriate and can be implemented independently or concurrently.<br><br>Also..<br>I prefer <U>0&quot;</U> as the column width rather than <U>0&quot;,1&quot;</U>, if you have only two...

Thanks elizabeth. What you said sparked something in the back of my mind. I decided to review their procedures. It turns out the windows &quot;copy&quot; function was used to back up the database. Since the database is now over a quarter gig in size, it takes several minutes to copy it, during...

You can also use the &quot;lookup&quot; properties for the Supplier_id field in tbl_order, whether or not you set a relationship (though I recommend the relationship):<br><br>Display Control: <U>Combo Box</U><br>Row Source Type: <U>Table/Query</U><br>Row Source: <U>SELECT...

Thanks Lightning. Compacting used to work, but now the only way around it is to try to append a record with the highest autonumber.<br><br>INSERT INTO MyTable ( MyAutoNumberId )<br>SELECT TOP 1 [MyTable].[MyAutoNumberId] AS ID<br>FROM MyTable<br>ORDER BY [MyTable].[MyAutoNumberId]...

I'm having a very weird problem with many of my tables, which have an AutoNumber field. When I add a record to the table, it generates an value for the AutoNumber field that already exists. I never really paid much attention to this field, until I started to get a message saying I couldn't add a...