Using a query versus a table for the look up wizard
I have a field which I would like to use the lookup wizard for to generate a
drop down list for the user to select from.
My question is whether my databse would run faster if I used:
a query from an already established table as the values for the lookup
to build a new table to hold the information for the lookup wizard to use.
I think you'll find few of us recommend the use of the Lookup Wizard. Lookup
fields only have a place in tables, and your users should never be working
directly with the tables. Create a form, and use a combo box on the form.
(See http...Edit Box carriage return
How do I add a carriage return and have it show up correctly in an mfc textbox? I need to edit the CString variable then updatedata and have it show multiple lines. The multiline option is selected.
"CodeTyro" <CodeTyro@discussions.microsoft.com> wrote in message
> How do I add a carriage return and have it show up correctly in an mfc
textbox? I need to edit the CString variable then updatedata and have it
show multiple lines. The multiline option is selected.
...how to write condition in a query
If I wan to perform some calculation in the query if the condition
meet, how can combine the below statement tgt in one field?
Minutes: IIf([start]>DateAdd("d",-1,[forms]![datedaily1]![date] And
Minutes: IIf([start]<DateAdd("d",-1,[forms]![datedaily1]![date] And
Minutes: IIf([start]<DateAdd("d",-1,[forms]![datedaily1]![date] And
[end]>[forms]![datedaily...Return Cell formula, not result
I want to return a cells formula string, not the result.
1 =B1 20
If I reference cell A1, I want the following result
PS. What is the search syntax to search ALL words, not
just any word. I tried searching the newsgroups but
could not narrow the search.
precede it with a single apostrophe
"Robert Randolph" <NOSPAAMMrob@KingdomSoftware.com> wrote in message
> I want to return a cells formula string, not the re...Pass Through Query Translation
How do I translate this into a pass through query? I've been puzzled over
this for a day now?
I keep getting an error '"YEAR": 'Invalid Identifier'
Kou Vang wrote:
> How do I translate this into a pass through query? I've been puzzled over
> this for a day now?
> SELECT STORET1_TSRFDACT.START_DATE
> FROM STORET1_TSRFDACT
> WHERE ((Year([start_Date])=2008));
> I keep getting an error '"YEAR":...Return receipt In WAE?
I can't find where to request a Return Receipt for a message in Entourage
Web Access Edition.
Not only can I not find it anywhere in the menus or Preferences, but I can
not find a reference to it in Help.
Is this feature not available in Web Access Edition? If it is, where is it,
The feature is not available in EWS, but you can give this a try
Keep in mind that return receipts are not a reliable indication that a
message has either been read or received.
Pawan Kapoo...Problem importing data via query
When i import data via a webquery from:
I get different values than on the webpage..
When the webpage says:
American Dollar 1.3601 0.73524
Australian Dollar 1.62633 0.614883
Brazilian Real 2.75284 0.363261
I get these values in Excel:
American Dollar 13.601 0.73524
Australian Dollar 162.633 0.614883
Brazilian Real 275.284 0.363261
Some values are ten times to high, some are hunderd times to low.
Is this because in my version we use comma to seperate decimals?
So i see the value 13601 for the US$, and with the...I'm SOOO tired of delete queries failing!
running access 2k;
I have 2 queries - BOTH should work as far as I can see, and NEITHER
does; each reporting "could not delete from specified table".
Obviously, they are 2 attempts to complete the same deletion task,
which is to delete every record found in the ZQ_delete-dups recordset
from the Q_patients recordset.
Sounds simple, looks simple, s/b simple, but apparently it's not. I
believe either of these would work under sql-server....
Here's the first query:
WHERE (((Q_patients.T_contacts.contact_id) In (select
ZQ_delete_dups.contact...Business Portal "Copy to Excel" not working in Query pages
I am using Business Portal 4.0. When browsing through one of the queries
pages in Business Portal, i clicked "Copy to Excel" icon. I got an error
saying "The Office Web Components (OWC) must be installed to copy results to
Excel." at the bottom.
I am using Office 2007 on my machine. I came to know that Microsoft Office
Web Components will no longer be shipping in Microsoft Office. I tried
installing Office 2003 Add-in: Office Web Components from
a...Display table name as field in query
Does anyone know if there is a way to display the table name as a field in a
I have a UNION query that merges all of the records from 10 different
tables, but I need a field that indicates which table each record comes from.
Any help would be greatly appreciated.
>Does anyone know if there is a way to display the table name as a field in a
>I have a UNION query that merges all of the records from 10 different
>tables, but I need a field that indicates which table each record comes from.
Just use the table name in a calcula...Display Query from form in Foreground
I have a form upon which the user selects display, filter and sort fields.
He then clics the submit button and a query is built and then displayed with
the following code:
DoCmd.OpenQuery "Queryname", acNormal, acEdit
The query works but shows up in the background and cant be clicked on until
the form is closed. The idea was to create a form on which the user could do
adhoc queries until he gets it right and then click another button to do the
Excel extract. Is there a way to show the query in the foreground?
On Tue, 22 Jan 2008 17:54:27 -0800, rmcompute wrote:
> I ha...Help please using a combo box with a query instead of the usual wildcards etc.....
I have nearly finished my database and I would like to add a query
that uses a combo box to get the results, not the usual paramater
style input. I suppose it would need a form and a query and a combo
box, but where to start !!!!!!!!
Any kind soul out there that can give me an example of where to
The generic approach you'd use is:
* create a new form, add a combo box that is set to return the value your
query would need
* create your query ... in the criterion "cell", put a reference to the
form's combo box's value:
...Return Value from Form
I need to return a value from a form displayed modally.
Many years ago, if I used VB classic, I could create a public method that
took care of any arguments, displayed the form modally, and then returned
appropriate return values. Something like this:
Public Function GetValue(Args As Integer
m_Args = Args
m_Result = DefaultResult
GetValue = m_Result
However, it appears Access VBA doesn't support this. For one thing, there's
no Show method (and so it certainly can't have a modal argument).
I like this approach because ...Aggregate calculations on calculated query fields?
I made a query that uses fields from multiple tables to calculate values for
daily metrics. I need to present monthly totals of the data as sums and/or
means. The tables are linked by the Date (mm/dd/yyyy) field. I enter ‘between
03/01/2010 and 03/31/2010’ in the criteria for the date field. For the totals
I enter ‘group by’ for the date and ‘sum’ or ‘avg’ for the calculated fields.
When the query is executed I receive an error that I ‘tried to execute a
query that does not include the specified expression *** as part of an
aggregate function. *** is the calculated field in the...Selecting Maximum Values in a Query with joins to other tables
I'm having difficulty with a query and hope someone can help me out.
Basically, I'm looking to select the maximum amounts from a table based on a
column in one of the tables named StateID.
It works fine when I do this:
SELECT TOP (100) PERCENT dbo.Bids.StateID, MAX(DISTINCT dbo.Bids.Amount)
AS Amount, dbo.States.StateName
FROM dbo.Bids INNER JOIN
dbo.States ON dbo.Bids.StateID = dbo.States.StateID
GROUP BY dbo.Bids.StateID, dbo.States.StateName
ORDER BY dbo.States.StateName
However, when I start to join fields from other tables in...OpenService Fails, but GetLastError returns ERROR_SUCCESS
I'm trying to stop a service, if the service exists.
Everything works fine if the service is there, but if it does not
exist I'm getting inconsistent results. OpenService returns a zero
handle, naturally. On some computers (but not all) GetLastError
returns ERROR_SUCCESS instead of ERROR_SERVICE_DOES_NOT_EXIST.
Why would I be getting this combination of returns?
To determine what the cause might be, it is important to know what "some computers" are.
For each one that fails and each one that succeeds, it is important to know
Service Pack Installed
Hot Fixes in...Return Range Based on Cell Value
This topic has been covered in varying degrees, but the problem is
that I do not want to sum or count the range. I want the range itself
returned as the value.
For instance in A1 is 7. i.e. July
In B1-B12 are dates 201101, 201102, etc.
I need a formula that will count out the cells and return the range
based on that value in A1. In this case it would return B1:B7. This of
course would be nested in another formula.
On Tue, 4 Oct 2011 17:18:20 -0700 (PDT), Pablo < > wrote:
>This topic has been covered in varying degrees, but the problem is
>that I do not want to sum or count the...LDAP Query #5
I want to setup an Address list (filter) with multiple addresses...
This works for one:
this does NOT work for multiple:
Does anyone know the correct syntax?
Thank you for any help!
"JHP" <goawayspam@GFY.com> wrote:
>I want to setup an Address list (filter) with multiple addresses...
>This works for one:
>this does NOT work for multiple:
>(&(&(objectCategory=*)(ma...Pass Through query with criteria on a form
I have a Pass Through query that looks like this.
sd_term_name_loc as 'Location',
sd_term_city as 'City',
sd_term_st as 'State',
sd_term_cntry as 'Country',
from detail (nolock)
-- ***** The dates below refer to the date and time at which the
transaction was loaded to PRM.
-- ***** The number of pings which have occurred BETWEEN those dates/times
will be counted.
-- ***** Enter the date/time in the format '09/16/2007 14:00:00.000...Search and replace query
I need to be able to specify my search criteria including leading and/or
trailing spaces, and similarly with the replace text.
I could not get Excel to accept/handle spaces as part of the search mask.
How would I do this?
For example if I want to replace all uses of the word he in a database with
she how would I specify space he space for the search, and space she space
for the replace?
Works for me.
Gord Dibben Excel MVP
On Sun, 19 Sep 2004 16:31:09 +1200, "KiwiBrian&...returning zero on pct divided by zero
formatting goes to pot here so I cant represent the tables as I'd like,
but hopefully you get the gist! User entry actual figure is only
entered obviously when there is a figure so alot of the time will be
blank or zero the fixed value target is always on the sheet and the
percentage is basically how much percent of the target has been
acheived which is a pct value.
Is there anyway of substituting a zero in when you have a pct divided
by zero as normally it just comes up with the error message
USER ENTRY ACTUAL FIGURE FIXED VALUE TARGET PERCENTAGE
There...Combo box returning wrong value
I am having trouble with a combo box, which is filled by a query to that
displays two fields (Fund # and Fund description). The fields are unbound
and I am using VBA to store the unbound fields in a table. I am using an
option box to determine which sequence to use to present the data (I use two
different queries and store one of them in the row source of the combo box,
depending on the option box value). This all works fine. The problem comes
when an item is selected. I would like to store the values both the Fund #
and the Fund value in my table with VBA. My VBA code in the co...Queries Versus Views
I have written many Access reports I would now like to make available
via MS SS RS.
Many of my reports rely on queries that relies on 2-3-4 other
queries. Nested queries, sub-queries, whatever you want to call
them. Often this is because of differences between the ways I need
the data (one row, many columns) and the way it is stored (many rows,
What is the most efficient way to deal with nested queries, sub-
queries, or whatever in MS SS RS?
Create views instead of queries? I don't seem to be able to create
one data set based on another...
Patr...Work with web query file
How can i get data from a iqy file??
[PS] E:\>dir *.iqy
Mode LastWriteTime Length Name
---- ------------- ------ ----
-a--- 10-May-10 10:07 AM 758 owssvr.iqy
[PS] E:\>$a = New-Object -ComObject excel.application
[PS] E:\>$iqy = $a.Workbooks.Open(".\owssvr.iqy")
Exception calling "Open" with "1" argument(s): "'.\owssvr.iqy' could
not be found. Check the spelling of the file name,
and verify that the file location is correct.
If you are trying t...Calculations, Queries and making it all come together in my table
I am trying to create a very simple database (I'm pretty new to Access). In
my main table it have a field call % Safe which is to show the results a
calculation. I understand I should create a query. I have two issues - one,
the calculation I created doesn't seem to work. I created a simple query
based on the fields in my main table, in the query field called % Safe, under
Criteria I entered = [# Safe]-[# Unsafe]/[# Safe]. now, I assumed it would
look at the data entered in the main table, perform the calculation and BAM
present me with answer in this field. ...