+ Reply to Thread
Results 1 to 2 of 2

Access Error message trying to access 'Performance' db

  1. #1
    Registered User
    Join Date
    11-25-2015
    Location
    Manitoba
    MS-Off Ver
    2016
    Posts
    36

    Access Error message trying to access 'Performance' db

    Hello everyone
    I am not new to the forum but more new to Access side of the forum
    I have a problem with accessing a database called "performance' when I try to open it under the 'Admin' section to see what the problem could be.
    I also have a report section that others use to retrieve agent details for that performance and that opens up fine but the data updated only till July 21st, 2017. Nothing from now till then displays.
    I assume the 2 problems are related to each other and since the parties at work know I work with Office more than some they asked me to see if I can find the problem. Even though I don't know much about Access I have always been one to want to help others even if I don't know much about what/where the problem is but I look at it as an opportunity to learn.
    When opening the 'Performance' on the Master under Admin it gives me an error message and then when I click ok I gain access to everything.
    Can anyone help an Access rookie out with this problem, and where I may find the problem and or solution? Please remember I am a novice user for Access and you may have to include step by step instructions to help out.\
    The error message I receive is: Syntax error in date in query expression 'CallDate=## And EmployeeNum=".

    So once I get in I located the 'ProductivityQ' and attempted to load it and I get an error message 'The expression you entered as a query parameter produced this error: Microsoft Access cannot find the referenced form 'ReportCard'
    Is there a way I can just repair these so it works?

    My deepest apologies if this is not the correct are to submit my inquiry for assistance

    thank you

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    19,153

    Re: Access Error message trying to access 'Performance' db

    The first step to trying to solve the issue is to show us the code for which you are receiving an error and when you receive the error, click on debug and tell us which line of code is highlighted. That is the starting point but will not necessarily give us all the information we may need. You may need to share the db for a full analysis to determine the causation. Also, make a copy of the db and then do a compact and repair and see if that solves any of your issues. Keep the copy aside as insurance. Good luck.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Access form works with access Viewer but not full version of Access?
    By Shanyn in forum Access Tables & Databases
    Replies: 1
    Last Post: 10-22-2014, 01:14 PM
  2. error message "Microsoft Excel cannot access the file c:\temp\
    By behnam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2013, 09:11 AM
  3. Exporting to Access-Error Message
    By markmerid in forum Excel General
    Replies: 0
    Last Post: 10-11-2006, 11:26 AM
  4. Excel and Access Performance
    By dbarelli in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-27-2006, 08:28 PM
  5. [SOLVED] Optimizing performance of functions that access a database
    By Yarik in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2006, 08:00 PM
  6. File Error - Data May Be Lost message after Access export
    By Northpaw22 in forum Excel General
    Replies: 0
    Last Post: 12-06-2005, 06:06 PM
  7. Exporting to access but no error message
    By Matt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2005, 10:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1