Related Topics

Human Resources (hr) Database

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


Building an Estimating Database
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.


Looking for a Good Template
I am looking for a good Human Resources Template in Access.


Introduction to Microsoft Access and VBA
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.


Construction Cost Estimating
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:

Unit Prices
Complex Resources
Simple Resources

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


Adding, updating and deleting thorugh a form
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.


This Guide brings you the best in Access resources
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.


10+ reasons to use Access
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.


Runtime Error 3075 - Access 2010
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.
[CODE]
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.


Rogue Resource Parameter
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,


How to create localized resources.resx in the IDE
This is a question about creating localized resources for VB projects. I can easily add resource strings to the file resources.resx. To localize these strings, I need to create a localized version of the resource file, for example resources.de.resx for German.

Does the IDE provide a way to do this?

I actually created a localized resource file by hand in the "My Project" directory and tried to added it to the project (via "add existing item"). it copied the file down into the main project directory. Normally I would keep original resx file and the localized resx file in the same directory.


Different Table
I've created a form that so far does a couple of things.

First: The form will record the users name, E-mail address, and the User type (Human Resources, Security, etc.)

Second: It also takes the current date and the current time and inputs them into two seperate text boxes.

My question is this, How do I take the information garnered from the Date and Time boxes and, when I push a button, the two are saved to a different Table for recording those specific things.

All previous information, name/e-mail are to be saved to a user table seperatly.


Use form List Box to query Active Directory
Scenario: Have an Employee Roster database. Would like to intergrate this with Active Directory (AD)

How: Would like to have the Human Resources (HR) user select a new employee's name from a list box.
The list box would query AD and list all the active user names.

Goal: Due to our check in process all new employees must see the Helpdesk to get a network account, I would like limit as many discrepancies between the Employee roster and AD as possible.

What have I done:
I can import AD information in to the Employee roster that works.
However, there is a performance lag when running the new import " Takes about a minute to complete ".
Also sometimes there is a timing issue. For example Account Created in AD but import has not run yet.
So, I thought I would ask this question.

Can I use and Access form with a list box to query AD for user information?

Edited by: grafiksinc on Sun Nov 29 20:59:45 EST


Designing Your Own Access 2013 Database
In this lesson, you will learn how to create a database from an existing template. You will also learn about other resources you can use to learn database design.


Best way to represent a relationship in a Form
I got lots of help with my last question so I figured i'd try again with something else .

Now what I have is two tables: Resource, and Project.

What I want to do is be able to add many resources (with a percent required) to many projects.

My initial thought was to create a table ResourceOnProject with ProjectID, ResourceID, ResourceName, PercentRequired. I then created a form with only Resource Name, and Percent Required displayed as a Multiple Item form. I then thought I should add this form into my Project form so my-coworker could select between one to many resources on the project.

Two questions:
1 - Is this the best approach?
2 - When clicking on the Add Project, or Update Project buttons, how will I update my DB to record all of the proper relationships between projects and resources


Many to many relationships shared table?
I am only new to access but am at the moment creating a Human resources Data base which will contain all employee information as well as various reports such as incident reports and non conformance reports but be able to link employees to reports.

I am not sure if this is correct but:
to solve the many to many relationship, I have created two forms (one employee reports number, the other report number) and have linked them via a subform. This is working fine for my incident report.

Only I am unsure how to proceed with my other forms. Will I need to start the same process again, or am I able to use both the employee report number table and the report number table for different forms, or maybe just the employee report number?

I want to keep things as simple as possible in the even that someone else needs to create a new HR form in the future.


Suppress Office warning when running batch file from within access 2010
I have a batch file that runs when I click on a command button on a form. It makes a backup of all my files and resources for the database. When I click the button, Access gives me a warning saying:

Opening G:\PayrollDataCenter\Data\Resources\PDCbak.bat
Some files can contain viruses or otherwise be harmful to your computer.
It is important to be certain that this file is from a trustworthy source.

Would you like to open this file?

Yes/No

Is there a way to keep this window from popping up?

I've tried "DoCmd.SetWarnings False" but it didn't work


Subform in continuous form
I'm trying to set up a form so that I Have a Project list and its associated resources in a subform. When I try to add the resources subform, I get an error stating that I can't put a subform in a continuous form and then it puts the form type back to single

Is there a way to go around this limitation? Right now, what I'm planning on doing is to build a huge textfield with the concatenation of the info I need, but that way I can't change the data, which is the most desired way of doing it


Access 2010 Designing Your Own Database
Now that you know how to use and modify existing databases, you might be interested in designing your own. Database design can be very complicated-- so complicated, in fact, that people take extensive courses just to learn how to plan databases. For that reason, we haven't focused on creating a database from scratch in this course. However, we can help you get started.
In this lesson, you will learn how to create a database from an existing template. You will also learn about other resources you can use to learn database design.


Get started with Access programming
When you create a new database, you typically begin by creating a few database objects such as tables, forms, and reports. Eventually, you reach a point where you need to add some programming to automate certain processes and tie your database objects together. This article helps orient you to the programming tools in Microsoft Office Access 2007 and points you to some resources where you can learn more about programming.