Search results

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...

Maybe the fields called labor not labour? Is charges a number or currency field? I think you would have problems if its a text.

One suggestion that helped me out was to give the backened a short name and place the backened as close to the root as possible. So instead of putting it in P:Folder/2ndFolder/3rdFolder, Put it in P:Folder. I can't tell you how much this helped one of my databases. Aslo, here is a link that has...

I orginally had a bill of material report where the report had a top header with the bill of materials information in the detail section. So every page showed the project number (primary key) on every page when there were multiple lines on the bill of material. I am trying to get the header...

Here is the code I use that has been working good for me. I execute it with the job scheduler that comes with windows. 'Read from a Microsoft ACCESS database Option Explicit dim oaccess 'execute another Access macro set oaccess = createobject("access.application")...

Understood. When you said something about data macros I did a quick google search and found a site that had a you tube video showing how it worked. Its great to see a feature like this is being added. I have'nt really done any research yet of the possible upgrades on 2010 however I think it may...