Results 1 to 3 of 3
  1. #1
    accessvuri is offline Novice
    Windows 2K Access 2003
    Join Date
    Apr 2011
    Posts
    2

    Access Environment change Problem

    Hi.
    I am having access 2003 with oracle 10g as database.
    I have two different environment.I have done some fixes in application and then i placed mdb file or mde file to different environment it is behaving strangly and giving the error 3077(expression missing) when i am trying to open a form and in the reports also it is not showing totals and sub-totals at teh bottom but it was working fine in the environment in which i have done fixes.can anybody know the reason behind this or have faced similar kind of problem.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Please describe the changes in the environment.
    What specifically changed?
    What exactly are the problems?
    What testing was done?

  3. #3
    accessvuri is offline Novice
    Windows 2K Access 2003
    Join Date
    Apr 2011
    Posts
    2
    I don't have the access of other environment.However there is no change in the environment.
    Not much changes in the code just added one function which is calling an oracle stored procedure(it is also newly written) to delete particular records and for the report some field Format in the property is changed to Standard and few alignment changes.
    The problem is while opening any record on the particular form it is showing error 3077.but fHandleApostrophe function is also written in code and any way no Apostrophe in data.and for the reports it is not showing anything in the page footer.
    The testing is done to check the report whether the totals are coming correctly but Total itself is not shown.

    but all the fixes are working in other environment

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

Similar Threads

  1. Change Access 2003 mdb workgroup using Access 2010
    By metsmaniac in forum Security
    Replies: 6
    Last Post: 04-06-2012, 08:56 PM
  2. Access 2000 change ODBC query
    By btamulis in forum Queries
    Replies: 1
    Last Post: 02-07-2011, 11:00 AM
  3. Access change my query and then can't open it
    By weekend00 in forum Queries
    Replies: 3
    Last Post: 10-15-2010, 01:35 AM
  4. Replies: 13
    Last Post: 05-18-2010, 01:12 PM
  5. Change to Form Closes Access
    By jbhjm in forum Forms
    Replies: 5
    Last Post: 04-22-2009, 01:04 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