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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Trynew
- Order by date
-
How to check if field exist?
can creat a user Function and sure reference to DAO just like: Public Function isFldExt(strFldName As String, strSqlName As String) As Boolean On Error GoTo Err_isFldExt Dim rst As DAO.Recordset Set rst = CurrentDb().OpenRecordset(strSqlName) isFldExt = (strFldName =...- Trynew
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Form Controls Not Have Focus
The other way is set all controls Properties in your form and the Textbox look like a Label: Enabled = False Locked = True- Trynew
- Post #8
- Forum: Microsoft: Access Forms
-
Form Controls Not Have Focus
don't named your creat 'Close' button as 'CloseButton',change it's name to 'CmdClose'. the 'CloseButton' is the system name.- Trynew
- Post #5
- Forum: Microsoft: Access Forms
-
Closing Access
you can replace application.quit with Docmd.Quit- Trynew
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Run code on DB Close
i am allway run a hide form,the code want to run is put in form_close events.- Trynew
- Post #2
- Forum: Microsoft: Access Other topics
-
Synchronizing 2 different subforms
Add the next codes into your Subforms & Try Subform1: Private Sub Form_Current() On Error Resume Next If Me.Parent.ActiveControl.Name = Me.Name Then Me.Parent.subform2.Form.Recordset.Move Me.CurrentRecord * 2 - 1 - Me.Parent.subform2.Form.CurrentRecord End If End Sub...- Trynew
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Refreshing the data of a form when changing the value of a combo box
You can use the wizard to do that.- Trynew
- Post #4
- Forum: Microsoft: Access Forms
