Recent content by Greycon

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...

Kevin, Thank you. My mind is allready spinning out ways to use this. Greycon

Skip, Sorry for the missing information. Yes I have locked and protected the workbook, and sheets and Macros. I will try including drawingobjects in the command tomorrow. I probely should have put this question in the VBA forum. But I did not know if it was a VBA issue, or a sheet issue...

Skip, thank you for the reply, I thought I did that. Should this not do it? Sheets("Inventory ZB").Protect ("ABC_Weekly"), userinterfaceonly:=True They do need to enter information into the unlocked cells. Thank You again, Greycon

kpetursson, How would you go about naming a range YesNo? I can do it via macro, but what if you are not running one. Is this ability in XP? Very Interested in this. Thanks, Greycon

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...

Loonah, Thank You very much! I was looking just to add the PasswordChar Property, but the API that they have does just what I wanted. Kind of annoyed that I can't follow the code. But that's what learning is all about. Beat your head against something until it makes sense. right? Thanks...

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...

LOL 11 min. If I could get my people to work that fast, I would not be working at home on sunday. Thanks again.

Wow that was quick! yes I am using VBA in excell. been working on this project for a week now and my mind is fried. string(1) = Left(mystring, 1) is exactly what I was looking for. Thanks Greycon

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...