PC Review


Reply
Thread Tools Rate Thread

Access Search withing Excel table with no permissions

 
 
Importnoob
Guest
Posts: n/a
 
      19th Dec 2009
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/te...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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search Access Table with Excel Looch Microsoft Excel Programming 3 13th Mar 2007 04:10 PM
Query for the character - in a field withing a table =?Utf-8?B?TW9uaWNh?= Microsoft Access Queries 3 6th Apr 2006 06:25 PM
search a string withing a string : find / search hangs itarnak Microsoft Excel Programming 4 24th Oct 2005 03:19 PM
How to search Access table based on entry in cell in Excel? =?Utf-8?B?V2lsbGlhbSBGcmFuY2lz?= Microsoft Access External Data 2 18th Nov 2004 12:33 PM
Copying a field of a specific record, withing a table Jon Microsoft Access 2 2nd Oct 2003 07:46 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:31 PM.