Make the code working for Access backend

**aman1234** · 05-19-2011, 04:36 AM

Hi All

The attached workbook works perfectly fine. In this the frontend and backend is excel. I want to modify the code to get it working if the backend is Access and frontend is Excel.

Can anyone please modify the code accordingly?

Thanks

**johnjohns** · 05-19-2011, 05:01 AM

Your VBA module is protected with password.

**aman1234** · 05-19-2011, 05:03 AM

Ok. I take the password off.
Thanks

**aman1234** · 05-19-2011, 08:06 AM

The workbook is now unprotected. Can anyone please help me out.

Thanks

**aman1234** · 05-23-2011, 03:20 AM

Hi All

Can anyone please have a look at my problem and convert the code accordingly?

Thanks

**johnjohns** · 05-23-2011, 03:44 AM

This may not a be a direct answer to your query. But see if it helps. I too had a few queries to this forum on integrating Excel and Access and see the answers I got
https://www.excelforum.com/showthread.php?t=752556
https://www.excelforum.com/showthread.php?t=759868

**aman1234** · 05-25-2011, 04:23 AM

Thanks John. But as you said this is not the direct answer of my question. In the attached workbook, the conditions are specified and based upon that the search is done.

I am not able to specify the same type of conditions using access as backend and excel fronrend.

I hope anyone can help me out in this.

Thanks a lot.

**aman1234** · 05-27-2011, 03:29 AM

Hi All

I have written the following code but it doesn't give me the right result but infact type mismatch error.

Please help me out to resolve this problem.

Please Login or Register  to view this content.

Make the code working for Access backend

LinkBack

Thread Tools

Rate This Thread

Display

Make the code working for Access backend

Re: Make the code working for Access backend

Re: Make the code working for Access backend

Re: Make the code working for Access backend

Re: Make the code working for Access backend

Re: Make the code working for Access backend

Re: Make the code working for Access backend

Re: Make the code working for Access backend

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions