Help With Resource Materials
Sep 20, 2007Hey everyone,
I am looking for some effective resource materials (books) for the following topics and/or applications:
SQL
VBA
PL/SQL
SQL Server 2005
Thanks for any suggestions!
ADVERTISEMENT
Resource Use Database
Jan 13, 2008I need to create a database that tracks the usage of a resource on a monthly basis. I have the tables built that will track the contracts, clients, etc. In the contracts table I have a start date and an end date that are tied back to an inventory item.
My question is how can I shows these on a datasheet like this, so that is shows the inventory items and who has what that month.
Item Jan Feb Mar ....
INV#1 Joe Joe Barb
I set up the tables for the data I need to store, maybe the start/end date won't work.
Thanks,
turbow
Creating A Resource Allocation Table / Form
May 29, 2014I'm working on creating a resource allocation table for my small company. Basically, we want to be able to designate a certain number of "man-months" per functional group per month per project. Additionally, this database will hold the billing milestones that are associated with the project and we will track some health indicators to each of them.
For instance, we may have a project that is going to be running from May 15th 2014 to June 5th 2015. Based on an access project template I found, I have created some pretty good quality forms/tables that are working well for project inputs and milestone tracking.
Project Table
Lists the Project Name, Project Manager, Priority, Status, Start Date, End Date, and some baseline budget info.
Resource Groups
Lists the functional groups (Electrical Engineer (EE), Mechanical Engineer (ME), etc.) There are 9
Milestone Table
Project, Title, Priority, Status, Client Billing Amount, Schedule Risk, Technical Risk, Owner, Start Date, Due Date, and some budget lines and descriptions
Alright, So I can't for the life of me figure out how to structure the monthly allocations in a usable table/form. This is what I would like it to look like, similar to the excel document we used to track it in.
How can I create a table that will store all of the data (Project, Resource Group, Month/Year, and Man-months) with inputs from a form that will automatically show the relevant months (between project Start Date and End Date)...
Forms :: Timer Event Causing System Resource Exceeded
Dec 9, 2013I have Access 2010 and have made a small system that creates a table as a result of an query based on linked tables. The result is approximately 40 records that are grouped in 4 different priorities where each record has a status of green, yellow or red.
By using the timer event I want to loop through 6 different forms starting with the overall view and herafter priority 1 form, priority 2 form and so on. When the last form has been displayed start over again. Loop for ever until stop button has been pushed on the first form.
The timer is set to 15000 on each form, when I open a form the first thing that happens is that I close the previous open form.
After the system has looped 4 times it gets "SYSTEM RESOURCE EXCEEDED".
I have used 3 days on the internet to try to get a solution on my problem with no luck. I have got so far that it must be something with the timer function. Since if I run it manually (open form, close previously, open next form etc) then no issues.
I have the latest service pack for access 2010.
"Query Is Too Complex" And "System Resource Exceeded"
Dec 22, 2004These are the two results I get when I try to run or go into design view for the last few queries in a series of queries I've created for an estimating tool for my company. The reason I'm getting it now, is that I had to significantly alter the queries prior to these in the series. I need to alter these as well, but I'm thrown into SQL view, and with the amount of info, I'd be lost without the normal design view. Furthermore, it won't run anyway. I can't reduce the size and maintain a decent representation. Is there anything I can do with Access 2003, or will I have to resort to not doing this at all?
View 2 Replies View Related