Recent content by 03Explorer

*thinking* wonder why this thread is not getting any attention.

We had a former developer who built most of the forms in our MS Access database. When we first built the database in Access office 365 we did refreshing of tables from our dev version before publishing to production. All was great back then, before the revamping of the managing of linked...

What is the best way to find out if queries or tables are used throughout the Access system? Either by query to query or VBA SQL code or by Objects? Is there any good solution to cleaning house on them without the change the name and let time reveal if it is used by way of broken code. This...

Okay Strongm, You won this time... :) I did end up using a Passthrough query. I am not a fan of having a bunch of queries sitting in a list and no way 'easy' to quantify if they are used or not. That is the reason I chose to go with coding vs a TON of randomly plotted queries. Some need to...

How can I use ADO with ODBC? From what I am reading I have to use OLE DB. That forces me to use static server values vs using ODBC which our IT manages and we use when moving SQL servers.

Strongm - I am willing to work with code to avoid having Passthrough queries hanging out. My previous coding associate was all about having queries and passthrough queries (which you helped us GREATLY to understand). I like to keep the queries section as clutter free as possible and keep the...

I am a lightly seasoned VBA programmer but this is a time where I ponder on why I get a compiling error with this command with Error: "User-defined type not defined" line in blue [highlight #729FCF]Dim cn As New ADODB.Connection[/highlight] Dim cmd As New ADODB.Command Dim rs As...

Andy, you just got my head spinning... LOL I took the question and solutions and put them into code I recognize (now you reminded me I have 3 parameters to send into the SPROC). I need to adjust this sample code to incorporate what you just shared (parameters to SPROC). My platform is MS SQL...

But that "SEL_Suppliers_Summary" is only used in the question, but not again in the resolutions. = Why not in the resolution suggestions below the question.

I found code that describes what I want to do... Execute a SPROC (MS SQL Server) and directly populates a local MS Access Table. I am just uncertain in their code what the actual SPROC name is. I am not a member of that forum and rely on this site for my primary resource. Thanks, Site: Link

Correct, I am looking to remove 'Managing Director' for only one Associate running the code, everyone else receives the full list. Rob

Follow up question for this script. If all users who reach this code, they get all associates, but if user with ID 'xxxxxxxxx' goes through this code they are restricted by not seeing Managing Directors (MDs). Code I have so far: DECLARE @AssociateID = 'xxxxxxxxx' ;WITH...

@Mark, Brilliant! I was trying to make the union in the front (top of the sql code) but placing at the bottom makes complete sense now. Also I tend to use variables and immediately smiled when I noticed you went there. THANK YOU!! Rob

I am using a single table UniqueID LastName FirstName ManagerID Title ======== ======== ========= ========= ===== 1 Smith Frank VP_Sales [highlight #FCE94F]2 Moore Bethany 1...

I believe I am very close to getting the results I have been seeking. I've been digging and it appears SQL is going to be the method I find to work best. It's SQL I am passing to the SQL server (Back end) so I am able to leverage more powerful options ie With or CTE (Common Table Expression)...