Recent content by isethjmave

Hi Trevor G, The problem is that i dont know what will the calculations the user will be performing. It would be easier (i think) if there would be a spreadhseet control in a form.

Hi, I want to have a spreadsheet type control in a form to be use for data entry and also to perform calculation. Is there a way to do that and save the data afterwards? Thanks.

i dont have any print button. im using the print option in the toolbar or using ctrl + p. the print dialog box pops up, is there way to know when the user clicks ok or cancel?

Hi, Is there a way to get information in the print dialog box (File -> Print)? Like when i click ok or cancel? Or any other way that i will be able to know that the report is sent to printer or being printed. Thanks

Thanks very much. code works perfectly now.

hi vbaInet i change the pattern to ^[1-9][0-9]{1,3}[TBLR]$ and it works perfectly now. thanks very much

Thanks vbaInet the code works fine. The problem i encounter when i enter like 10T it returns false which should be true. When i change the pattern [1-9] to [0-9] then it will accept 0T which it shouldnt. Any suggestion on what to do? Thanks very much

hi vbaInet, That's the rules. Thanks.

Valid entries will be between [1 to 100][T] Like 1T, 10T, 20T. Not accepted 0T, 01T, 1A, 1TB, any special characters before T like %T and any character after T like 1Te are not accepted. Numbers entered corresponds to column numbers, the letter corresponds to a certain code but it should only...

Hi, Need your help. I'm trying to create a validation rule for a textfield that will have the following pattern [Number Except 0][T]. I tried this rule "*[0-9][T]" the problem with this is that it will accept 0T. But when i tried to changed it to "*[1-9][T]" the problem is that if you enter...

Hi Everyone, I'm an intermediate user of access. i want to learn more. Cheers