How are you connecting to the database? If you are using ODBC, you need to create a like ODBC element on the new computer.

Hoppy

Where do you want to get the name of the database from? The choices are to hard code it, (not your favorite obviously), to pass it as a parameter to the application via the command line (not my...

I'm not sure why you don't like the code you have if it works, but just in case you're interested, this is the way I ususally do it:


Dim wrkJet As Workspace
Dim dbProgram As Database
...

You are still always going to "cancelmessage:". try the following code:

Do
On Error GoTo cancelmessage
comdia.cancelerror = True
comdia.Filter = "*.doc"
comdia.InitDir = "C:\"
comdia.filename...

You might be confused by the fact that the logic following "cancelmessage:" is executed regardless of whether or not there is an error.

The second time through the loop, you may have gotten an...

Once again, "ticketsFolder" IS and object and requires a "Set". This distinction in syntax is kind of a stupid rule in VB, but it's something you have to live with.

Hoppy

The problem is that the variable named "subjectLine" is defined as a String. A String is not an Object. When you use the "Set" statement, the compiler expects that the thing you are "Setting" is an...

Try this.

Dim myDate as Date
Dim mth as String
Dim day as String
Dim yr as String
.
.
.
myDate = CDate(mth & "/" & day & "/" & yr)

Dear qpido,

From your question, it is not clear what you are looking for. VB is supported in both Excel and in MS Access, although the have different object models. So, are you trying to get data...

EOF is a function that is used with files you have open in Excel. It has nothing to do with the spreadsheet itself.

To do what you want to do, you need to designate a column that tells where the...