microsoft query add-in
I have just installed the Microsoft Query add-in to
Excel...can anyone tell me if this is the exact query that
Access uses, or are there differences in them.
Query kind of looks like Access, but it not nearly as
powerful. It has several limitations. For example, what
I think is the biggest hinderance, is the inability to do
Outer Joins in Query. I do use Query, but mainly to bring
something in from Access.
>I have just installed the Microsoft Query add-in to
>Excel...can anyone tell me if this is the exact query
I have a text file and i read the complete file and build a FILELIST -
GROUPLIST - groups like odbc,,jet40, jet35
The Group list in the file consists of values like
version | odbc | 430
version | Jet40 | 430
version | Jet35 | 430
version | oledb | 430
version | odbc | 440
version | Jet40 | 440
version | Jet35 | 440
version | oledb | 440
The File List consists of values like
FILE | odbc | <COMPLETE path of odbc file like odbc32.dll>
FILE | odbc | <COMPLETE path of odbc file like odbcji32.dll>
FILE | oledb | <COMPLETE path of oledb dll1>
FILE | ole...Column Limit in MS-Query
A user had a query that used to work fine with about 200
columns. It now will not run. We kept deleting columns
in the query until it ran and it did so at 179 columns.
This issue is happening on XP and Windows 2000 in Office
2002 and Office 2000. The database that is being queried
is an Oracle database. The SQL runs fine in a normal SQL
...USe a Parameter query
I have a simple query that I wish to use to search for titles of Music CD's.
I wish to establish a parameter query that will allow the user to enter a
word and the query looks for that word in the title. I have lried .....Like
*[Enter the word]* in the query designand various combinations in between but
to no avail. Can it be done
try to use under the "Title filed "
Like "*" & ["Enter the Word" ] & "*"
so it can filter that word out of your database.
> I have a simple query that I w...Insert data using a query?
I'm not sure if what I'm asking is even possible but here goes. I have a
table that contains employees and the company they work for. I have created
a query on that table to identify those employees who dont list their company
based on their employee id number. Example, employees with an ID number of
2000 - 39999 belong to a specific company, so I use the query to find all
employees with that ID number range and is null for the company name.
Now my problem. I want to use the query to update their company name, since
I know that all employees with an ID number of 2000...Excel Microsoft query
I have a few queries,
1. Can a .txt file be joined to another database table?
2. Can I join a two tables in different sheets in the same workbook?
3. I tried to query a table on Excel sheet using the source as Excel
Files*, but a field populated with numbers returned blank cells as the
...Input boxes in excel and MS Query
I'm using MS Excel to display the results of a SQL Server database,
using the GET EXTERNAL DATA wizard, which then takes you to Microsoft
Query so you can set up the SQL coding.
I was having difficulty writing the SQL using MS Query, so I set up the
same scenario in MS Access to write a query, then just pasted the query
into MS Query. Unfortunately the code does not work and I get a
"Invalid column name What is the start date" error
What I'm actually trying to do is get two input boxes to appear each
time the spreadsheet is opened. The user types the FROM and TO dates
in...Analtical Accounting Query #2
Any one can send the query to get the periodic balance of dimentional accout
or pls send the table name to get the transaction amount. Othere wise any
report to get the dimentional transaction summary.
DimA/C Code - (Dedit-Credit)
400 - 1000
400-01 - 500
400-02 - 250
400-03 - 250
400-03-01 - 100
400-03-02 - 100
400-03-03 - 100
400-03-04 - (50)
...Subtract 1 Year from Query Date Range
Between [Forms].[frmReport].[Start] And [Forms].[frmReport].[End]
in criteria to input a date range into a query. The date is entered into the
form “frmReport” in the format of 00/00/0000.
Is there a way to modify the expression above so that it will subtract one
year from the “Start” date and one year from the “End” date.
I need to query one year earlier than the year entered into the form.
Message posted via http://www.accessmonster.com
Between DateAdd("yyyy", -1, [Forms].[frmReport].[Start]) And
DateAdd("yyyy", -1, [Forms].[frmReport].[End...Event Log Queries
Ok, so I'm working on querying multiple DC's to look for a specific
event ID (645 in the security logs, for computers recently joined to
the domain). I thought I had everything figured out, but it's still
not working right. Running the script, it just somewhat hangs...not
sure if that's just because it's still searching or not and is slow.
Let me know if you guys have any thoughts...thanks!
Set objDictionary = CreateObject("Scripting.Dictionary")
arrComputers = Array("DC02", "DC03")
iReach = 0
For Each st...Link query to Excel and back to Access as table??
I recently used Excel to link an Access query as external data to an Excel
worksheet, then linked that file back to Access to use as a table. To me,
this was a workaround way of having query results as a table. I set the
Excel file up to auto-refresh every 60 minutes, but the linked Access table
(based on the Excel file) does not seem to be updating properly. I have no
need to ever open the Excel file, so I figured the auto-refresh would handle
this. Does the Excel file need to be open in order to auto-refresh?
I do not entirely understand why you are going back and forth between t...Newbie
I want to display the result of a query:
SELECT EmployeeNumber, FirstName, LastName, DOB, Address FROM Employee
What control I should put onto the detail band of the report?
Use text boxes to display field values. Set your report's record source
property to your query.
MS Access MVP
"Alan T" <alanpltseNOSPAM@yahoo.com.au> wrote in message
>I want to display the result of a query:
> SELECT EmployeeNumber, FirstName, LastName, DOB, Address FROM Employee
> What control I should put onto the ...return primary key for record after append query
Is there a way to find the primary key for a new record added to a table
using an append query in VBA? I need to assign that to a variable so that I
can use it an a second append query to a different table. For example:
tblCust: CustID (pk), CustName, CustAddress
tblOrder: OrderID (pk), CustID (fk), ProdID
If I use append query to add CustName and CustAddress to the tblCust table,
how do I get the CustID for that record to use in an append query to add
records to the tblOrder table?
It is possible to query the last key value like this:
Function ShowIdentity() As Variant
...how do i create a tab on a form that directs me to tables;queries
I have heard that a tab can be created in a form that direstc you to other
areas such as queries or tables. I was wondering how this could be
Tables are for storing data, queries for retrieving it. Forms, including
forms with Tabs are for displaying that data. Do not allow users to work
directly in tables.
Create a subform in Datasheet View for the table or query that you want to
view and add that to a tab on your main form by first adding the tab
control, then dragging the subform onto the control, from the database
window or Nav Pane.
Arvin Meyer, MCP, ...MS Query over a network
I have an MS Query embedded in an Excel worksheet. When I
try to refresh the data from a different computer on the
network, I get an error telling me the network path is not
valid. One problem is that all the computers on the
network map drives with different letters. How can I set
the query up without assigning a letter to the drive
containing the source data?
...HELP: Syntax error (missing operator) Query Expression
Hi All, I am gettin a Syntax error (missing operator) Query Expression
'Student_Name = JAMES JAMES' on this line:
Set rst = conn.Execute(strSQL)
Basically, I want to pull details from access into userform fields based on
what I enter in StudentName text field, Here is the code for that event:
Private Sub StudentName_Change()
Dim conn As Object, rst As Object, strSQL As String
Set conn = CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.ACE.OLEDB.12.0; " & _
"Data Source=C:\My Documents\Student_Data.accdb;...Confused query
I've got a query which asks the question Enter Project A or B. This part of
the query works fine on its own. I also want to ask in the same query
whether a "modified" Project A should also be included as in [Do you want a
modified Project A included Y/N?]. The modified Project A is indicated in
the table by a Yes/No field. If I type a Yes or No directly into the
query it works the way I expect but if I use the question to get the Yes or
No both questions are asked correctly but the result fails with a "too
complicated expression" error
I'm sure it can be done...How do I query for a count of days since a specific date?
What I'm trying to do is display the number of days that have past since the
last date (date/time format). Is this possible?
Use the DateDiff function:
DateDiff("d", [LastDate], Date())
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Antwan C" <Antwan C@discussions.microsoft.com> wrote in message
> What I'm trying to do is display the number of days that have past since
> last date (date/time format). Is this possible?
Is there a calculat...Date comparison in IIF statement in a query
I have a form with a control containing a date. This date is used in a query
as part of a IIF statement included in the criteria row of the query:
The syntax must be wrong in some way as it does not return any records.
Any help would be appreciated.
>I have a form with a control containing a date. This date is used in a query
>as part of a IIF statement included in the criteria row of the query:
>IIf(IsNull([Forms]...Query Problems 07-20-07
Hi all,i am a new user of access,i am now using access 2007,i wanted to link
the 3 tables together,to create a query that will returns records of
company,part number,description,selling price and date of purchase.below are
my tables in datasheet view;
Customer details Products detail sales detail
id id id
Company part number company
Address alternate part number
Telephone model description
...Select records from query using added checkbox
I have a subform in which I show records resulting from a query displaying
certain data from two tables. I would like to add a checkbox to every entry
of this query, so the user can select the query-records he wants to use to
perform additional tasks with.
E.g. Say the query collects data on persons and their jobs based on certain
criteria. The user must be able to (de-) select the persons he would like to
leave out of a report that will be made once the user has decided on the
Also I would like to have all the checkboxes initially checked, so the user
only has to deselect s...query sort on date
I've got a table where applicant data is entered (via a form) everytime an
application is submitted. Each time a person submits an application it is
enteed as a new submission, thus I can have duplicate records on a person,
except for the submission date and maybe the address if it changed but it is
still a new record.
My questions are how can I query the table data to only show the most recent
applications without having duplicate records on a person? Another field in
the table is the SSN.
The other question pertaining to the same query is say that an application
was submit...Error 8270 ldap error
I've a big problem with exchange 2003 and one error : 8270
"LDAP returne error  not avaiable ...."
This error flood my event log, and i don't find how to resolve the problem.
On microsoft support i found : this error is caused by dns or network
problem, but after test i'm almost sure there is no problem.
So my network contain several child domain link by VPN to my principal
I've exchange only in the principal domain, and in child domain i've just
executed setup /domainprep.
So i...Attachments and LDAP Directort dialog box
When adding attachments in OE you are able to add multiple
attachments. For some reason I am able to only add one at
a time in Outlook 2003. Is there a setting I have missed?
Secondly, when Outlook starts, I get a dialog box
called "Microsoft LDAP Directory" pop up. I do not use
this facility, but only use the ordinary address book. Is
there any way to diasble this dialog box so that Outlook
loads without intervention?
...Microsoft Access Query Links
Is there a relatively easy way to link to objects within an access database.
I am particularly interested in making notes on parts of my access database
and being able to jump to that part of the database if needed. I can only
seem to get a link to the database file but not within the database to the
actual query or report.
> Is there a relatively easy way to link to objects within an access
NO, there are no such tools for Access.
> I am particularly interested in making notes on parts of my
> access database and being able to jump ...