Results 1 to 10 of 10
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Posts
    309
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Basic Field question (Access 2000)

    I now have an Access database in front of me. I don't know much about Access. There is a form. There is a field called permit #. The system forces me to put data in the field but sometimes I don't want data in that field (what it to remain blank). How do I change the field properties so I don't always have to put data in that field (if I choose not to).

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Basic Field question (Access 2000)

    The question is, what is the format of the field, Numeric or Text.
    What error message are you getting when you leave it blank.
    Is it a required field.

    If you can post a demo (less than 100k) we may be able to help you.

    Dave

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Posts
    309
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Basic Field question (Access 2000)

    It is a Text field. File too big to send...

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Basic Field question (Access 2000)

    That field is probably the key and the table design requires a value in this field to create a new record. I would not recommend changing the field properties on that field. A key is an integral part of a database design and there could potentially be many other relationships and objects that depend on it. Maybe you could explain why you want it to be blank so that we could help you find another method to accomplish what you are trying to do.

  5. #5
    3 Star Lounger
    Join Date
    Mar 2001
    Posts
    309
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Basic Field question (Access 2000)

    This system track parking violations. It is at a school. If you have a car at the school, you get a permit #. So when I fill out the form I enter the car permit number in the form. But we also give out tickets to people who are not on campus. Thus they don't have a permit # to enter in the formj.

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Basic Field question (Access 2000)

    What about if you zip the database, is it still too big?
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  7. #7
    3 Star Lounger
    Join Date
    Mar 2001
    Posts
    309
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Basic Field question (Access 2000)

    When I try to enter a ticket for a vehicle that is not registered, we get an error message and the system won't except the record.
    It works great if the violators car is registered with us, but many of our tickets are for unregistered vehicles. I tried to remove the links but then it seemed to import registration information into the violation table. Hope this helps. Bottom line, if a person gets a ticket and doesn't have a permit# and error occurs (The Microsoft Jet database engine cannot find a record in the table 'Driver Information' with key matching field(s) 'Violation Information_License#'). This error message shows when enter infromation in the Notiice of Violation form.
    Attached Files Attached Files

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Basic Field question (Access 2000)

    In the table properties for the field "allow zero length" in the table Violation Information, is set to "No". Change that to "Yes".
    David Grugeon
    Brisbane Australia

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: A safer alternative (Access 2000)

    Do you have permission to modify the table design? It's not a good idea to do it if you don't understand all the ramifications. Rather than changing the design, think about adding a record to your permits table with something like "unregistered" as the permit #. Then instead of leaving the field blank for unregistered vehicles, enter them as unregistered. This is far safer and more durable than what you are proposing to do.
    Charlotte

  10. #10
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Basic Field question (Access 2000)

    This question was posted again in a more detailed form here.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •