Search results

Back again.... To this... Validation rule accepts <=len(20) in the arguement. (which doesn't help) Tried <=len("????????????????????") doesn't work. Tried <=len("ZZZZZZZZZZZZZZZZZZZZ") doesn't work. I am figuring since the form accepts len as an argument, there must be a way to restrict...

... Using it for excel. I was formatting columns and wanted to loop through them instead of repeated code for each column... Anyhow, I cracked it. I put it here because vba applies to both excel and access so I thought you guys might have an answer... but I solved my own riddle. Thanks,

Found it. MyChar = Chr(65) ' Returns A. MyChar = Chr(97) ' Returns a. MyChar = Chr(62) ' Returns >. MyChar = Chr(37) ' Returns %.

My ideal so far... Char 65-90 = A-Z So now I just need to loop 65 - 90 ... Last piece is how to assign ascii value to a variable. Counter = 65 do while counter <= 90 MyVar = ascii(65) value ' would be "A" which is what I need.... Counter = Counter + 1 Loop

To do a loop ... Char = "A" Do while Char < "L" Char = ".... next Char ... A , B , C , D , E ... so fourth" Loop Char reserved word... I just wanna know how to increment a string single letter. Is it possible.? Ascii maybe...?? Simpler code maybe.

If I understand. Just make a seperate form they can goto from the main switchboard to add 'supervisors' / 'initials'. and have them select the 'supervisors' / 'initials' before you enable them to go to the data entry form and use the selected 'supervisors' / 'initials' as the default / or...

Easier yet... Make this particular 'user / employee' unbound or assign the values from a query. Use a sperate control... Then assign this value as default in the recordset being updated. Easy solution...?

... Bro... Why not just lock the fieldss you don't want overwritten, based on your explanation, and the fact that this is a simple db... Why such code.... I mean. Lock the fields...? No? If not explain better when and why you need fields locked.... If certain users need to be able to edit...

Well. Zip your file to be attached silly... I will continue looking at the code. and reply if I get an idea.

Well... Using ? in input mask doesn't help much on a combo box. They want autofill on keypress. If I use mask. then it doesn't autofill... Example. S/P with mask, after s keypress now I get nothing... I tried <???????????????????? I mean, all I want is a len check in the validation line...

Good point but... >L0L 0L0 is postal code.... I can't use L's because this forces entry to be 20 in length.... In telephone number ... 9's are not required and 0's are... So if someone can kindly tell me what character place holder is used for non required letters, this would...

I have 40 combo boxes .... Basically an array of controls... anyhow to the point... I want max length of 20 characters... These controls are unbound. So setting char length in table can not be used. Validation text / rule should provide my solution somehow. I have tried a few things, and...

Nice. Where would you call this sub...??? Codes seems real nice, and could come in handy.

Found answer... record source = 1 Running sum = over all = Problem solves. thanks.

Need numbering of details. 1- 2- 3- 4- for each detail line. I did a search can't find answer. Been a long day, can I get a fast easy answer. My old job I had this code, dumb me didn't keep my best secrets... lol they didn't let me keep templates.... on the reports... details... in case it...

Thanks... BTW. len function still returned six. so I had to do right(variable.text,1) <> "_" as well. but point is, I did mannage to verify data and length on second keystroke as you said the default changed. and that was on keydown, on change on .text it gave me the first keystroke....

Well... Updating one at a time is not an option.... I am currently working on something that would apprently solve your problem. I am working on unbound t-boxes. Everything is populated vb code... So in this sense... no updating would be done until they commit all record changes. The # of...

thanks. I am home now, I will test this monday morning.

no... could this be because I have a mask too...? What a headache. Both give "000000"