Recent content by motleyjew

Thank you both for the detailed solutions. I think the example Micron gave is what I needed to wrap my head around. I can use your examples to test past months to see what adjustments need to be made. Thanks you both again for your help! Gregg

Good Morning, I am trying to determine if a list of employees are on par to work at least 80 hours for the month. I have my table below called Labor_Insights. It has Agent_ID, Date_Worked, Staffed_Time(in seconds) fields. Below is an example of just one employee for a full month. I normally...

That's what I'm thinking. Everything I come across seems to only reference folders. I may shake down my IT department and see if maybe I can at least try it if it's not a huge issue. Figured I'd ask here first just in case. Thanks for your help with thhose links. They were very helpful!

Thanks Gina. Those are great respources. Unfortunatley it does not reference the length of server names,just the folders.

I've always practiced to keep my backend table names to no more than 8 characters because of speed issues. Can anyone tell me if this also goes for the server name? My current location looks like this now \\orld71-testing-a\Finance I am wondering if changing the server name would help with...

Thanks! That helped a lot.

Hey, I am using Excel 2007 or 2010. I am currently using the indirect function in Define Names to accomplish dropdown 2 to populate a separate list of items based on what is chosen in dropdown 1. Is it possible to have a 3rd dropdown to populate a separate list of items based on the same...

I think it should be this. "EMPLOYEEREVIEWID = " & Me.lst3month & " -Gregg

I find that video tutorials such as the one on this site are real helpfull. There are a lot on youtube as well if you do a search. After you get the basics, this access forum is amazing for finding great code to do what you need. http://www.datapigtechnologies.com/AccessMain.htm -Gregg

I should have known there was a solution for that. I'll look up late binding and try that out., Thanks Gregg

I think I found the issue and you are correct Bob. I have a form that runs in the background on open that has a timer on it that checks to make sure the network is still availble. This is where I had the link to the network that was having problems. Thanks again for your help. Gregg

I could be wrong, but if they have a "Missing Reference" and you have them uncheck it, you still may need to set the proper reference if code is running that requires that reference. This happens a lot to me with the Microsoft Excel 12.0(2007) reference when someone with Microsoft 11.0 (2003)...

Unfortunatly I don't have admin rights so I can't install V-tools. I'll search my code to see if there was something I may have forgotten about that referenced the old tables. Thanks again for the tips Bob. Gregg

Hi Bob. There are no hidden tables in this database. I do have "show hidden" checked off just in case but that doesn't seem to be the issue. All of the other objects in the frontend are non linked tables. This datbase was made in access 2003 in 2000 format and I is now being used in access 2007...

I have been having problems with one of our network drives going down every day. When this happens, my shared access databases are useless untill the network problem can be solved. I have a my backend split on the network and all user have a frontend stored on their desktop. I decided to change...