Visual basic within form does not recognize workspace and database 
Author Message
 Visual basic within form does not recognize workspace and database

If I put a " dim wrkjet as workspace " into an event on a
form, it flags workspace as an undefined user type. If I
put the same line into a form of the Northwind example, in
the same event, it works fine.

Both of these are done on the same compujter.

This tells me that there is some setting that controls the
scope of these keywords. I also not that the autocomplete
fills in workspace in the Northwind form, but does not
have this as a posible item in my form.


Mon, 29 Aug 2005 08:28:41 GMT  
 Visual basic within form does not recognize workspace and database
Hi Courtenay ,

My name is Joseph Moore.  Thank you for using the Microsoft Access

You will need to make a reference to Microsoft DAO 3.7 Object Library in
your Reference list.  You can access the list by opening the Visual Basic
Editor, selecting Tools in the menubar and choosing References.  You will
need to make sure that you specifically reference DAO in your code or that
you give DAO priority over ADO.

More information is available in the following knowledge base article:

225962.KB.EN-US ACC2000: By Default, New Access Databases Do Not Include
Reference to;EN-US;225962

I hope this helps!  If you have additional questions on this topic, please
respond back to this posting.


Joseph Moore
Microsoft Access Engineer

This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights

Mon, 29 Aug 2005 08:37:43 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Visual Basic Recognize Read Only, not attrib, but other user has file open


3. Database Applications: Within Acess or With Visual Basic?

4. Visual Basic recognize a file is open by another user and advise the second user

5. how do i Access visual foxpro database from visual basic

6. A97 to A2K: Database Crashes A2K Visual Basic File Not Found

7. WANTED: Excel-Visual Basic for Applications Wanted: Excel-Visual Basic for applications Programmer - Ottawa

8. Converting and Excel Visual Basic File to an Access Visual Basic

9. Can this be done without visual basic

10. doing a debug -> compile from visual basic

Powered by phpBB® Forum Software © phpBB Group