Open table from list

[Micron]

I did some tweaking before you posted. Here's what I came up with (and I am talking about deleting the table as well as the list because I think you already mentioned removing the table, but not the list item). There's no error trapping and the code may not be 100% optimized but I didn't see the point in worrying about that if I was not on the right track. Table copies in sample db simply make it easier for me to retrieve a table for further testing after it has been deleted. I copy the "copy of" and rename back to the original thereby keeping the "copy of". I think the limit here is 500kb and the attached is beyond that now because of the extra tables, plus there are 2 forms - so it is zipped. One form is for viewing table on form, thereby keeping it in front of the user, the other is for just opening the table as per your original request, which would open another window. I like the datasheet in form idea better. Dbl click list item to open, click btn to delete and refresh list (form1). Refresh button is for when you copy back the "copy of" table as well as for when user does data transfer and this form is still open. You'll need to refresh the list in that case.

See what you think.


ImportError_v2.zip

[mlrucci]

The inforamtion in the excel spreadsheets are coming from different programs and imported into excel. Each spreadsheet is coming from different departments. I have created vba to extract what is needed from each spreadsheet. This long/complicated and inconsistent process is being worked on to be more standardized, but will be a while as in information is obtained from multiple programs. Hence, need to make sure when importing that we capture if there are errors.

[mlrucci]

Perfect!!!! That is it! I really appreciate your help. I am trying to understand what you did. I reviewed all your code and all of it makes sense except for the row of Me.sfmTable.SourceObject = "table." & Me.List0.Column(0).

Me.sfmTable.SourceObject sets the source of the sfrmTable as the selected table from the list. Perfect!
"table." does this set the unbound field to a table and then & Me.List0.Column(0) tells you which table?

This is the thing about learning, you never stop! This is why I love doing this! If what you did was what I think you did, didn't know you could do that.

[Micron]

"table." does this set the unbound field to a table

Not quite. If you open the form in design view, select the subform control and on the property sheet drop down the Source Object choices you'll see that the choices are listed with the type of object preceding the object name; i.e. the name of a table is prefaced with "Table.", form with "Form." etc. So I used the reference of the object type ("Table.") followed by the reference to the listbox value (which is the value of the selected item). Note the period/dot is part of the first reference. Using concatenation, what I constructed was "Table." & the name of the table returned by the listbox selection - Table.testImportErrors - much the same as what you see in the property sheet.Does that clear it up for you? If not, you might want to research 'ms access vba concatenation'

[mlrucci]

Makes sense. Thanks for the clarification! You are a big help really appreciate it.

[Micron]

NP. Glad I was able to help. If an issue arises, you can always resume this thread.