"No Current Record" question - Microsoft Access / VBA

vincentt via AccessMonster.com

Hi all,

I have a multi-table query, link to the following table:

order table
client info table
receipt table
discount card table

I want to query multiple fields in the above table. Normally, I have to enter
client info, while they place an order and have a receipt, so the first 3
tables contain data. However, for the discount card table, it would only be
given to some specific clients, so it may not be compulsory. But he foreign
key for the table is the order id.

So, in the query, if the discount card table contains no data, that client
would disappear in the query.

I really want to query all the field together in one query, but not separate
into 2.

Please give a light on it. Thanks in advance!

--
I am so new to Access... questions questions and questions...

Thanks always!

Message posted via http://www.accessmonster.com

Aug 23 '06 #1

Subscribe Reply

2285

NthDegree

Open your query, select SQL view, find the text "INNER JOIN discount card
table" and change it to "LEFT JOIN discount card table"

"vincentt via AccessMonster.c om" <u20211@uwewrot e in message
news:652eddc517 22a@uwe...

Hi all,

I have a multi-table query, link to the following table:

order table
client info table
receipt table
discount card table

I want to query multiple fields in the above table. Normally, I have to
enter
client info, while they place an order and have a receipt, so the first 3
tables contain data. However, for the discount card table, it would only
be
given to some specific clients, so it may not be compulsory. But he
foreign
key for the table is the order id.

So, in the query, if the discount card table contains no data, that client
would disappear in the query.

I really want to query all the field together in one query, but not
separate
into 2.

Please give a light on it. Thanks in advance!

--
I am so new to Access... questions questions and questions...

Thanks always!

Message posted via http://www.accessmonster.com

Aug 31 '06 #2

Similar topics

3926

Changing link properties for "current" entry on menu

by: Don G | last post by:

Within the menu for my site, I have inserted 'class="current"' within the link for the current page. So the link looks somthing link: <li><a href="index.php" class="current">Home</a></li> The css for formatting the menu links is: #menu a:hover { background-color: #E00080; color: white;

HTML / CSS

134

7796

"no variable or argument declarations are necessary."

by: James A. Donald | last post by:

I am contemplating getting into Python, which is used by engineers I admire - google and Bram Cohen, but was horrified to read "no variable or argument declarations are necessary." Surely that means that if I misspell a variable name, my program will mysteriously fail to work with no error message. If you don't declare variables, you...

Python

9525

Custom "No Records Found" Message

by: amywolfie | last post by:

I would like to put code behind a Find button on a form which: 1) Performs a find based on a field on the form 2) If NO RECORDS ARE FOUND, then displays a custom "No Records Found" message box. Thanks!! amy ===

Microsoft Access / VBA

2333

How to select data for "current user" in detailsview?

by: VB Programmer | last post by:

When my users login I want them to be able to change some of their personal info in a db. I want to use a detailsview control for this. How can I get the detailsview to only pull up the record based on their USERID ("current user")? This SqlDataSource doesn't seem to return anything... <asp:SqlDataSource ID="SqlDataSource1"...

ASP.NET

2751

pause "on current"

by: RR | last post by:

I have a button on a form (form A) that opens another form. The form that opens (form B) has a listbox that is populated with a call to a function in the "on current" event. When form B with the listbox has a query listed as the data source, it works fine. In this case, the button on form A sets the record source for form B to one of...

Microsoft Access / VBA

12134

Which form is the "Current Form"?

by: MLH | last post by:

Suppose that code running on FormB is moving the focus around on FormA to various textbox controls on FormA - Which form is the current form during this process? Is it FormA, which has the focus. Or is it FormB, whose code is doing the work?

Microsoft Access / VBA

10906

How to find the ID of the "current" element

by: pamelafluente | last post by:

Hello. A question. It is possible to refer to the ID of an element within the element itself? And, if yes, what is the instruction or function. Example. Assume I have this: <div id="Square1" onclick = "Clicked('Square1')"></div> You see the ID of the element "Square1" also appears later on the function invocation "Clicked('Square1')"....

Javascript

2256

Possible to assure no "cyclic"/"uncollectible" memory leaks?

by: Joe Peterson | last post by:

I've been doing a lot of searching on the topic of one of Python's more disturbing issues (at least to me): the fact that if a __del__ finalizer is defined and a cyclic (circular) reference is made, the garbage collector cannot clean it up. First of all, it seems that it's best to avoid using __del__. So far, I have never used it in my...

Python

6773

VBA code for "No records found" in search

by: CrostonScottish | last post by:

Can anybody help? I have this code i have put together so that when i select values for my combo boxes which are linked to values in lookup tables, it opens my "frmriskass" with only the corresponding records based on a query i have built in to the code below which is applied to the search command button in my search form. Private Sub...

Microsoft Access / VBA

7694

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...

General

7609

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7921

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. ...

C / C++

8118

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7964

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...

General

5504

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...

Microsoft Access / VBA

3651

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...

Networking - Hardware / Configuration

2107

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 we have to send another system

C# / C Sharp

936

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...

General