Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Export to export from adp form to mdb table using VBA
I am trying to export data directly from a form in an adp to a table in an mdb with VBA. (Don't ask me why, it's a long story!) Anyway I have the following code: Dim strSQLTransmit As String Dim strpat_last As String strpat_last = Me!txtpat_last strSQLTransmit = "INSERT INTO tblMain2 (...- TomGruett
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Access adp does not consistantly save records
On Error GoTo ErrorHandler: If Not IsNull(Me!cboLetterSelection) Then 'Saves the record If Me.Dirty = True Then Me.Dirty = False End If MsgBox "Record has been saved.", vbExclamation, "Record Saved" 'Enters log info Dim...- TomGruett
- Post #5
- Forum: Microsoft: Access Project (ADP)
-
Access adp does not consistantly save records
There is no trigger. It's just a simple form linked directly to the table. It does the normal save when you leave the record to go to a new one (using the NewRecord command), plus the two hard coded saves that I added to it.- TomGruett
- Post #3
- Forum: Microsoft: Access Project (ADP)
-
Access adp does not consistantly save records
I have an Access 2003 adp using a SQL Server 2008 backend. There are approx 20 users who are located in a different state and are connnected using the company WAN. Records do not save about 30% of the time. In my efforts to research/resolve this, I have coded a save on the data entry form...- TomGruett
- Thread
- Replies: 4
- Forum: Microsoft: Access Project (ADP)
