Hi Beulah,
May God Bless you and your family.
I understand your point but in every situation there is always a right and
accurate solution.
You Ideas and what you have than is good an I appreciate that. what I can do
is to suggest may be it is good for you or not.
In your situation like slowing of proceesing is not a problem anymore you can
add more memory to make it more faster. 3 joins is still considered small even
seven joins in a pentium 4 3.2 ghz 256 memory is so fast. Give me your computer
config so I can suggest a good computer you can use.
Second you can code it in VBasic and use CODE EVENT like while loading form
do this, opening form do that or Click button and use use CASE statement to
make diferent ranges of output and selection process to make it more faster and
very fast specific processing, becasue this is a background or behind process.
If this work good for you just let me know. if you want sample let me know.
You can email at [EMAIL PROTECTED] for more question. Please don't hesitate
while it is free.
Beulah Florence <[EMAIL PROTECTED]> wrote:
Thank You Romy for your concern. I actually wrote a function that
builds the SQL query based on user selection. Then i called the function in a
button click event which after calling this function redefines an already
existing query with the new definition and then displays the results in a
subform.
Now my problem is that there is a lot of processing time because my query has
three joins. I am working on making my code efficient. I have a sum that i need
to calculate based on different costs in the database and then use the same in
the query too. So, i am first writing a query to find the sum, declaring as a
table and then using table.cost to divide. Is there no other way, meaning, is
there a way to save the result of a query in a variable and then use this in
another query instead of a join. This might reduce the processing time. Please
advice. Thank you very much.
florence
A smile is the light in your window that tells others that there is a caring,
sharing person inside.Keep SMILING.
----- Original Message ----
From: ROMEO IDJAO <[EMAIL PROTECTED]>
To: [email protected]
Sent: Monday, July 9, 2007 2:03:28 PM
Subject: Re: [Access VBA Central] [EMAIL PROTECTED]
Hi,
Hello this is Romy a pilipino working in Jeddah. For your problem you can use
queries to filter the true value then you can display or print the true
value.This is the simplest way. Or you can use VB code. Don't hesitate to call
me if you can't do it. My mobile 966 502916519.
Thanks
Beulah Florence <[EMAIL PROTECTED] co.in> wrote:
I did not know if I could email to your id, i am sorry if i shouldnt have, but
i needed the answer for my question.
I have a table "Project". There is a field Project name and some other fields
that have a boolean value/check box values. The user needs to have an option of
choosing the field that should be queried upon. For example the fields, I am
talking abt are: F1, F2, F3, F4. I will have these as the value list for Combo
box. And When the user selects one of it, will I be able to display all those
project names that have a true value for that particular field.
I will be waiting to hear from you.
Thank you
Florence
A smile is the light in your window that tells others that there is a caring,
sharing person inside.Keep SMILING.
----- Original Message ----
From: rchlon9 <ritchie9710@ btinternet. com>
To: AccessVBACentral@ yahoogroups. com
Sent: Thursday, June 28, 2007 3:06:12 PM
Subject: [Access VBA Central] Re: Field Level Queries
Can you explane your question in a little more detail, i am sure what
you are trying to achieve is possible but i need to understand better
what exactly you need before advising you more.
--- In AccessVBACentral@ yahoogroups. com, Beulah Florence
<[EMAIL PROTECTED] .> wrote:
>
> Can I perform a query using an input from the user as a field on
which the query is written?
>
> It is very urgent. Please respond quickly if anyone can help.
>
> Florence
>
> A smile is the light in your window that tells others that there is
a caring, sharing person inside.Keep SMILING.
>
>
>
>
____________ _________ _________ _________ _________ _________ _
____________ __
> Be a better Heartthrob. Get better relationship answers from
someone who knows. Yahoo! Answers - Check it out.
> http://answers. yahoo.com/ dir/?link= list&sid= 396545433
>
> [Non-text portions of this message have been removed]
>
____________ _________ _________ _________ _________ _________ _
Got a little couch potato?
Check out fun summer activities for kids.
http://search. yahoo.com/ search?fr= oni_on_mail& p=summer+ activities+
for+kids& cs=bz
[Non-text portions of this message have been removed]
------------ --------- --------- ---
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
[Non-text portions of this message have been removed]
__________________________________________________________
Shape Yahoo! in your own image. Join our Network Research Panel today!
http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
[Non-text portions of this message have been removed]
---------------------------------
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news,
photos & more.
[Non-text portions of this message have been removed]
