Home > Cannot Open > Cannot Open A Form Whose Underlying Query Contains A User-defined

Cannot Open A Form Whose Underlying Query Contains A User-defined

Join Us! *Tek-Tips's functionality depends on members receiving e-mail. Im certainly very puzzled by this Thanks for your help "Allen Browne" wrote: > The underlying question is: What is causing this calculating? > > Examples of things you might look That can trigger endless "Calculating", esp. the effect I am trying to create is: on the main form, display only those records from the main table where there is a matching entry in the subform, eg if http://scriptkeeper.net/cannot-open/cannot-open-a-form-whose-underlying-query.html

All rights reserved. You may get a better answer to your question by starting a new discussion. Join Now Hello everyone. When I run the report an error occurs and the following message appears: Cannot open a form whose underlying query contains a user-defined function that attempts to set or get the

Please see the following MS article for repair: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q279334 0 LVL 54 Overall: Level 54 MS Access 53 Message Expert Comment by:nico50382002-11-28 Comment Utility Permalink(# a7509647) No comment has been Allen Browne, Sep 27, 2004 #2 Advertisements Guest Guest Hi, thanks for the reply! More About Us... Could any of these be > referring to a function or property that could trigger the message. > > -- > Allen Browne - Microsoft MVP.

Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. But if i try to move to the next record before >> > it >> > has finished "calculating", I get an error message: >> > "cannot open a form whose If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone.

Perth, Western Australia. klar View Public Profile Find More Posts by klar 01-03-2012, 02:44 PM #2 Galaxiom Super Moderator Join Date: Jan 2009 Location: NSW Australia Posts: 10,284 Thanks: IE? Registration on or use of this site constitutes acceptance of our Privacy Policy.

Criteria = "ID=" & ID rather than Criteria = "ID=" + ID The addition operation will add numbers if the first section is numeric. Close this window and log in. The record source of the subform is one of the 2 grouping queries used above- could this be the problem? It's fallen upon me to continue to keep them running.  Last year I split the databases, and started rolling out Access 2003 to clients as problems with 2k cropped up or

Source: http://office.microsoft.com/en-us/access-help/HV080760122.aspx[^] We need more details (query syntax) to help you. The problem seems to only happen if 2 people are in the form at the same time. Tags (Show All 5 Tags): Microsoft AccessReview it: (22) Microsoft Windows 7 ProReview it: (704) Microsoft Windows Server 2012 R2Review it: (61) Microsoft Office 2010 StandardReview it: (14) Microsoft Office Access I've compacted and repaired both the front ends and back ends, uninstalled Office 2010, re-installed Access 2003, repaired both installs, installed them in different orders, updated them in different orders, and

Advertisements Latest Threads Sony PlayStation 4 Pro review Becky posted Nov 7, 2016 at 7:21 PM What Were These Doing In Malvern, Worcestershire? weblink General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Ask a Question All Questions All Unanswered FAQ I did have another issue with Fonts (See here for notes on the subject: http://community.spiceworks.com/topic/586335-access-2003-settings-installation-issue), but I seemed to have fixed that specific issue by deleting all extra fonts on the system When i click through the >> > records >> > using the record navigator buttons, it says "calculating" in the >> > status >> > bar >> > at the bottom

when they are used as input to further queries. therefore it allows the user to see the rows where they arediferent and update the main table to the new value if they choose. The function which is used inside the query actually calls another query within. navigate here Top Can't open a form whose underlying query contains a user-defined function by td » Fri, 02 Mar 2001 16:39:48 Hi Miguel Would need to see the query which the form

Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. The code is below. If so, it may be this bug: Image Control may cause a GPF when browsing between records at: http://www.mvps.org/access/bugs/bugs0044.htm 2) Are you using conditional formatting?

Email Reset Password Cancel Need to recover your Spiceworks IT Desktop password?

Join the community Back I agree Powerful tools you need, all for free. RE: Odd error message "can't open a form whose query..." psemianonymous (Programmer) 24 Jan 06 22:50 I've never seen it, my bet is the ODBC table links are causing the weird Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "confused" <> wrote in message news:... > > I have a form with a linked Cannot open a form whose underlying query contains a user-defined function that attempts to set or get the form's RecordsetClone property. (Error 3252) This error can occur in Microsoft Access if

multipagecontrol tabindex 9. Make your opinion known. Nothing has changed in terms of the database files themselves, the front ends are the same ones they've been using for 6 months now. his comment is here Is the application split so that each user has their own copy of the front end?

No, create an account now. Register now while it's still free! I'm not getting any errors like you describe, just the error I described in the question. 0 LVL 1 Overall: Level 1 Message Expert Comment by:nnaxor2002-09-25 Comment Utility Permalink(# a7302568) Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc.

Permalink Posted 17-Sep-12 11:25am Maciej Los239.8K Add a Solution Add your solution here B I U S small BIG code Plain TextC++CSSC#Delphi / PascalF#HTML / XML / ASPJavaJavascriptObjective-CSQLSwiftPerlPHPPythonVBXMLvar < > Alternatively, drop your function and build the same functionality directly in the query - that should be doable. Member Login Remember Me Forgot your password? Sign up now!

By creating an account, you're agreeing to our Terms of Use, Privacy Policy and to receive emails from Spiceworks. tom, Jun 7, 2004, in forum: Microsoft Access Forms Replies: 0 Views: 247 tom Jun 7, 2004 How to Append Clone Rec?