Search results for query: *

Mike, Please don't bother with my previous post, I figured out where the file enumerator goes - in the Foreach Loop Editor>Collection. Thanks again.

Mike, Thanks so much for your insightful reply. I do have one follow-up question. How and where do I bring in the File System Enumerator and where do I set file enumerator value? Thank you.

As mentioned in a previous post, I am new to SSIS packages and making progress in baby steps. I have been successful at using control flow and data flow to pull in a generic test file. However, in reality I will need to import any tab delimited file (regardless of file name) that resides in a...

MDXer - Sorry it has taken longer than expected to to get back to this forum. I appreciate your advice regarding pasting the code in body of the message and will do so as needed in the future. In regard to my problem using a View, yesterday I built a control flow for each table with an...

Let me begin by saying I am totally new to SSIS Packages. I am using Microsoft Visual Studio/SQL Server 2008 to create the SSIS package. I am attempting to import a tab-delimited text file into a sql database. The package works fine when I use one table. However, I need to populate multiple...

PHV, I took your suggestion and replaced the "tblComparables.Transaction Date with "tblComparables.[Transaction Date] and that resolved the error in question. I will also try the join on PropID as you suggested. Thank you so very much for your advice; it saved me hours of head scratching!

PHV, My apologies, I don't quite understand the question, but below is the code associated with the Search button. Private Sub cmdSearch_Click() Dim varWhere As Variant, varDateSearch As Variant Dim rst As DAO.Recordset ' Initialize to Null varWhere = Null varDateSearch = Null...

Thanks for both of your thoughtful responses. I will review the code for typos. In regard to the question of the value of varWhere. As the filter is being built, the criterion are stored in varWhere.

I am using MS Access 2003 and attempting to create a search form. I am a real greenhorn with vba code and so I found code from a book and cd I purchased. I copied the code and attempted to modify it for my needs. However, when I run the code I receive the visual basic error message: Run-time...