Hide Query Output - Microsoft Access / VBA

RICHARD BROMBERG

I am using the following code to run a query:
DoCmd.OpenQuery "qryLocation", acNormal, acEdit

The query works fine, but the results of the query display on the screen.
This was helpful when I was designing/debugging the application, but it is
distracting in the finished application.
Is there some way I can prevent the results from being displayed?

thanks

May 31 '06 #1

Subscribe Reply

4960

Keith Wilby

"RICHARD BROMBERG" <no*****@att.net> wrote in message
news:j4*********************@bgtnsc04-news.ops.worldnet.att.net...

I am using the following code to run a query:
DoCmd.OpenQuery "qryLocation", acNormal, acEdit

The query works fine, but the results of the query display on the screen.
This was helpful when I was designing/debugging the application, but it is
distracting in the finished application.
Is there some way I can prevent the results from being displayed?

thanks

Why are you opening a query if you don't want to view the results? What is
it that you're wanting to achieve?

Keith.
www.keithwilby.com

May 31 '06 #2

RICHARD BROMBERG

Here is the actual code :

DoCmd.OpenQuery "qryLocation", , acNormal, acEdit
DoCmd.TransferSpreadsheet acExport, 8, "qryLocation", stDestination, False

qryLocation selects a set of records based on a City and Street.

What I am doing is creating an Excel spread sheet based on the query.

Thanks
"Keith Wilby" <he**@there.com> wrote in message
news:44**********@glkas0286.greenlnk.net...

"RICHARD BROMBERG" <no*****@att.net> wrote in message
news:j4*********************@bgtnsc04-news.ops.worldnet.att.net...
I am using the following code to run a query:
DoCmd.OpenQuery "qryLocation", acNormal, acEdit

The query works fine, but the results of the query display on the screen. This was helpful when I was designing/debugging the application, but it is distracting in the finished application.
Is there some way I can prevent the results from being displayed?

thanks

Why are you opening a query if you don't want to view the results? What

is it that you're wanting to achieve?

Keith.
www.keithwilby.com

May 31 '06 #3

Rick Wannall

You don't need to open the query to export it. Just don't open it.

May 31 '06 #4

Similar topics

12022

Hide javascript source using php

by: Mark | last post by:

Sorry, I'm a newbie to php ;) I was thinking about using php to write the script file, something like: <script type="text/javascript" src="http://insert_url_here.com/myScript.php"></script> ...

PHP

7148

Hide subquery results in stored procedure

by: John | last post by:

Hi everyone, I have a stored procedure which I use to query a table. The first part of the stored procedure uses a cursor to update a temp table whilst the second part of the query actually...

Microsoft SQL Server

2359

Hide pop-up whilst query results are displayed

by: Mark | last post by:

Hi all, I have a pop-up which has several command buttons which allow users to run a few stored query's. Having the query's displayed as report is not an option due to several reasons. My problem...

Microsoft Access / VBA

1899

How hide code in Database Project query

by: Woody Splawn | last post by:

I have begun to use database projects for performing test and extemporanious queries. That is, I create a new .dtg file and run a query there for testing. Is it possible to hide or block out...

Visual Basic .NET

1271

How to hide output characters on Windows

by: Robert Hilkene | last post by:

Hi there I want to hide output characters in my py program. I found that for Macintosh you implement 4.12 quietconsole -- non-visible stdout output...

Python

8426

Hide Table, Query for use viewing in MS Access

by: skygoh | last post by:

Hi! Currently we need to give user the mde file to run the report. But as mde just can hide form, marco, modules only. Does there have anyway hide the table and query for the user to view the design?...

Microsoft Access / VBA

7487

Hide a few (variable) columns in a GridView

by: =?Utf-8?B?Um9iZXJ0IENoYXBtYW4=?= | last post by:

Hi, I have a GridView with a fixed number of columns being returned from a SQL query and each having a simple template: <asp:TemplateField HeaderText="Allocations"> <edititemtemplate>...

ASP.NET

3171

PHP saying error in mysql syntax, but written my mysql query browser!

by: Flic | last post by:

Hi, I have a basic db that I access with MySQL query browser. Everything seems fine to me but I am using this db as part of a php shopping basket and when I try to add an item I get: Notice:...

PHP

1766

Control.Hide(), How to query for hidden.

by: =?Utf-8?B?SmVzcGVyLCBEZW5tYXJr?= | last post by:

Hi, How can I query a Windows.Form control if it is hidden or not. I would like to toogle Hide/Show and not use a bool as control variable for this but simply query the form werther or not its...

C# / C Sharp

7212

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7098

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7364

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7017

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5026

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

3174

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1524

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

751

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

405

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General