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. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Alternatively, drop your function and build the same functionality directly in the query - that should be doable. 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 this contact form

Community Additions Show: Inherited Protected Print Export (0) Print Export (0) Share IN THIS ARTICLE Is this page helpful? These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs). 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? If so, are there any functions used in >> the >> query? >> >> 5) Are there any calculated controls on the form? this contact form

The main form has as its record source: SELECT * FROM [MAIN CBA VALIDATION] WHERE [MAIN CBA VALIDATION].Application in (Select application from [Qry MAIN SIR Sir Without Matching MAIN]); the query This documentation is archived and is not being maintained. Perth, Western Australia. 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

Just click the sign up button to choose a username and then you can ask your own questions on the forum. 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 underlying query Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! The function which is used inside the query actually calls another query within.

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 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 Add Cancel × Insert code Language Apache AppleScript Awk BASH Batchfile C C++ C# CSS ERB HTML Java JavaScript Lua ObjectiveC PHP Perl Text Powershell Python R Ruby Sass Scala SQL

This article illustrates how to dynamically set the RecordSource of a main form to an INNER JOIN statement so that it contains only those records that have a match in the executing Access query containing a user-defined function through VB I am having a problem executing an Access query that contains a user-defined function through a VB application. But even with that issue fixed, I'm still getting the main error message. If you're having a computer problem, ask on our forum for advice.

I would like to know what would be the solution for me to fix this problem. have a peek here Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. Close Box Join Tek-Tips Today! This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL) Top Experts Last 24hrsThis month Richard MacCutchan 130 OriginalGriff 105 Kornfeld

Close this window and log in. http://ecoflashapps.com/cannot-open/cannot-open-user-list-file-etc-vsftpd-user-list.html RE: Odd error message "can't open a form whose query..." jsteph (TechnicalUser) (OP) 24 Jan 06 22:58 Thanks for the responses.There's one other possible explanation, but I checked and the timing Login with LinkedIN Or Log In Locally Email Password Remember Me Forgot Password?Register ENGINEERING.com Eng-Tips Forums Tek-Tips Forums Search Posts Find A Forum Thread Number Find An Expert Resources Jobs Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc.

Join & Ask a Question Need Help in Real-Time? Click Here to join Tek-Tips and talk with other members! These functions are part of the Windows API (Application Programming Interface). http://ecoflashapps.com/cannot-open/cannot-open-user-default-database-login-failed-for-user.html The original one (Company A) was designed back in 1999/2000, with the second one (Company B) a partial clone of the first in 2006.

Your Email Password Forgot your password? By joining you are opting in to receive e-mail. 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)

By creating an account, you're agreeing to our Terms of Use, Privacy Policy and to receive emails from Spiceworks.

Already a member? Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. The problem seems to only happen if 2 people are in the form at the same time. 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

Sign in using Search within: Articles Quick Answers Messages Use my saved content filters home articles Chapters and Sections> Search Latest Articles Latest Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Could it be that when someone changes the data in the main form to be the same as the sub form (effectively removing that record from the ones to be displayed) It takes just 2 minutes to sign up (and it's free!). http://ecoflashapps.com/cannot-open/cannot-open-source-file-x11-xaw-form-h.html I have two Access 2003 Databases (Company A and Company B).

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 Microsoft Access is a very powerful client/server development tool. spikepl View Public Profile Find More Posts by spikepl

01-03-2012, 04:11 PM #6 Galaxiom Super Moderator Join Date: Jan 2009 Location: NSW Australia Posts: 10,284 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 underlying query contains a user-defined fuction

Type mismatch error '13' with user-defined functions 6. "JAN/00" changes to "01/01/00". Is this a problem? Learning resources Microsoft Virtual Academy Channel 9 MSDN Magazine Community Forums Blogs Codeplex Support Self support Programs BizSpark (for startups) Microsoft Imagine (for students) United States (English) Newsletter Privacy & cookies Stay logged in Welcome to PC Review!

Text Quote Post |Replace Attachment Add link Text to display: Where should this link go? Optional Password I have read and agree to the Terms of Service and Privacy Policy Please subscribe me to the CodeProject newsletters Submit your solution! 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 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 underlying query contains a

Then MS Access shuts down because it encountered a problem > Does anyone have any idea what could cause this error message and how to > avoid it? Now, this error message is very sporadic.