Search results

Hi there, Can anybody help me make sense of this Wizard? I have a normal split Access 2007 application I'm trying to package. When I first looked at this Wizard I assumed I could use the "Custom Features" section to allow the user to choose between full installation (Front and Back) and a "Front...

My long explanations may have clouded the issue. The problem is that when deleting directly in the sub-form by selecting one or more records with the datasheet's record selection column and pressing the keyboard Delete key, the error causes by referential integrity (duplicate key) is only caught...

Thanks for responding. I would have thought so too! A delete button on the main form (records I'm deleting are on sub-form) deletes highlighted record using "Me.Workers_subform.Form.Recordset.Delete" which raises an error if the record may not be deleted due to referential integrity issues. I...

Hi, I'm trying to replace all access error messages with my own custom ones. I'm stuck in one area only and would appreciate any help. In the runtime, I want to allow users to select records using the far left "record selection" column of a dataSheet and permit deletion via the keyboard "Delete"...

A bit late I know... But I just bumped into this error in an Access 2007 application. I'm adding records via a very simple form and have no indexes at all on the table that gives the error seemingly at random when adding new records. Also, there are no memo fields or field names with spaces as...

Repaired the application several times with no impact on the intermittent problem. Thanks.

If you want to isolate input data before writing it to underlying tables then use unbound controls to capture user input and either open a recordset in code to append or update records or use execute statement to write to the table. For example, consider a parameter table with fields Param1...

I'm developing my first large Access 2007 application using a front-end database for code and forms with an encrypted back-end database for data (both Access 2007 and both on the same machine). I have an intermittent problem at design time in that sometimes when I close my application front end...