Access Search withing Excel table with no permissions

I

Importnoob

Hi guys,
i cannot seem to make my stuff work, please help me:
I want to make an Access file that uses an external Excel table. I want the
Access to open up with the Search window, and hide all functions and
basically everything that could confuse the users.

The Excel table has like 70 columns, we need to list 8 of them for the user
only, only one row at a time. The columns are not next to each other and are
all named.

I want them to be able to search by all 8 column values and to be able to
search with combined values if there are too many similar.

Basically, i want it to work like this when you open (not giving any insight)
http://office.microsoft.com/en-us/templates/TC012186931033.aspx?CategoryID=CT101426031033

And i want to use the same kind of searching options as the one above uses,
different column names ofc, but i can manage that...


I know this is a lot, i hope you can help me out with this, i am not
somebody using Access frequently tbh, im only experienced in VB and Excel :p

Thanks in advance!

ps.: if u need like a sample of the Excel datasheet, just send me a mail
ill get in touch with u :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
Consolidation Table from Different Excel Tabs with Different Format 1
Match table shading (color) to Visio color/Transparency 1
Doughnut Chart linked with the slicer in the pivot table 0
Setting column width in a table with a macro is not working 0
Creating a Search using a combo box and then creating a report. 4
Only install certain apps in Microsoft 365 for Enterprise? 0
Embedded Excel into Word with Tables 0

Top