Excel VBA - Return Employee Records From Access Based on Selected Department

[djbehar]

Hello,

I'm pretty new to Excel VBA and using Access at all. I realize that it is not recommended to use Excel as a front end for Access, but due to many constraints, that is what I have been tasked to do. I have been able to find enough information to write a macro to return Employee Information for a specified department. What I would like to do now, however, is see if it is possible to refer to a specific cell on my spreadsheet, for which I will have a drop down, and return the employees from that department.

I have tried defining a string for the department and assigning it the value in the drop down box (cell P2), then attempting to have the macro return values where the department is equal to that string, but I keep getting errors. Here's one of the many iterations of lines that I experimented with adding and did not have any luck:

Please Login or Register  to view this content.

I'm not sure if any of this is possible and I appreciate any help. Here's the code which worked to return all employee data from the sales department:

Please Login or Register  to view this content.

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks

[Pepe Le Mokko]

BTW Your profile indicates you are using XL 2003. is this still the case? Perhaps adapt your profile to your actual version if need be? Thx

[djbehar]

Thanks for your help on that. I had created this account long ago and had not since updated it to my current version of 2013. Also, thanks for your help with the tags. I'll get that right next time.

[djbehar]

Never mind, I figured it out. I had everything jumbled. In case any one is interested, I added the following lines where appropriate:

Please Login or Register  to view this content.