Search results

I am not very familiar with it. Mostly what I am looking for is some kind of prebuilt solutions that I can just paste into the visual basic code. If you are wondering, all I need is a text box where I can enter the search string, and a Search button. After that it will display where the string...

Does anyone know how I can do that? My database is split into at least 20 tables, and I would like to be able to search for a value in all 20 tables, and make it list out which table the value appears in. Thanks

Re: How do I search for a value in all tables? Thanks for all the replies. @Galaxiom: How would I use VBA to loop through this? I am not the most experienced programmer so if you can guide me, that will be great. @jdraw: the number is just a serial number, which means that if needed, I might...

How do I search for a value in all tables? Does anyone know how I can do it? I am just for example searching for a value: 393592 in all of the tables which is in a database and make it display which table it's in :\ Thanks for any help :D

Does anyone know :O?

Is there anyway for me to use DoCmd.TransferSpreadsheet? I have been trying that since it seemed a bit simpler but I still need to makeit find all the excel files, and use it as table names, and then make the names of the files as names of the tables.

I am trying to create a new table in Access with the name of the document. And inside the tables are the content of the excel files. Maybe if there is a box that let me choose the folder that will be great. Thank you.

@AccessMSSQL: Sorry but I just realized that the names of the tables will be the name of the excel documents, as the value inside that A3 box is the name of the Excel document. All the files have the same layout, Row 1 is the labels. I mostly just need a way for VBA to use all the excel...

Does anyone know how to do this? I Need to make a macro that will import all excel documents in a folder into a database, with the name of the table as the value in 1 of the boxes inside the excel document (So maybe A3 location). Please help. Thanks!