Recent content by mccallradar

There is no file like that anywhere. Also, it seems to only be a problem if you run the DB in Access 2007. I ran it in 2003 and it works fine. Any thoughts?

Hello: I am running Access 2007 - I have a form that when opened uses a macro to go to a new record. All property control settings are set to no locks. It is a shared DB. When I open the form and start to enter new data in the first field I get an error message saying "Field Cannot Be Updated."...

Thanks. Worked great! I should have thought of that. Everyone was great in helping me.

bookmark to locate a record error 3464 I tried using a bookmark to locate the record. Here is the Code: Private Sub FullBuyerName_DblClick(Cancel As Integer) Dim MyRS As Recordset, Criteria As String Set MyRS = Me.RecordsetClone Criteria = "[idsBuyerID] = '" & Me.ContractNumber &...

screen shot 2 Here is a screen shot of what I am trying to do. Thanks, Jason

I still get a syntax error? Is there a way to make a macro work for the event? What code would I use for the where condition in the macro? I can make it open the form as macro but not go to the specific record. Here is the code as it exists from our previous discussions: Private Sub...

Runtime Error I did this but I get a runtime error 3075, syntax error. Missing operator in query expression. Here is the code: Private Sub FullBuyerName_DblClick(Cancel As Integer) DoCmd.OpenForm "Contracts", acViewNormal, , "RecordID=" & Me.FullBuyerName End Sub Please Help. I think we are...

Screen Pics from DB Attached are two screen shots. Thanks for the help. I am stumped. -Jason

My fault for not being clear. This is my first forum question. The Main form is NOT linked to a subform. There is NO subform. The user clicks a command button on the main form (Contracts) and that command runs and opens the query, i.e. runs SummOpenContracts. It is displayed in datasheet view in...

Hello everyone, I have a query that runs from the main form when the command button is clicked. It displays the results in datasheet view. I want the user to double click a specific record and jump to that specific record in the main form. How do I do this? Sorry, if this is a dumb question...