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 Wanet Telecoms Ltd 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: ausMuenchen
- Order by date
-
Clearing recently saved list in Word, Excel, etc
I have been using the free version of iISystem Wiper, clears the recently saved list for me. I am using Office version 2000.- ausMuenchen
- Post #8
- Forum: Microsoft: Windows
-
how do i represent a variable in a do command line.
If you wanted to use the value of txttapetype as part of the name of the query then this should work. Select Case txttapetype Case "DTR" DoCmd.OpenQuery "LB Make " & txttapetype & " table", acViewNormal, acEdit DoCmd.OpenQuery "LB Append " &...- ausMuenchen
- Post #3
- Forum: Microsoft: Access Forms
-
how do i represent a variable in a do command line.
Hello what does the Select look like? If I understand what you want it should look like this. Select Case txttapetype Case "DTR" DoCmd.OpenQuery "LB Make txttapetype table", acViewNormal, acEdit DoCmd.OpenQuery "LB Append txttapetype to txttapetype master...- ausMuenchen
- Post #2
- Forum: Microsoft: Access Forms
-
hit return key to display requested data
you could try the form_keyDown sub. Private Sub Form_KeyDown(KeyCode As Integer, Shift _ As Integer) Select Case KeyCode Case vbKeyReturn 'Do something Case Else End Select End Sub You have to set the Form control keyPreview to True yourForm.KeyPreview = True Hope this...- ausMuenchen
- Post #2
- Forum: Microsoft: Access Forms
-
Use text box name field as a variable?
Thank you so much, works great. I should have come here a few days ago. This will save me alot of time. Thanks again- ausMuenchen
- Post #3
- Forum: Microsoft: Access Forms
-
Use text box name field as a variable?
Hello, I have a form with a large amount of text boxes, is it possible to reference these as an array , or is there an easier way to do this. I set all of the boxes to not visible when the form loads and only show them when they are filled. I am filling them in a loop with a table. I hope...- ausMuenchen
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
