Human Resources (hr) Database
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.
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:
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...
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.
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.
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.
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.
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
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.
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:
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?
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.
Is Access horrible for my database???
I am trying to create twenty user database. This database is used for employees to enter their budget. In theory we should have about 10,000 records max. Some people told me that I shouldn't use Access with msSql because Access is not reliable. However, I like Access because of customization and easy maintenance. Is Access so unreliable that I shouldn't use it? We have the resources to buy more expensive programs but we really like the fact that we can customize Access.
How to search the Database?
I have a database for the resources available. It has 3 fields namely Resourcename, Type of service and county.
How can I search the database choosing county and typing a keyword for Resourcename or Type of service.
I do not want to go to the form and use ctrl+H, instead use a search button.
System Resources exceeded
My client wants me to copy data stored in around 40 excelsheets to the access table. So I have done following steps:
1. Link all excelsheets in Access as follows:
File->Get External Data->Link tables
2. So after doing it I have 40 linked excelsheets in Tables tab.
3. Now I am going to write union query that will combine the data from all the tables.
Now when I write the sql union query then it gives me "System resources exceeded" message. So I tried to apply union to few tables first e.g 10-15 and it worked. I named this query Query1.
Now when I try to write union sql again to combine data from Query1 with rest of all the tables then again the same message appears "System resources exceeded"
Please guide me how can I combine all the tables together(They have the same format) as I want just one table that will store data from those 40 excelsheets