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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Passing Labels as Arguments
Um...rather embarassing... Just found out that I'd been using textBoxes and not labels. That would explain it. Sorry :$- GsyDonkey
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Passing Labels as Arguments
Well, there is that....ooops! I'd imagine that's why access doesn't support it - knowing Microsoft. Only trouble is that there are other methods I've made within the Interaction class which have optional label arguments (together with their strings), whereby the label is set based on a...- GsyDonkey
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Passing Labels as Arguments
Hello, I'm trying to pass a label as an argument as I have to correct a lot of labels on an access form. The method is called thus: Interaction.setLbl Me.partyInfoLabel, partyName (btw - partyInfoLabel is a label and partyName is a string) and the method itself looks like this: Sub...- GsyDonkey
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Populate listbox with all .xls filenames in a specified folder?
This code is a little more cunning, and easier to use. rootPath is just used in order to use the method in conjunction with the 'OnClick' method of the listbox... Dim rootPath as string Private Sub UserForm_Activate() rootPath = "C:\Dropbox\" dirName = Dir(rootPath &...- GsyDonkey
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
