In office we are now having xl 2007.
how do I create a personal workbook.?
I had a macro assigned to the menu bar how do it do it.
I had a "proper" macro pasted using VBA window and it was available for the
workbook now I cant paste it in the VBA window. what is the new procedure?
Regards Ron de Bruin
"afdmello" <email@example.com> wrote in message news:%23dDhk6dCIHA.1168@TK2MSFTNGP02.phx.gbl...
> In office we are now having xl 2007.
> how do I create...Experian query failing
For the past week or so whenever I try to update my
credit score in the Credit Center via the free Experian
account I opened when I bought M04 Small Business it
fails. I know Experian had some problems on their site
about a week ago, but it seems to be up now. Anyone else
having this problem or know the cause or solution?
I am also having that problem.
>For the past week or so whenever I try to update my
>credit score in the Credit Center via the free Experian
>account I opened when I bought M04 Small Business it
>fails. I know Exper...Query re: Incoming messages
I want to setup a filter on my exchange 5.5 server so that
incoming email from once particular external source can be
re-directed to my mailbox, regardless who it is addressed
to. Is this possible??
I do not believe this is possible, with Exchange natively...you would need
some sort of third party application to implement this...
"Ben Hymas" <firstname.lastname@example.org> wrote in message
> I want to setup a filter on my exchange 5.5 server so that
> incoming email from once particular external source can be
> re-direct...How to Query 11-21-07
In SQL Server, I can use Query Analyzer to run SQL query and
to debug the query. In acess, there seems no function like Query
Analyzer. If I want to run and test a SQL, how can I
do that in Access.?
1. Go to the Database Window
2. Go to the Queries tab
3. Click on New Query
4. Click Design View
5. Don't select a table and click Cancel
6. Click the SQL view button
7. Type or paste the SQL into the window
8. Click the Datasheet View tool button to view the results of the query.
Access World Forums Super Moderator
Utter Access VIP
Tutorials at htt...Getting result of a query in a variable
I'm quite new to VBA and Access, but I want to get the result of a
select statement into a variable to be able to work with it.
The select statement will return only one value.
Can anyone help me on this?
Use DLookup() to get the field from the query.
Explanation of how it works:
Getting a value from a table: DLookup()
The article refers to a table, but you can put your query name where it
expects the name of the table.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tip...Printing Query
Is there a way of printing an area which printed landscape would spread
over 2 pages as 1 page (not by fitting to page) but by printing what
would appear on page 2 below that on page 1 as the data is not deep
(area to be printed is P5..AK16)
...Query parameter help
The above parameter works. If there is a date, it filters with that date,
if not, no filtering is done. I would like it to restrict by date greater
than or equal to
I have tried several ways to do this to no avail. Here are two examples.
Hopefully this is helpful...
...query to join multiple queries
Need help with this,
This is a query that I'm using to consolidate other queries that perform the
same calculations, only for different date periods.
SELECT [1stPeriod].FltNumOrgDst, [1stPeriod].ExpLF, [2ndPeriod].ExpLF
FROM ((((1stPeriod INNER JOIN 2ndPeriod ON [1stPeriod].FltNumOrgDst =
GROUP BY [1stPeriod].FltNumOrgDst, [1stPeriod].ExpLF, [2ndPeriod].ExpLF;
The problem I have with it, is that if a FltNumOrgDst doesn't appear in all
the other queries, it eliminates from the consolidating query. It doesn't
return blank or null values I think.
I nee...Form/Query Question
In Access 2007, I have a table that has the following columns: First Name,
Last Name, Date of Birth, Hair Color, Height, Weight, and Current Location. I
want to create a form that I can go into and find all of the individuals that
were born after 1980 and with brown hair; or possibly all the individuals
with brown hair that weigh under 180. Basically I want to be able to search
the table based on inserting the specific parameters I want into a form. And
then I want to be able to see a report of all the individuals that meet my
parameters to print out. How can I go about this?
Y...total query with last date
I have a table with 5 fields
ID PersonID Date Amount and Type
I want a query with the last record of each person based on date and
want the results like this
PersonID LastOfDate Amount Type
How can i do that
On Jun 19, 8:49 pm, zions...@gmail.com wrote:
> I have a table with 5 fields
> ID PersonID Date Amount and Type
> I want a query with the last record of each person based on date and
> want the results like this
> PersonID LastOfDate Amount Type
> How can i do that
You need 2 queries to accomplish this. First make a G...Get next ACTINDX with queries
Can anyone tell me how can I get the next ACTINDX by SQL code so I can
create accounts directly through database queries?
I need this for an application interface.
Already tried eConnect object taUpdateCreateAccountRcd and it worked, but as
it is a large amount of accounts it takes too much time, which causes other
problems in my implementation.
Any help will be greatly appreciated.
select MAX(ACTINDX)+1 from GL00100
> Can anyone tell me how can I get the next ACTINDX by SQL code so I can
> crea...Question on Sorting within a query
I have 1 query which is the basis for a datasheet and a report. It seems
that no matter what I specify in the ORDER BY clause, the sort order differs
in the report and datasheet. Same thing results if I ORDER BY more than 1
column. It also seems that if I specify sorting by more than 1 column in
design view, sorting only occurs on the first column. When I switch to SQL
view, both columns do show up in the ORDER BY clause, but still only 1 column
Is there a bug of some sort that pops up when sorting query results?
A report completely ignores the OrderB...Compare queries
I have several access programs that are extremely similar but written for a
purpose at the time
I now wish to combine into one access program
Is there a simple way of checking queries between these programs to see if
they do the
same job or not
Hope this makes sense, regards, Garry
...Opening a query from a command button
I have several queries opening from a single command button. The first should
I get an error message telling me "DELETEtbldatentry = empty"
the query name is correct (including case) and the query opens and runs fine
when opened manually.
What am I doing wrong?
Please provide a bit more context in which this line of code is being
Microsoft Access MVP
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a produc...Enable automatic query refresh for all workbooks?
I know there's a way (according to a KB article on Office 2000 SR1), and in
Office XP I must have turned this off somehow, since my workbook didn't ask
me everytime if it should refresh or not, but I can't seem to find where
this checkbox is in Office 2003!
This checkbox has been removed in XL2003 for security reasons. You cannot
off the prompt using the XL interface. Modifying the following registry key
will give you the same effect:
0 = Prompt on all workbooks
1 = Do Not Prom...Query for the outstanding balance
I just notice that I posted the following message to the wrong forum, I have
posted to Database Design by accident, I should post in Query section:
My question is :
I have designed a database with a Receivable Table and a Payment Table to
keep track on the rental income and receivable. The Receivable Table is with
the following fields
Payment Table has the following fields
I have created a monthly job to create receivable per rental agreement (we
have tenancy agreement without expiry, ther...How to set the parameter query for this case?
I have 2 fields, Eng and Math.
I would like to set the parameter query for Eng and Math ==> Eng min, Eng max,
Math min and Math max.
The Eng query criteria can be "Between Eng min AND Eng max" and the Math
query criteria can be "Between Math min AND Math max".
But...if I would it can be allowed to have "Null entry", how can I set the
Eng and Math query criteria?
Please kindly help me, thanks a lot!!
All combinations will be like...
Eng : Between Eng min AND Eng max, Between Null AND Eng max, Between Eng min
AND Null, Between Null AND Null...LDAP query for hidden mailboxes
I have Exchange 5.5 server . When I try to do a LDAP query for hidden receipients or public folders which are hidden, I do not get a responce.
Can anyone tell me how to enable this on Exchange without changing the hidden attribute.
I would really appreciate it.
...entering parameter criteria MS Query
Hope someone can help. I’m trying to extract data from a SQL Server 2005 into
Excel, using a parameter criteria in MS Query. If I use criteria in a field
with an integer data type it works fine. If I use a field with an NVARCHAR
data type (which is the one I want) I get a “Syntax Error” message. There
seems to be no way of entering criteria into this type of field which MS
Query will accept. If I enter james it defaults to N’james‘, which works as
syntax criteria in SQL Server Management Studio 2005, but not in MS Query.
What am I doing wrong?!
...Adding totals in Query
In my query I'm generating totals by groups (Routers) I have 4 groups the
field name is router, Sample Qty is one of my field and groups (Routers) is
the other field, my query returns the total by group/router,
This is what I get as an answer This is what I want
SumOfQty Router(Group) SumOfQty Router(Group)
50 Loose Cases 150 Loose Cases
75 Palletized Cases 75 Palletized Cases
100 Sort & Segregate 100 Sort & Segregate
When I run this query I al...yet another: which is faster table or query ?
seen LOTS of posts about this topic, but none seem to address the
heart of my question.
Let's break this into 2 parts: queries (stand-alone); and form data
sources (and control data sources)
queries - stand alone:
Let's say I have a query (#1) that relates information in 3 tables.
Now I want another query (#2) that uses that same information, and
relates it to more tables.
Would query #2 be faster if it uses query #1, and relates that to more
OR would it be faster if it had all the table relations in query #1
built into it (not use a query inside a query) ?
...LDAP Query for All Groups and Membership
I am looking to query Active DIrectory in an environment with Windows
2000 DC's. Its a single domain environment. Currently I have a vbs
file that pulls the data but only for a single OU. I am looking for a
single vbs script that pull the following information:
All Groups, both security and distribution (from a single domain)
Whether they are Security or Distribution
Whether they are Global or Universal
All members of each group
I would like the output in cvs format (if possible). Like so:
GroupName, MemberName, Type(Security or DL), Scope(Global or
If this i...Query/Filter asterisk
I have product descriptions that have an * in the description. I need to
query or filter all products with an *. How do I that when the * is also
used as a wildcard?
Build a little - Test a little
> I have product descriptions that have an * in the description. I need to
> query or filter all products with an *. How do I that when the * is also
> used as a wildcard?
...Re: Microsoft Support Queries (on Biztalk)
We have got some queries from Customer on Biztalk integration with IBM MQ.
Customer using Biztalk Adapter for MQ Series to plug in to the MQ Queues
and consumes the messages which are coming from ERPLN.
The following are the question from Customer.
"Could you please confirm that MQ messages are deleted once they're read by
If we were to pull the MQ Messages' data to 2 systems, does that mean we
have to design a BizTalk application that processes the same data and send
to 2 systems at the same time? Meaning, the same messages will ...Passing query parameters thru form
I have one Pivot Chart Form (FrmChart) and form is taking data from
one query. but the query generates resultsets after having the
parameters value. I have another form (CallingFrm) which is calling
to FrmChart form.
so before i get the data in pivot chart form i should have query
executed with parameters. so i am using code below:
Set qryDef = CurrentDb.QueryDefs("MyQuery")
qryDef.Parameters("Qtr") = ChartQtrCmb.Value
qryDef.Parameters("yr") = ChartYearCmb.Value
'I tried both but doesnt w...