Results 1 to 2 of 2
  1. #1
    Delfina is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Jan 2019
    Location
    Bartlesville OK
    Posts
    47

    Can't type in field


    Could someone tell me why I can't type in the field on the Project Data page and what I need to do to fix it? I would really appreciate it. I figure it is because I made the form from a query instead of a table. I don't know that for sure. The field in yellow is the only one that I want to be able to type into to fill the field in the project table. Other than that, the dropdown box will be the only working part on that page. The others will be filled in from imports into the tables.
    Attached Files Attached Files

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    see http://allenbrowne.com/ser-61.html
    not sure which would be most applicable, but it just might be one that I've never seen before - a form based on multiple tables with no joins between them (thus a Cartesian query)
    EDIT:
    It's not the fact that it's based on a query, it's because of the query design. If you can't join those tables on related fields, then you're missing something (such as a junction table) or your tables design is wrong. I'm seeing lack of normalization as well, which will probably only continue to bite you. Multiple customer fields in a projects table would be one example.
    Last edited by Micron; 02-21-2019 at 07:29 PM. Reason: added info
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 10-03-2018, 02:01 PM
  2. Field Type
    By Perfac in forum Queries
    Replies: 8
    Last Post: 07-05-2018, 11:08 AM
  3. Replies: 6
    Last Post: 01-13-2017, 08:54 AM
  4. Field Type of type-Double/Float
    By McArthurGDM in forum Access
    Replies: 3
    Last Post: 12-10-2014, 01:54 PM
  5. Replies: 4
    Last Post: 12-01-2010, 01:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums