Search results

Hey guys! Thank you a lot! It's just that you have to look in so many places before you get something to work....

CazB, I tried it now again and the expression Between 10000 And 19999 Or Between 80000 And 89999 actually works. The problem in my case was that the field was set to Integer! After I have changed it into Long Integer it started working. Thanks for your time!

Yes, I got it to work now using PeterF's suggestion! Thank you all guys for your time!!! There was also another issue with my field. I had it set up as Integer so the max you can input is between -32,767 and 32,767 after I changed it into Long Integer everything started working!

Just tested it and it actually works only for the first "Between 10,000 and 19,999" if I try to input 81,000 I just get an error: "The value you have entered isn't valid for this field"

Hi CazB, the expressions listed above are the expressions I tried and didn't work. I just don't know how to build the expression in order to take into account both ranges at the same time. Thanks

I also would like to thank you RainLover! Any help with the code would be appreciate!

Hi Paul, Thank you for the VBA code. It's working perfectly! Could you just please let me know how would you manage this on the Validation Rule field? It seems to me that the code I entered below is not working. Is there anything wrong with the expression? Or Between 10000 And 19999 Or...

Sorry if I wasn't clear enough. I just need the code to work really. It doesn't matter if it's managed at table level or form level. I was just wondering why some people suggested to input the rule in one place rather than another. But again I just need to get the validation rule right...

Hi Folks, I've been trying to get a field to behave but for some reason I must have done something wrong. For this specific field people should only use numbers between 10,000 and 19,999 or between 80,000 and 89,999. In the validation rule option I input: Or Between 10000 And 19999 Or...

Hi pr2-eugin, thank you for the insight. Would you be able to post a link with the VBA code or point me in the right direction? Thanks, Victor

Hi All, I have a field in my database (I'm using Access 2007) configured as Attachment under the DataType column on DesignView. I was expecting to find an option to limit the attachment size (max 250Kb) and more importantly to limit the filetype you can actually upload. In my specific case only...

Hi Pat, I will make some research on the lookup relationship. Thanks, Victor

Hi Pat, thank you for your response. I have named my pathological DB "little_frankestein.accdb" for the time being!!! Right, there is nothing better than trial and error (and google) and trial and error (and google) and... you know. So this is how I solved my problem: First of all I've just...

Hi All, I have recently started using Access in order to create some standard in the way we keep our records and to move several different excel files into a single database. So I started with the headings on the 2 spreadsheets we use: Supplier + Product Information and then applied the...