Search Access Database through Excel Userform

[sanits591]

Hi,

Given Data
I have an access database with 30 tables, sequencing from TableNameA,TableNameB, ...... TableNameZ....TableName1.....TableName4, with Columns A (having one field), and column B (hyeprlinked Text) in each Table.

Requirement

I need to have a userform in excel (as front end) with textbox as a search field for the entire Tables and column A, column B. When the text is entered in the textboox then list box on the userform must get the values and its related searches, like applicable for wild card characters also.

Any suggestion or help shall be appreciated in this regard.

Anticipatory Thanks!

 

[Norie]

The database should not be that size.

Have you actualy used hyperlink fields?

You don't need to do that unless you want the user to be able to click directly on the link to open up the page in the default browser.

You only need to store the words, search terms and base URL.

 

[sanits591]

Thanks for your suggestion, i made the data like words (air brake), search term (air+brake) only, and the URL was taken as the Base URL, and the paths have taken from the search term.

The web page is opening in the web control, and displaying the required search term, but the size of the excel file(.xlsx) which was imported was of 837kb, and the database created for 2856kb, this was the worry of sizes.

And apart from this the web control need to show only the webtable using some Coding.

Please help me to eradicate the intricacies.

Thanks!

 

[Norie]

That is a totally different problem.

Perhaps you could start a new thread for it.

 

[sanits591]

Surely, i will just do that.

 

[Norie]

I mean the web table thing by the way.