help with parameter value queries - Microsoft Access / VBA

Christine

I am struggling to learn to use Access almost on my own, and have
written a query that needs to have a parameter. The query I wrote
includes [Please enter facility code] in the Criteria of the design
view, under the column that would contain the Facility Code. When I
run the query, the 'enter parameter value' box comes up twice,
rquiring the parameter to be entered twice before the information is
displayed. I hope I'm explaining this correctly. Can someone direct me
to a solution to this small problem? Thanks!

Nov 12 '05 #1

Subscribe Reply

4161

Mike Krous

Most likely the problem is within the way you constructed your query.
Please post the query so someone can help you further.

Mike Krous
"Christine" <le********@com cast.net> wrote in message
news:76******** *************** ***@posting.goo gle.com...

I am struggling to learn to use Access almost on my own, and have
written a query that needs to have a parameter. The query I wrote
includes [Please enter facility code] in the Criteria of the design
view, under the column that would contain the Facility Code. When I
run the query, the 'enter parameter value' box comes up twice,
rquiring the parameter to be entered twice before the information is
displayed. I hope I'm explaining this correctly. Can someone direct me
to a solution to this small problem? Thanks!

Nov 12 '05 #2

MGFoster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I'm assuming your problem is that you don't want the parameter box to
display twice, correct? If you had opened the query and then done a
sort or filter on the results and then saved/closed the query it will
"remember" it's last sort/filter state. Sometimes a sort/filter will
require the parameters anew. To fix this open the query, in results
view, & right-click & select Remove Sort/Filters, then close the
query. This may solve the problem.

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP8efDIechKq OuFEgEQKq+QCg8d IvYBuTqYiD3h1bE HHdbxd/JRIAn2NI
nqDee8Q2YlmjTpJ 0T4LiFjwa
=ms11
-----END PGP SIGNATURE-----

Christine wrote:

I am struggling to learn to use Access almost on my own, and have
written a query that needs to have a parameter. The query I wrote
includes [Please enter facility code] in the Criteria of the design
view, under the column that would contain the Facility Code. When I
run the query, the 'enter parameter value' box comes up twice,
rquiring the parameter to be entered twice before the information is
displayed. I hope I'm explaining this correctly. Can someone direct me
to a solution to this small problem? Thanks!

Nov 12 '05 #3

Similar topics

5501

Help with Form_Load calls and Enter Parameter Value issues

by: Phil IU Guy | last post by:

I am having 2 issues, both acting very randomly, and for the most part I dont get this message on most computers, but I have had a couple computers get either issue 1, or issue 2. Issue #1: I have a module that has a function that starts as: Function setFormColors(frm As Form) This function takes a form and looks through its objects and if certain object names meet a certain critera (such as start with lblBD) do a certain action (like...

Microsoft Access / VBA

4354

Recordset to update queries - help!

by: Dom Boyce | last post by:

Hi First up, I am using MS Access 2002. I have a database which records analyst rating changes for a list of companies on a daily basis. Unfortunately, the database has been set up (by my predecessor, I hasten to add) so that each day it creates a copy of the record for each company, changes the date to today's date, and prompts the user for any changes of ratings on that day. The resulting data table grows by approx 600 records per...

Microsoft Access / VBA

1497

help with parameter queries - code added

by: Christine Brandel | last post by:

The code for the query I have written is: SELECT .,.,.,. FROM dbo_census WHERE (((.)=))); That code results in the parameter value request being made twice before the information I want shows up in the datasheet view.

Microsoft Access / VBA

2200

Help with Queries

by: Steve Patrick | last post by:

Hi All You guys are my last hope, despite spending money on books and hours reading them I still can not achieve the results I need. I have designed a database in Access 2000 based on 1 table, all has gone very well with one exception. The table is based on applications made by potential customers looking to buy franchise rights to particular locations and as part of the process they are asked to list their preferred locations 1 to 4....

Microsoft Access / VBA

1865

Help with parameterized queries

by: deko | last post by:

Is it possible to build a parameterized query from another parameterized query? I've tried two variations of this and can't seem to get it to work (using DAO). Any suggestions welcome! I want to delete linked documents - but only if they are not linked to other entities outside of the category being deleted

Microsoft Access / VBA

5772

Optional Parameter for Querydef with Default Built In

by: Marc DVer | last post by:

I am trying to create a query that can be loaded as a querydef object but not having to assign values to the parameters if I don't want to. Normally when using a parameter query in VBA my code would go something like this: dim qry as dao.querydef set qry = currentdb.querydefs("myquery") qry.parameters("Par1") = "blah"

Microsoft Access / VBA

1516

SQL script help

by: isaac2004 | last post by:

hi i have a page that inclued a SQL statement that takes a user input from a form and displays the request from the database. every time i try to open the page i get an error message that says Data type mismatch in criteria expression where i open the record set. usually this means that you have something as a number when it shouldnt be but i dont know what is wrong. \ here is my code

ASP / Active Server Pages

2185

HELP! VB SQL Design Parameter PROBLEMS Arr

by: Billie Boy | last post by:

Hi to all. I’m new here and am coming to you from Melbourne Australia. So a big HELLO 2 ALL. Now I am encountering an annoying problem in the SQL builder of the copy of VB.6 that I am using at home. My problem is that it’s driving me NUTS NUTS NUTS. I am connected to a data connection within my computer that accesses tables & views from a MS Access file.

Visual Basic 4 / 5 / 6

4096

Help again

by: Darth Ferret | last post by:

This thing is about to drive me crazy. I have about 50 queries in the AS400 that I need to put on a menu. Once I conquer this I have a bunch more rpg reports that I need to pass a date to. In the AS400 I have a stored procedure (SPRUNQRY) that runs the RUNQRY command with the name of the query as a parameter. In the AS400 I would type "RUNQRY SUNTR401A" on a command line to run this query. My connection is opening, and I can run some...

Visual Basic .NET

9456

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10034

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9843

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9713

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8713

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7248

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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6534

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5142

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

2666

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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General