| Thread | Last Post | Replies |
|
| Validation Rule - must have at least 1 number and 1 letter | 25 Apr 2005 14:18 GMT | 3 |
Hi, i have a table where passwords are kept and i need a vaidation rule that means the password must have at least one letter and one number. Also woud it be easier to have the coding on a form or in the validation option in the table design (i would prefer not to have a form for ...
|
| Input mask for height | 25 Apr 2005 12:26 GMT | 1 |
I want to have a table with imperial heights stored (eg 5'10") but when I create my inpout mask with 9'##" ( 9"' "##"") it just displays as 5'10. Is there any way to have the inches symbol displayed as well?
|
| too many fields defined access table | 25 Apr 2005 05:46 GMT | 4 |
I have "inherited" a database that has the main table maxed at 256 field defined. Any suggestions on how to clean this mess up easily? Thanks
|
| too many fields defined | 25 Apr 2005 03:14 GMT | 3 |
Access XP - I am trying to change the data format in a table from Yes/No to text. Whenever I attempt to save the changes I receive an error code 3190 indicating Too Many Fields Defined. When I tried to bypass the problem by creating a new field with the corrected data form, I ...
|
| How do I add two table values and publish to a third table? | 25 Apr 2005 00:59 GMT | 5 |
I have value to add two values from two tables and publish results to a third table. ie: (v1 in table A) + (v2 in table B) = (v3 in table C)
|
| Relationships?? | 24 Apr 2005 18:14 GMT | 3 |
1. I have a one-to-many relationship. But everytime i go back to the relationship window Access automatically creates another relationship using the same table on the one-side of the relationship and then adds a "_1" to the end of the table name (making it different table in the ...
|
| Date input | 24 Apr 2005 16:53 GMT | 1 |
Im looking for the Input mask that allows for dates in 2000. Thanks
|
| How can I stop items in a combo box automatically sorting into al. | 24 Apr 2005 16:51 GMT | 5 |
I want to create a combo box with, in order, Detached, Semi-detached, Bungalow, Flat, Other but the choices KEEP appearing alphabetically. I would be delighted to hear from someone who knows how the answer.
|
| Rounding numbers | 24 Apr 2005 16:20 GMT | 6 |
can someone help me to round numbers up or down, so if a number is 9. it would go to 9.5 and if a number is 7.8 it will go to 8 any help would be greatly appreciated thank
|
| multiple tables | 24 Apr 2005 15:26 GMT | 4 |
i have a netwok application that read tables in 3 different mdb files. Would it be a good idea for the network load to put all the table in one mdb files instead of three. Best regards,
|
| specific text/number problem | 24 Apr 2005 11:57 GMT | 5 |
i would like to have a number required in a field, but only when a specific text is present in another field of the same table using Access
|
| Can I use an "If" statement in my critera of my query? | 24 Apr 2005 11:53 GMT | 1 |
Can I use an "If" statement in the critera of my query? If so, I am trying to return a value from a table in one column based on the condition of another column? Is this fesible? How do I do it? Thanks
|
| Field for sequence of bits | 24 Apr 2005 07:44 GMT | 1 |
I want to save 192 bit-values in 12 integers. How do I save this information in a field in a table? Can I save it in a text field – and how do I the extract the data in the right format?
|
| Print Query Screen View | 24 Apr 2005 03:19 GMT | 5 |
I have created a query and want to print the entire query window on 11x17 paper? I am trying to show the joins involved with this query so I can take this to my teacher and ask questions about it. The whole query window does not show on the screen and therefore I can't "print ...
|
| Ms Access | 23 Apr 2005 15:06 GMT | 1 |
I have a table where I want to match up product names with a .jpg picture of the product. All the .jpg product picture files are in a folder on my hard drive Using VBA is there any way to read the name of each .jpg file in the folder
|