473,382 Members | 1,615 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Running a .mdb database in Access 2007 , throws error 3085

26
Hi Group,

I get error in this line :--

Expand|Select|Wrap|Line Numbers
  1. Set db=Currentdb
  2. Set qdfToRunFiles=db.QueryDefs("qryToRunFiles")
  3. With qryToRunFiles
  4.  .Parameters("dCOB").value=dCOB-----at this line 
  5.  Set rsToRunFiles=.OpenRecordset
Error Message Box:

Expand|Select|Wrap|Line Numbers
  1. Run-time error '3085'
  2. Undefined function 'Environ$' in expression
Need help !! There's no missing reference.
Mar 2 '11 #1
1 2509
NeoPa
32,556 Expert Mod 16PB
I would look at the query [qryToRunFiles] for your problem. Otherwise, dCOB is not declared anywhere in the code you've posted, so that shouldn't work. If you've declared it somewhere but just not shown it then that's your own fault for leaving it out.
Mar 2 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: adrian | last post by:
Hi, Has anyone succeed to compact an Access 2007 database via VB.net code? The previous methods from JRO don't work anymore and there is no help on msdn on how this could be done for 2007. ...
1
by: Lpitt56 | last post by:
I am running MS Access 2007 and I want to update an Outlook Address book from my Access Database. I started out by importing the Outlook Address Book as a linked table and it linked fine. I then...
2
by: Wayne | last post by:
Back in August I posted the following: I'm seeing the following problem in a database running under Access 2007 regardless of if it is Access 2003 format or converted to 2007 format. I have...
6
by: tony.abbitt | last post by:
I have recently installed Office 2007 (SP1) retaining the previous installation of Office 2003. I have converted an Access 2003 database to Access 2007. The database contains the VBA code...
3
by: Margie | last post by:
Working on my database I use a modified piece of code gotten from thescripts. The code works perfectly except for one thing. When entering data containing the character ' , I get the error: Syntac...
6
by: MEGDZIA | last post by:
Could you please advise how to work out spliting database in multiuser environment if all useres use forms and reports instead of tables....I believe there should be only backend part on shared...
5
by: Tony | last post by:
I am continuing to develop an Access 2007 application which was originally converted from Access 2003. In Access 2003 I was able to disable the Access Close button in the top righthand corner of...
1
by: mramnaveen | last post by:
Hi, Please help me. I have around 15 access queries that i run every day. I want to find out a way where, all these queries could be consolidated and I just click run once and all the 15 queries...
7
by: Wiredboy | last post by:
Hi, i'm pretty new in this and i hope somebody can help me with this: i have a db with 5 columns with different values and i want to calculate the average of them. I've tried to create a formula...
0
by: Tom Gibbons | last post by:
I have an application in Access 2007. I have split the files and created a distributable package that includes Access 2007 Runtime. The front end is linked to tables in an .mdb file from Access...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.