>>You stated you used the following syntax:
>>
>>sParams = "Do LoadData With " + sSourceFile + ", " + sDataPath + ", " + sTableName
>>.DoCmd (sParams)
>>
>>I don't see how the above code ever worked since LoadData is a method. Try the following syntax from VB:
>> oFox.LoadData(sSourceFile,sDataPath,sTableName)
>>
>>Murray
>
>
>Tried it.
>
>
> With oFox
> sSourceFile = sSourcePath + "\MODE2.DAT"
> sTableName = "mode2"
> .LoadData(sSourceFile,sDataPath,sTableName)
>
>
>When I try to move to the next line VB's editor pops up an error dialog:
>
> Compile Error
> Expected =
>
> and won't let me go any farther.
>
>I've been working on this (the application not just this bug) for about fifteen hours now, and concede that I'm probably overlooking something.
>
>If you have additional suggestions I'll be appreciative.
>
>Thanks
>
>Jim
Personally I find Auto Syntax checking quite annoying.
If you want to you can turn it off. From the "Tools: pulldown menu select "Options", then from the editor tab of the options dialog turn off auto syntax check.
As for the error, sorry my oversight, Try
oFox.LoadData sSourceFile,sDataPath,sTableName
since LoadData doesn't return a value and also make sure sDataPath is initialized to something.
Murray
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only