Human Resources (hr) Database
I would be pleased to know about any available human resources (HR) databases on which I can build. database (mdb included) or template on which I can build.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I work in Human resources and my company has very limited resources. I am trying to put together a database that will allow my employees to clock in and out on.
What I would like to happen, is to have a button to clock in, clock out, break in/out and lunch. When the button is clicked I would like to have the text box below the button display the date and time and time.
I have two tables; Activity Schedule and Resources. I would like to add many different resources to one activity from the activity schedule. I think i need another table but i am not sure how to set up the relationships effectively.
Eventually i would like a form where it has the activity listed in the top half and the resources listed in the bottom half and some buttons where you would click on them to add the resource to the activity. This would then calculate the cost of the all the resources for each activity.
I am looking for a good Human Resources Template in Access.
A database is a list of items stored somewhere to make their values easy to access or retrieve. This means that a database can exist anywhere, including human or non-human memory. A computer database is a list or a group of lists created as a project. There are various ways and various types of applications used to create such a list. To make it more useful, special computer applications are formally developed to help create and manage computer databases.
In order to create construction unit prices (the price for building a brick wall per m2 for example), I need to combine 'resources' to formulate a price per unit (per m2/m3/nr etc).
There are 3 areas to this:
I want the Unit Prices to be formulated in a form, with a sub-form to show the build-up of resources in the unit price...
The user add a record that includes the customer's id, the date and time of the visit, the term of the visit and the resources recommended on this visit. The resources are selected from a list box, so the code will add to the table as many records as were selected on the list box.
If the user selected 3 resources for this visit, the code will add to the table 3 records where the id, date and term are the same and what changes in each row would be the resources.
So later the user has the option of updating the resources for this visit, so the code is supposed to find a match in the id, date and term and then update the resource id in the table by replacing it with the one now being selected.
Where I am stuck is: the table might have more resources already than the ones I am selecting now, so the extra rows have to be deleted. Or the table might have less rows than the ones I am selecting now, in this case we would have to add a row with the corresponding info.
Microsoft Access provides an inexpensive yet powerful database solution for small-scale projects. This Guide brings you the best in Microsoft Access links and resources.
The truly smart and effective IT professional knows that there are many tools. The key is to know which database engine is the best for the job at hand. Why throw massive resources at a simple need? In other words, you don't want to pay for a Rolls Royce engine if you're building a go-cart. Knowing when and when not to use Access will help your budget and make you look good, whether you're a freelance developer or you're managing IT resources.
We use an access database for our Human Resources department. Recently we updated to Access 2010 on a couple of workstations. In Access 2010 we keep getting Runtime Error 3075 missing operator. I click debug and this is where the error is happening.
While playing with the code I noticed if I take out the "AND" in the bold line above. The error is removed within Access 2010; however, it creates the same error in Access 2007, 2003. We still have a couple users that utilize Access 2007 and need it to function properly in both instances.
This is a program that I have inherited and my programming skills are minimal at best.
I have worked on this for several hours already, or 2007; however, not in both.
I think this came about because a renamed a form in a windows application. Now whenever Itry to run the application I get the error message: -
Error 1 The item "obj\Release\DvdDatabase.frmDVD.resources" was specified more than once in the "Resources" parameter. Duplicate items are not supported by the "Resources" parameter. DvdDatabase
frmDvd is the one I renamed to frmMain.
Try as I might I cannot seem to find the "Resource" parameter mentioned in my IDE, VS Pro 2005,