|
-
Jan 2nd, 2002, 11:06 AM
#1
Thread Starter
Hyperactive Member
I am this close (pinching fingers close together) to getting the sledgehammer
AARRRRRRRRGGGGGGGGGGGGGGHHHHH!!!!!!!!!!!
That feels better. Now, the problem:
I have the following code on my computer at home, using the Working Model edition...
Dim SQL As String
Dim Db As Database
Dim Rs As Recordset
in command button -
Set Db = OpenDatabase("c:\myfolder\myDb.mdb")
SQL = "SELECT * FROM yourtable WHERE zipcode = '40202' "
Set Rs = Db.OpenRecordset(SQL, dbOpenDynaset)
This code works dandy. In order to "make" the program, I must go to the local university's computer lab (Working Model doesn't have this feature.) So I put the program on disk, trot down to the computer lab, run the program and voila...the following error appears: "User defined data type not defined." The 'Dim Db as Database' line is highlighted.
Now then, I do not have to explicitly declare a data type at home, when I am using the Working Model. I just put the aforementioned 'Dim' statements in the general declarations, and everything works. What's the dilly? What is going on? Mayhem is about to ensue!!!!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|