Recent content by atrapp

Disable Trigger I know this is an old post but the solution to stop the trigger from screaming on a bulk delete would be: alter table [TableName] disable trigger [DeleteTriggerName] Delete statement here alter table [dbo].[TableName] enable trigger [DeleteTriggerName] HTH

Apply Filter to a Form Hello all! I have an unbound main form in an Access Data Project that has three forms used as mutually exclusive source objects of the main form. They are opened by selected their name from a combo box in the toolbar. I have three "flavors" of each form and that is...

I Fixed It!!!! Mod, See the 'Here it is...' post. It WAS that the index was not set on the underlying table. :rolleyes: Argh! Such a simple fix that took me 2 days to find! But I found it and that's all that counts, right??? ;) Thanks for all your help! :D AT

Trying again...I don't see it... The file was too large so I had to delete about half the forms. The form that's showing a disabled New Record button is SA Log. Thanks for all your help! AT

Here it is.. A few things to note: Yes, I did check the Allow Additions property on the form and it was set to 'Yes' AND I tried adding Me.AllowAdditions=true to the code to no avail. I can't remember which event I tried it in so I'll try OnLoad. I am using an .adp file, which may or may not...

I'll try... Here's the code behind the form: ************************************************ Option Compare Database Private Sub ApplicationID_Change() Dim strSQL As String strSQL = "SELECT WorkTypeID, WorkType FROM [SAWorkType] WHERE (ApplicationID = " & Me.ApplicationID.Value & ") ORDER...

Hello all, I have an application that shows 3 forms, 1 with 2 subforms and 2 standard single record forms. The New Record button for one of the single record forms is disabled and I can't figure out why. None of my colleagues have been able to help. Does anyone know why this might happen? I've...