I have a form with two subforms. The subforms get their data from the same
two tables, with several fields that overlap and several others that do not.
Is it better to have these subforms get their data from two separate queries
or to have a single query that is then filtered differently by the two
subforms?
--
Message posted via http://www.accessmonster.com 4 1588
On Sat, 22 Mar 2008 16:30:28 GMT, "vircalendar via AccessMonster.com"
<u4313@uwewrote:
Take 5 minutes to try it both ways, and let us know how you fare.
-Tom.
>I have a form with two subforms. The subforms get their data from the same two tables, with several fields that overlap and several others that do not. Is it better to have these subforms get their data from two separate queries or to have a single query that is then filtered differently by the two subforms?
I don't really see any difference, but I'm wondering what I might see as the
files get larger.
Tom van Stiphout wrote:
>Take 5 minutes to try it both ways, and let us know how you fare. -Tom.
>>I have a form with two subforms. The subforms get their data from the same two tables, with several fields that overlap and several others that do not. Is it better to have these subforms get their data from two separate queries or to have a single query that is then filtered differently by the two subforms?
--
Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/200803/1
I don't really see any difference, but I'm wondering what I might see as the
files get larger.
Tom van Stiphout wrote:
>Take 5 minutes to try it both ways, and let us know how you fare. -Tom.
>>I have a form with two subforms. The subforms get their data from the same two tables, with several fields that overlap and several others that do not. Is it better to have these subforms get their data from two separate queries or to have a single query that is then filtered differently by the two subforms?
--
Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/200803/1
On Mon, 24 Mar 2008 04:48:10 GMT, "vircalendar via AccessMonster.com"
<u4313@uwewrote:
Sorry, that's what I meant: write a few lines of code that quickly add
100,000 rows or whatever is realistic for your scenario, and try
again.
-Tom.
>I don't really see any difference, but I'm wondering what I might see as the files get larger.
Tom van Stiphout wrote:
>>Take 5 minutes to try it both ways, and let us know how you fare. -Tom.
>>>I have a form with two subforms. The subforms get their data from the same two tables, with several fields that overlap and several others that do not. Is it better to have these subforms get their data from two separate queries or to have a single query that is then filtered differently by the two subforms?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Sean C. |
last post by:
Helpful folks,
Most of my previous experience with DB2 was on s390 mainframe systems
and the optimizer on this platform always seemed very predictable and
consistent. Since moving to a WinNT/UDB...
|
by: DebbieG |
last post by:
I have a form based on this query:
SELECT Students.LastSerDT, OtherInfo.Served, OtherInfo.HSGradYr,
OtherInfo.ActivePart, OtherInfo.Served, Students.SSN, & ", " &
& " " & AS Name,...
|
by: Rated R1 |
last post by:
I wrote this before in the NGs, so I am going to paste the responses that I got
and see if someone can please help me. Email me and we can set something up as
Id even be willing to pay for your...
|
by: Willem |
last post by:
Looking for some opinions on alternatives to programming with Access.
I find that quite often I need to loop through my recordsets (first to
last) performing calculations and was wondering if...
|
by: jjyconsulting |
last post by:
Newbie needing some help. I have a tblParticipants. The fields
include gender, education_level, income, occupation etc., I'm trying to
create a form where a user can run a query from the form and...
|
by: Simon |
last post by:
Dear reader,
The syntax for Docmd.OpenReport is:
OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode,
OpenArgs)
Example
The following example prints Sales Report while...
|
by: jesmi |
last post by:
my code is:
U]employee.cfm
<html>
<head>
<title>Employee List</title>
</head>
<body>
<h1>Employee List</h1>
|
by: lorirobn |
last post by:
Hi,
I have a list box on a form, whose row source points to a separate
query. The query refers to a field on the form to filter records on
the list box, like such: WHERE tblA.DesignType = !!...
|
by: Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ |
last post by:
I am running Access 2007. I have a report that I want to filter. I
can go into Advanced...Advanced Filter/Sort... and setup a filter that
works fine on the report when I apply it. When in this...
|
by: Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ |
last post by:
I am running Access 2007. I have a report that I want to filter. I
can go into Advanced...Advanced Filter/Sort... and setup a filter that
works fine on the report when I apply it. When in this...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
|
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...
|
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...
| |