By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,289 Members | 1,743 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,289 IT Pros & Developers. It's quick & easy.

Test to see if file spec exists through code?

P: n/a
Anyone know of a way to do this through code?
Aug 19 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Aug 19, 12:38*pm, dmh_te...@yahoo.com wrote:
Anyone know of a way to do this through code?
I sent that prematurely. To be specific, I'm trying to see if a
"SpecificationName", as you would create in the import/export wizard
and use in TransferText, exists (before using it in TransferText.) I
would hope it's either in a system table or in a custom database
property- or anything that I can access through code. Any ideas?
Aug 19 '08 #2

P: n/a
On Aug 19, 12:38*pm, dmh_te...@yahoo.com wrote:
Anyone know of a way to do this through code?

Figuredout how, quite simple actually:

table is MSysIMEXSpecs
field is SpecName
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("select SpecName from MSysIMEXSpecs",
dbOpenSnapshot)
rs.MoveFirst
MsgBox rs!SpecName
rs.Close
Aug 19 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.