by Gustav » Sun, 15 Dec 2002 23:51:08
"The function .... is not defined in the expression"
- If I run the Query from Ms Access thats work fine.
Thanks in advance
by Bob Hairgro » Mon, 16 Dec 2002 01:34:44
This is a mistake that is very commonly made by people unfamiliar withQuote:>I'm trying to get data from a Ms Access Query from Excel
>using ODBC.
>One of the fields of Ms Access Query has a Visual Basic
>routine.
>When I choose the query from Excel, the following message
>error appear:
>"The function .... is not defined in the expression"
>- If I run the Query from Ms Access thats work fine.
>Thanks in advance
Access is not a server; all you've got is the data (and SQL) when
you're accessing it through ODBC. To run any VBA functions, you need
Access' executable running.
HTH
Bob Hairgrove
1. NC-WILMINGTON-113234--Visual Basic-RDBMS-ORACLE-SYBASE-MS ACCESS-MS SQL Server-VISUAL BASIC/RDBMS
******** VISIT US AT http://www.selectjobs.com ***********
=
*************************************************************
Company : Hall Kinion/RTP
Website : http://www.hallkinion.com
Job Title : VISUAL BASIC/RDBMS
Location : WILMINGTON, NC
Job Type : Full-Time Salaried
============================
HALL KINION/ Technical Recruiter-NEVER A FEE!
Hall Kinion is the largest full-service tech recruiting firm in the Silcon
Valleys of the world. We work with top technical companies to offer the best of
permanent and contract placements in North Carolina and across the United
States and the U.K.
2-5 years Visual Basic and RDBMS (Oracle, Sybase, Access or SQL Server).
Plusses: web technology experience, Java, Visual C++.
Multiple positions in Raleigh, NC or Wilmington, NC. Pay is excellent; good
learning opportunities too! Permanent, full-time opportunity!
Travel Required :None
Educational Requirements :None
=
Required Skills
* Visual Basic
* RDBMS
* ORACLE
* SYBASE
* MS ACCESS
* MS SQL Server
=
Definite Pluses
* Java
* Visual C++
* Web Browser Technology
=
Why use me to find you the best job possible? IT SPECIALIST THAT WORKS WITH
OVER 1500 Companies Nationwide, (150 Locally) = THE BEST JOBS
=
Contact Information:
Reference : SJ113234
Debbie Bush
Phone: 800-365-3031
919-572-9999
Fax No: 919-572-6550
*********************** http://www.selectjobs.com ****************************
The On-Line, On-Target Job Finder for Computer Professionals
** Post Your Resume and see results immediately!! ** Always free **
** Post jobs for 30 days for $100, up to 250 postings $350/month
** Matching Resumes E-mailed daily
** Your ads are virtually guaranteed to be seen by jobseekers on the NET **
** Automatic Posting to **
** Yahoo ** Americas Job Bank ** Career City *** ClassifiedsWarehouse
** HeadHunter.Net ** Classifieds 2000 ** Usenet Newsgroups
*** OVER 40 MILLION HITS/MONTH COMBINED !!! ***
*********************** http://www.selectjobs.com ****************************
2. Which query is faster/better/more efficient?
3. GA-Atlanta-98153--Visual Basic-MS ACCESS-RDBMS-ORACLE-Programmer
4. Win32 native fixes after SSL updates (+more)
5. Using SELECT INTO to create a temp table from the results of a stored procedure.
6. MS Visual Basic -> MS Access via ODBC
8. TX-HOUSTON-105339--Visual Basic-MS ACCESS-ORACLE-Web Development-Visual Basic Programmer/Analyst
10. TX-HOUSTON-105339--Visual Basic-MS ACCESS-ORACLE-Web Development-Visual Basic Programmer/Analyst