That's why I run my site Jim
Have fun with it

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jim Thomlinson" wrote in message
...
It's a thing of beauty... I trust you don't mind if I lift your idea for my
own purpose...
--
HTH...

Jim Thomlinson


"Ron de Bruin" wrote:

Just change "go" to "will"

Done

Thanks

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jim Thomlinson" wrote in message
...
You don't have to add the "" but if you want to quote me, be my guest <g.
Just change "go" to "will"
--
HTH...

Jim Thomlinson


"Ron de Bruin" wrote:

Hi Jim

Do you mean that I must add the ""

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
Thanks

I am also an beginner with Access so I hope it is useful for others
Will add another page soon for sending info to Access

My only comment would be the second line on the page is
My English is bad<g, I go change that now Jim


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jim Thomlinson" wrote in message
...
Very nice addition to your site Ron. I have not downloaded the workbooks yet
but I like the very generic and easy to follow way you create your SQL
statement. I will in all likelyhood borrow some of your code for that. I use
something similar but not as easy for the average non-SQL person to
impliment. My only comment would be the second line on the page is "I go try
to change that on this webpage."
--
HTH...

Jim Thomlinson


"Ron de Bruin" wrote:

See this example
http://www.rondebruin.nl/accessexcel.htm

I like the second example workbook where you can save the criteria

--
Regards Ron de Bruin
http://www.rondebruin.nl


"grahammal" wrote in message
...

How can I use an access data base from within Excel.
I already have all the information that is in this database in a
seperate worksheet and search this when I need to do so. I believe that
the search
criteria and speed is far better if I could utilise an access database
but dont know how to do this from within excel. I would like to achieve
this with a bit of VB behind a commandbutton.
Have I asked too much in one question.


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=510665