Search results for query: *

Thanks for your help! I'm using Access 2000 right now. Given your mention of its limitations, I tried my code in Access 2002 and it works fine without any changes. I am going to investigate upgrading to Access 2002 - I think it's probably my best bet.

I use the following code to assign the recordset to the form: Dim cnnLocal As New ADODB.Connection, rstCurr As New ADODB.Recordset, strQuery As String Dim intTest As Integer Set cnnLocal = CurrentProject.Connection strQuery = "Select * from dbo.Circuits"...

I made a mistake... my first block of code should be Dim rs As New ADODB.Recordset Set rs = Forms("Provision").Recordset rs.Resync

I am very confused with how ADPs handle recordset updates. I have tried poured over books and newsgroups, and I still cannot get data to update correctly. Any assistance would be greatly appreciated. In order to allow a form, "Provision", to obtain the most recent updates made by other users...

Hi - Circuits is a table - sorry I forgot to specify. Thanks for your suggestions. I just tried compacting & repairing - no luck there. Setting just the unique table command doesn't work either. Once I open the form in form view, the Unique Table value has been cleared out. I thought I...

I have a form with RecordSouce = "Select * from dbo.Circuits" I have tried to set UniqueTable = Circuits (this appears as an option in the drop-down) and ResyncCommand = "Select * from dbo.Circuits WHERE dbo.Circuits.RecID =?" (where RecID is my primary key). After I set...