Search results

maxmangion, yes i do have it in a error handler and just like you mention. The thing is it isn't an error, but just a message and somehow displays the message. Still showing the build-in message that comes with, Yes No Cancel and help buttons. The message is: Microsoft Office Access was unable...

Thanks dapfeifer but that will show the message regardless if something is wrong. I only want to display the message if something goes "wrong" during the transfertext command. This is what I got: DoCmd.TransferText acImportDelim, "import_specification", "tbl_Import", "C:\Data\test.csv", vbYes...

Thanks reneemettrie, The message is correct and probably ok for a techie, not for a user that doesn't know anything about key's, indexes, ect. That's why I'm looking for somehow trap the auto generated message and display something simple of my own. Docmd.SetWarning=false is ok for not showing...

I'm using VBA and DoCmd.TransferText with a specification file to import data from a csv file into a table. The table has an indexed field, No duplicates. Initial run is ok. Importing the same csv file the second time, generates an MS Access build-in message which is correct as it conflicts...

True, you are right! ;)

It did the trick! Thanks! Why I am using this: I used this is many other database projects and it worked fine. I am using it to populate late a selection form ( the main form) in which selections can be made via comboboxes on the tbl_Order which will be displayed in the subform as result.

It's in the main form. The sub form is a bound form on tbl_Order.

Hi, I have a Form with a subform. I'm trying to do the following in the Form Load event. me.frmOrderSubForm.Recordsource="Select * from tbl_Order" which gives me the error: Method or data member not found. I have set all the reference for DAO 3.6 and Access 11.0; but still having the error...