Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-19-2008, 08:26 AM   #1
dai_lo
Registered User
 
Join Date: Jan 2008
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
dai_lo is on a distinguished road
code in a query disappear after executing some objects

Hi,

I built a database which consists of many queries.

I notice some query object come empty after I executing some queries.

anyone know to how prevent this happen?

thanks

dai_lo is offline   Reply With Quote
Old 10-19-2008, 10:17 AM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,529
Thanks: 594
Thanked 1,007 Times in 949 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: code in a query disappear after executing some objects

This is normal, the query designer interface can allow you to include unnecessary items in your query which are removed when the query is run.
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|  
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query filtering criteria by code help KevinSlater Queries 4 09-05-2008 04:27 AM
Error Opening a Query With Criteria Through Code LaBam Modules & VBA 2 06-27-2006 01:53 AM
Linking form and subform problem subbu Forms 3 12-06-2004 02:30 PM
Crosstable query returns too many records Palsam Queries 2 03-09-2004 11:41 AM
Writing Code to Reference All Objects on a Form/Section akt01 Forms 4 06-19-2003 11:49 AM




All times are GMT -8. The time now is 09:49 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World