Search results
-
C
Multiple Many to Many and querying
Hopefully I use the right terminology here... Anyhow, I have a database with multiple many to many relationships. At the moment, i'm working with a Product. Each version has multiple categories of add-ons. For example. Item A can have Accessory1 Accessory2 Category1 Category3... -
C
Len function oddity
Amend that. Using Len([field])<Val(10) seems to be the proper formatting. Just using 10 (or any other number) seemed to have access treat it as the string 10 and not the number 10. Using val(10) as to what the length need to be greater or less than straightened it out. -
C
Combobox value and input masks
Well, it appears the data in the phone field is just fine - no errors. But it still remains that whatever is in the combobox when the input mask is used, never matches anything in the table - even when it should. argg! -
C
Len function oddity
It's 2007 and Vista. Found the problem, though. It's a text field, and it's looking at the len value as text as well. It's looking up the values in the same format as A, AA, AB, etc.. 1 10 11 12.... 19 2 20 21 22.... etc. In these cases 7>10. -
C
Len function oddity
it gets better... Len([Phone])<9 returns records with values of 10! WTF is going on? -
C
Len function oddity
If i have a field where all entries should be 10 characters in length (a phone number, no formatting), and the in the table, i set the length of the Phone field to be 10 characters, max, AND I make a query and in the Phone field of the query i say Len([Phone])>7 That should return all records... -
C
Combobox value and input masks
How do they relate? I was under the impression, that input masks had no bearing on anything unless you set it to save the information into your table with the masking information (i.e. the ()'s for area code and - (dash) for a phone number. It just doesn't seem to be working that way. I have a...