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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access Write Conflict
pervinpj - Thanks for the suggestion - I tried putting the focus to the button that the user clicks and it didn't help....- ljallem
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Access Write Conflict
I have an Access 2000 front-end with a SQL Server 2000 back-end. My tables are linked using ODBC. On one of my forms, I give users the option to delete a record. The user selects from a list box. The list box has an After_Update event that does the following Me.lstAkHandle.Requery...- ljallem
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
using additem for a multi column ComboBox
Do you have to dim the array right away - could you just dim it without the size specified and then redim it with the appropriate size when you know how big it needs to be? i.e. Dim MyArray() As Integer ' Declare dynamic array. 'Do code here to figure out how many elements Redim MyArray(x)...- ljallem
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
change query criteria from VBA
I need to change the criteria from VB on a cross-tab query created in Access. I have already created the cross-tab query. Based on what the user selects on my form, I want to change the criteria from VB, open the query, and export the results to Excel. Its no problem to export but I cannot...- ljallem
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
