I have an <S access databse and try to select the the customer ID to print a statemet report based on the customer ID but am unable to do so
Can anybody help
Thank you
Christoph
Access 2003
3  2504  NeoPa 32,579
Recognized Expert Moderator MVP
I'm sorry Christoph. You will need to explain this a lot better if anyone is to help you. You will need to give relevant information. Unfortunately your screenshots are too small and lacking in detail to help.
Dear Neopa,
Thanks for gettingback to me, sorry about the screenprints. I did not realize the small limit allowed.
Perhaps I can send you a copy of DB in packed in "rar" about 600KB
My problem is to use the criteria looked up by a combo or list box, in my example the CUSTID to the query which filters the records to be printed for invoices not paid in the statement report.
I alsotried the lookup facility in the properties box of the query grid offfered in the query facilities, and it does give me a list of the fields in the table, but not the customer ID, only shows all fileds of the table in the query grid and if I click on any nothing happens
I looked up on the help in Access but they only talk about combo and list boxes to be used in forms and nowhere explaine how the selected value can be transferred into the selection criteria of a query?
I also looked on the web but the answers there are all referring to VBA code or SQL code and I am a basic user and only know how to use the expression builder facility offered.
I will try and pt the screen dumps into a word doc and then zip it, hopefully it will reach you large enogh to make sense
I also try and attach a sample DB the cust id I use to create the ALL unpaid statement is 12
Thank you very much
Regards
Christoph
PS perhaps I can e-mail you directly, but I am not sure if that would compromise the rules? Please let me know
NeoPa 32,579
Recognized Expert Moderator MVP @Christoph
Swapping email details is perfectly acceptable as long as it's done away from the public forum.
I'm not happy to share that information (certainly at this time) though. I find that problems emailed are generally such that would expect me to devote inordinate amounts of my time (not always, but generally). Furthermore, they encourage posters to get away without explaining their problem properly, in the belief that it isn't necessary (as I already have their project available). So I'm not a big fan of that, though I may decide to ask for it sometimes when communication becomes too difficult.
Anyway, for this particular problem, I suggest you review a tutorial I set up a while back ( Example Filtering on a Form) as an introduction to such filtering issues. It comes with an example database (very basic) that you can download and experiment with.
Have a play, then let us know here how you got on and if you need further help.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Andrew James |
last post by:
Gentlemen,
I'm currently in the process of designing a language which will be used
to specify sets of files on a WebDAV server, encoded in a URL. The aims
of the language are to (in no particular order):
* Be concise, aesthetic and easy to type
* Be as similar as possible to existing query languages
* Allow for (nested) boolean operations
* Be cross-platform (so don't include any characters which can't be
used in filenames on *NIX or...
|
by: Bill |
last post by:
I'm trying to create a wizardlike interface using a couple listboxes. I
know you've seen it before. You double click on an item in one listbox and
it "moves" it to the other. I used to approach it with a table and within
the table a yes/no field would determine which box it would be in. An
Update statement would be fired changing it from yes to no or vice versa and
then refreshing the listboxes. This doesn't seem to scale very well as...
|
by: Matthew Clement |
last post by:
I'm currently building a form (called frmReports) to set the criteria
for a query, but I'm having some trouble with syntax and hope that one
of the guru's here can help me achieve what I'm do.
First troublesome variable:
I would like to sort records by numbers of employees (numeric data
type) into three groups: 1-250, 251-2000, and 2000+. Based on three
check-boxes on my form (which we'll call Box1, Box2, and Box3), I've
tried to use...
|
by: Giulio |
last post by:
Hello,
I have a continuous form with a combo box inside. From the combo box I can
pick some values which, by the "after-update" event, change some other combo
box values determined by a query.
(i.e. I have some tree names and depending on what tree I pick on the other
combo box I can pick its fruits and other properties)
Now, mine is a continous form, and whenever I pick a value from the first
combo box the second one correctly shows...
|
by: Megan |
last post by:
Hi-
I'm creating a database of music bands with their cds and songs.
I'm trying to program an SQL statement so that I can enter a string of
text in a textbox, press the 'Enter' key, and have it return the
associated records to a listbox. Once the listbox has the records, I
want to select a record, which will open a form associated with the
selected record in the listbox.
| | |
by: Sally |
last post by:
I have a simple multiselect listbox with a rowsorce of MemberID, MemberName,
SendLetter. SendLetter is a Yes/No field. What is the code to set SendLetter to
Yes when the user selects MemberName? I want to do this as the selections are
being made not after-the-fact after all selections are made.
Thanks!
Sally
|
by: carl.barrett |
last post by:
Hi,
I have a list box that displays 2 columns. Behind it sits a query with
five columns. These are Column1 (DOB), column2 (a concatenated string
of Surname Forname, Title), Column3 (Surname), column4 (Forename) and
column5 (title). Columns 3,4 and 5 are not shown in the list box only
the first two.
DOB Name: &" "&&", "&
|
by: RZ15 |
last post by:
Hi,
I have a query that is pulling info from 7 tables (all necessary). The only criteria I have specified is for the invoice date field which is as follows:
Field: INVCDAT
Table: dbo_INIH
Criteria: >=DateSerial(Year(Date()), 1, 1)
This works fine. When I run the query like this it takes less than 20 seconds. However, when I add criteria to my transaction code field so that it's equal to the code "TRN", access has a panic attack and...
|
by: deejayquai |
last post by:
Hello
Simple one this I guess, but I'm quite stuck at the moment.
I would like to update the records displayed in my listbox
(lstStudents) using criteria selected from my combo (cboForm) in a
form.
My basic code is:
|
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: 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...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
