Search results

  1. M

    Memo field has maximum of 255 characters

    Is it possible to increase the size of a memo field to more than 255 characters:eek: Any suggestions would be appreciated... John
  2. M

    Is it possible to copy and paste specific fields into a new table with Primary Key?

    I have a table and I want to copy the Primary key, last name and first name fields but the primary key never copies over to the new table. All I get is a sequentially numbered list where I want to maintain the original Primary key IDs. Is it possible to paste the primary key field into the new...
  3. M

    Cannnot modify row height in design view

    Hello everyone I'e been making reports and when I print them I can't get them to fit on one page only because Access is not allowing me to modify the row height by clicking on the detail band (with the double edged arrow) and moving it up or down. It stops where it wants to stop, not where I...
  4. M

    Question concerning Lookup Columns

    Is it possible to color code the entries in a lookup column? I attemted to modify the format after a lookup column was already created but it didn't change the color of the entries in the lookup column. I used: "Male "[Red];" Female "[Green] in the format section (in design view) after I had...
  5. M

    Cannot add record to a table because related record is not recognized

    Hi everyone, I am using Access 2007 and I have a database with 2 tables. The original table has a primary key field designated. I have a relationship between that table and a second table and that relationship has "enforce referential integrity" checked. In the secondary table the field that...
  6. M

    Question about a table and associated form

    I am using Access 2007 and I just updated a table with a new record and the record isn't showing up in an associated form. Can anyone give me any suggestion on how to troubleshoot this??:confused: Any suggestions would be appreciated...
  7. M

    A record with Primary Key created in table but doesn't show up in form

    Hi, I am using Acess 2007 and I have a database with 3 tables and 1 form. When I created a new record in the master table the record isn't showing up in the other forms. I have also created relationships for the primary key between all of the tables but when I add the primary key to the...
  8. M

    Yes/No Field making me crazy

    I posted this in the wrong thread yesterday I just started learning Access and I have created a database with 53 records, 3 tables and 1 Split form. I creared a new yes/no field and I am attempting to display "Completed" in green for yes and "Not Completed" in red for no. I used the correct...
  9. M

    Yes/No Field driving me crazy

    I just started learning Access and I have created a database with 53 records, 3 tables and 1 Split form. I creared a new yes/no field and I am attempting to display "Completed" in green for yes and "Not Completed" in red for no. I used the correct code in the format field: "Not Completed...
Back
Top Bottom