Hi all,
I use Access 2007 and have come across this error a number of times.
I have two tables (customer information) which should contain -
ideally - the same data.
I create a query to compare them based on customer code. The fields
are something like:
Customer code
Balance - Table 1
Balance - Table 2
Difference (the difference of the 2 fields above)
and so on.
The query runs fine, so I guess there is no error in the expressions.
However, if I try to export to Excel, I get the message "Enter
parameter value", as though Access did not understand one of the
values in the expressions; however, the query did run fine. Also, if I
export to csv, I don't get this message.
Any idea? I am an Access novice, but this really makes no sense to me :
( 3 5448
When Access pops up the dialog asking you for the parameter, what is the
name it asks you for?
It may help if you post the SQL statement for the query too.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<my********@goo glemail.comwrot e in message
news:11******** *************@2 2g2000hsm.googl egroups.com...
Hi all,
I use Access 2007 and have come across this error a number of times.
I have two tables (customer information) which should contain -
ideally - the same data.
I create a query to compare them based on customer code. The fields
are something like:
Customer code
Balance - Table 1
Balance - Table 2
Difference (the difference of the 2 fields above)
and so on.
The query runs fine, so I guess there is no error in the expressions.
However, if I try to export to Excel, I get the message "Enter
parameter value", as though Access did not understand one of the
values in the expressions; however, the query did run fine. Also, if I
export to csv, I don't get this message.
Any idea? I am an Access novice, but this really makes no sense to me
On 31 Oct, 11:56, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
When Access pops up the dialog asking you for the parameter, what is the
name it asks you for?
Access truncates the names in the window, so I cannot be sure. I tried
to enlarge the window, but I can't.
It may help if you post the SQL statement for the query too.
The SQL code is very long. I'll try creating a query with fewer fields
and, if the problem persists, post the SQL code for that. Thanks!
Btw, I still don't understand why I only get this message when
exporting and not when running the query.
If you saved the query as Query1, you may be able to get Access to tell you
about the parameters by opening the Immediate Window (Ctrl+G) and entering
lines like this:
? Currentdb.Query Defs("MyQuery") .Parameters.Cou nt
? Currentdb.Query Defs("MyQuery") .Parameters(0). Name
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<my********@goo glemail.comwrot e in message
news:11******** **************@ k79g2000hse.goo glegroups.com.. .
On 31 Oct, 11:56, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
>When Access pops up the dialog asking you for the parameter, what is the name it asks you for?
Access truncates the names in the window, so I cannot be sure. I tried
to enlarge the window, but I can't.
>It may help if you post the SQL statement for the query too.
The SQL code is very long. I'll try creating a query with fewer fields
and, if the problem persists, post the SQL code for that. Thanks!
Btw, I still don't understand why I only get this message when
exporting and not when running the query. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Simon Wigzell |
last post by:
Is there a way to prevent a form submitting when you press enter on a text
field? Some people press enter when they finish typing in a text field out
of habit I guess unconcsciously thinking it will take them to the next
field. Instead it submits the form and this causes all kinds of problems in
my case. Any javascript solution?
|
by: ajikoe |
last post by:
Hello,
I used Visual C# Standard Edition.
I want to comment my program using xml commentary method,
I don't know why if I use value and example tag, it is not working / showed in the html result.
for example I have Property
///<value>this is in description</value>
///<example>this is in Example</example>
public int A{
|
by: jhonz |
last post by:
I have come across a strange circumstance. I have user controls with
dropdownlists that interact fine during times where the web server has
minimal load. But once things pick up and postbacks take longer, my
code behind will error out since I expect
"ddlSample.SelectedItem.Value" to have a value for a control that
exist. But sometimes it is set to "Nothing". I do think this comes
about when the user is a 'quick clicker' and clicks...
|
by: matty |
last post by:
Hi,
I recently got very confused (well that's my life) about the
"undefined" value. I looked in the FAQ and didn't see anything about
it. On http://www.webreference.com/programming/javascript/gr/column9/
they say:
<snip>
The undefined property
A relatively recent addition to JavaScript is the undefined property.
|
by: neo |
last post by:
I want to make one function for pass "n Parameter" with respective
functionality, "..." use for parameter but I am not understand how
use "..." in function and what is the technical name of this
technique?
Tell me some links for study "n Parameters" techniques in C++.
Regards,
-aims
| |
by: yourmallu |
last post by:
Hi Friends,
All we are knowing that we can get the element by document.getelementbyid("default_txtname").value.
But If it is not on that page if i am taking header.ascx and placing text box there than i can get value of that control by document.getelementbyid("header1_txtname").value this is works fine in the I.E 6 but the mozilla gives error for it in javascript console
Error is like this:
Error:...
|
by: Nemisis |
last post by:
Hi,
Is it possible to pass in an object and parameter into a function and
return it as a string.
i.e.
To make a call to the function i would put the following
Dim str as String = MyTestFunction(myObject.Parameter)
|
by: Zytan |
last post by:
I can handle DoubleClick on a ListBox to respond, not when the
selection changes, but when you double click one to invoke an action.
This is the same as using the keys to move the selection, then
pressing Enter. But, of course, DoubleClick doesn't automatically
handle that.
Is there any way to handle ALL standard UI at once, rather than
checking for DoubleClick and for Enter press manually?
Zytan
|
by: Simon Verona |
last post by:
Sorry for the repost, but this group seems to be more "active" than the
group that I posted my question, and it's probably as valid here as there!
I have a usercontrol, which contains a textbox (as well as other controls).
The textbox is set for multiline, so it *should* accept an Enter Key to move
down to the next line.
However, I'm finding that if I put the control onto a form which has a
default Accept button set, then pressing...
|
by: adigga1 |
last post by:
Hello EveryOne,
I have a situation with a Form running an event; It works fine when it calls or manipulates number values; but when I put a character within the numbers or use alpha-numeric values, I get this error "enter parameter value" when i press my click action button with the alphanumeric value as the problem..
Please assist, I searched the entire forum and the net for answers, but nothin.
A......
I apologize for the...
|
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...
| |
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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...
|
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();...
|
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...
| |
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 we have to send another system
|
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...
| |