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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by usgupta
-
Error if no matching Report
Suzanne, When the user clicks the report button, 1. Show an Input Box and ask for the name 2. Open a recordset and get the count for the entered name 3. If recordcount is > 0 then 'Open the report and show Else Msgbox "Invalid name" 'Do not open the report at all and...- usgupta
- Post #2
- Forum: Microsoft: Access Forms
-
VBA CODE FOR ACCESS 2002 FORM CONTROL
Try this. Paste the following code in the LostFocus event of the Combo Box cmbComments. If IsNull(cmbComments) Then MsgBox "No value selected." Else Call cmbComments_AfterUpdate End If Hope this shud solve ur prob.- usgupta
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Selecting all the text in a text box
Use the TextBox.SelStart and TextBox.SelLength properties of the Text control. TextBox.SetFocus TextBox.SelStart = 1 TextBox.SelLength = Len(TextBox.Text) This should help you.- usgupta
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Help with "Too Many Fields Defined" error.
Delete ur entire code, paste this and see. DoCmd.TransferSpreadsheet acExport, , "wo_qry", "C:\WO\WO_Report.xls", True I think u are opening and clearing the contents of the excel file every time before u export. Instead of this u delete the file and then run the above code. It will...- usgupta
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
find record number of record that matches criteria?
Try the recordset.AbsolutePosition property.- usgupta
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
