Results 1 to 6 of 6
  1. #1
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114

    A table won't open without parameters being entered?

    I'm fine tuning the database I created last year. I'm clicking on a table containing information on our vendors. And parameter windows appear. I didn't set any table with parameters when I set up the database; within the database, I've included a README doc for any and all changes done to tables, queries, forms or reports in the DB.



    How do I get this action to stop? Or do I have to create the table again?

    Rebecca

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Can you post a copy or is it private/confidential?

  3. #3
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114
    Some of it is P&C, but here's the bare bones:

    Click image for larger version. 

Name:	Step 1.png 
Views:	9 
Size:	50.5 KB 
ID:	25615

    This set up isn't even for this table and in the ACT/InA table, there is not a query parameter set for this either so I don't know what is going on.

    Thank you for any assistance you can give me.

    Rebecca

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Do you have a macro that runs on Start up?
    Have you tried Compact and Repair?

    I know Access doesn't like names with special characters unless enclosed in [ and ].

  5. #5
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114
    The compact and repair did not work. And there is no field in this table labeled Component Status.

  6. #6
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Do you have backups?
    You might try the v-Tools utility to see if you can find that text somewhere in your code. It has a deep search option to check all.

    I just noticed, after posting, that this has been marked solved???
    And the solution/answer is??

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

Similar Threads

  1. Replies: 2
    Last Post: 03-15-2016, 08:49 AM
  2. Replies: 1
    Last Post: 07-07-2014, 09:32 AM
  3. Replies: 2
    Last Post: 09-03-2013, 05:12 PM
  4. Open Report with Date Parameters
    By Gee in forum Access
    Replies: 12
    Last Post: 02-27-2013, 03:17 PM
  5. Open form from parameters
    By funkygoorilla in forum Forms
    Replies: 5
    Last Post: 01-01-2012, 09:17 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