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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
copy selection of table to excell spreadsheet
Hello All, I am just starting to learn VBA for access, after being comfortable in Excel. Glad to see that Microsoft stuck with there format of "works on one, but not the other" style. First question, is how do I copy a selection of a table. Via. VBA ie.. I run a query, and I want...- Greycon
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
locking labels in excell XP
I have a excell spreadsheet with labels in it. The users are able to change the label text, even though it is locked, the worksheet is looked, and the workbook is locked. I disabled the labels, and they can not change them. But I don't like how it changes the lettering to grey. How can I...- Greycon
- Thread
- Replies: 4
- Forum: Microsoft: Office
-
PasswordChar Property
Ok another I know enough to be dangerous question. I have set up my password check input box. But I can't figure out how to get the PasswordChar Property to work. Any possible help? Dim Message, Title, Default, MyValue Message = "Please Enter Your Password. Case Sensitive" Title = "Security...- Greycon
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
Simple return of a portion of a string
Hello, I am looking for a simple way to return a portion of a variable. ie mystring = string(1) to make mystring = s Is there a way to do this? I thought instr or len might work. Obviously the way I tried did not work. Should be a simple way, just can't think of it. Don't think I should...- Greycon
- Thread
- Replies: 14
- Forum: Microsoft: Office
