Equipment Tracking Db

Dec 31, 2007

I need help finding an existing or making a db. This db does not have much to it, so I am getting frustrated finding/making one.

My company has equipment that is stored in one of three places, customers, trucks of employees, and other(like warehouse, or out for repair). The db should be able to give me a report of where everything is on a given day, and a report of what was in a given customers property during the job(this is not for a single day, but for the duration of the job).

If someone knows of an existing db like this, I would appreciate a link. If you want to help, it is appreciated. At this point I would not mind paying someone to do this for me, as long as it wont cost too much.

View Replies


ADVERTISEMENT

Equipment Reservation Db

Jul 11, 2006

I am currently creating a data base in access for reservation of audiovisual equipment. My form provides the selection of the equipment, the date and hour to be used and hour to be returned. My mayor concern is to not reserve the equipment twice(same day and hour). I want to be able to have a message telling the user that the equipment is not available upon the selection of the hour. Any ideas on this.

Thanks

View 2 Replies View Related

Equipment Control Db

Jul 12, 2005

Hi

I am new to db and would like to do a simple db for items of equipment going out and coming back in showing who has been allocated what.

So one person could have many item but the item can only be issued once until it is booked back in. I would also like a history of transactions.

Only something simple, so we have a record who has what if we need to find something and when they had it etc.

Many Thanks

Scott

View 5 Replies View Related

Equipment Rental Database

Oct 13, 2007

Hi, I am new to access and was if someone could assist me in designing a database exactly like the rentmaster software on this website(http://www.rentmaster.info/trial.html). I was told to design a database just like this one but, I am not all that familiar with ms access 2003. I've try searching google and microsoft's website for database templatesand I didn't see anything similiar to it. Any help with this is greatly appreciated and if I didn't go about posting this in the correctly, I am extremely sorry. Please don't hesistate to tell me and/or guide me to the right place.


Thanks, Val

View 6 Replies View Related

Randomly Selecting Equipment Number

Dec 28, 2006

I have a table that consist of equipments. In it is a equipment number field. I need a way to randomly pull up these equipment numbers-kind of like a lottery. Please help.

View 2 Replies View Related

Creating Equipment ID's Automatically From Departmental Info

Jan 17, 2005

Hello,

I am starting to get further into access development, originally i started from a sample database and have been teaching myself as i go along. This database has come pretty far and the farther it comes along the more my company demands of me from it!

either way, it is basically a database that holds all of our asset information, equipment parts, workorders and preventative maintenance. We've been plugging along just fine but I want to help their productivity and have access automatically create "Equipment ID"'s from information that is entered by the person adding an asset. I would like it to create an ID from Entry of the Department, Location, and then a 4 digit Autonumber after that.

Basically we have a few basic departments, IT, Facilities, etc. and a few locations... So we have been setting our equipment ID's like this:

AA - Two characters for the Location
BB - Two characters for the department
0000 - numbered field

So I really would like to be able to create these automatically instead of manually typing them in to a text field with an input mask.

AABB-0000 to automatically create entries from the departmental info, location info and then automatically create a 4 digit number in order to follow it.

What is the best way to do this? Keep in mind I am just barely able to do any code, I only have been going from what i see in the database and building upon it and learning a few bits and pieces of code from there. So if you start going into a code explaination go slow~!

Thanks,
Jim

View 4 Replies View Related

Queries :: Equipment Check In Form That Will Update One Record?

Mar 12, 2014

I have a transaction table the last record is [EquipIn]. during the equipment checkOut process all the other headings in the table are filled in. The idea is to fill in the [EquipIn] record a couple of days later when the equip is returned. How the heck can I make a equipment check in form that will update that one record? I can't do this manually as we have 1000+ pieces of equipment.

View 13 Replies View Related

Equipment And Personnel Check In And Out Database Using Barcode Reader

Jul 31, 2013

My desired output of this is to have a database to allow me to quickly check in and out equipment and personnel using a barcode scanner. I am using access 2013 and started with the asset tracking template downloaded from Microsoft. Where I am hung up right now is adding the personnel check in and out (each member of the team will have a barcode attached to their id) I want to be able to just scan their badge when they show up and again when they leave. At the end I will run a report that shows who was on scene (it is for a search and rescue team) during a certain day or time range.

I have added two new tables one check in and one check out the only fields are firedeptID and CheckIn or CheckOut a date/time field CheckIn and CheckOut Auto populatewith Now(). The first problem is that I think I need to turn off (if possible)the auto creation of a new record every time, when I scan in an ID right now that record gets the time stamp of the last time the new record was created IE.Last week when the last person scanned in and the new record was created. I assume I am going the same type of issue when I start working on checking out the equipment.

View 8 Replies View Related

Queries :: How To Get A List Of ALL Equipment Showing Most Recent Date And Time

Mar 23, 2013

I've got three tables:

Code:
tblequipment
equipmentid
equipmentnumber (user defined ID)

tblrentals
rentalid
rentaldate
rentaltime
fromparty (c for customer, e for employee, o for other)
frompartyid (foriegn key to either customer, employee or other)
toparty (same as from)
topartyid (same as from)

tblrentaldetails
detailid
rentalid
equipmentid

How can I get a list of ALL equipment showing the most recent date and time, also showing the respective toparty and topartyid? I can get it fairly easily, except for including toparty and topartyid.

View 2 Replies View Related

Modules & VBA :: Machinery Database To Match Parts Up With Equipment - How To Do Custom Sorts

May 24, 2014

I am creating a Machinery database to match parts up with equipment. So they can see what the Equipment is and all the available parts. The sort needs to be like this

First Sort:

If the manufacturer of the machine is the same as the manufacturer of the part sort that at top then sort alphabetical

Is this possible? Each equipment would have a different manufacturer so I can not do some type of hard coding.

View 1 Replies View Related

Convert Listed Dates To Duration To Calculate Equipment Rental Fees

Apr 7, 2015

I'm new in access I working on DB for my company equipment

I used tables and queries and reached to the following query

Query name (02-By Project)

KSC_NO From_Project To_project Date_of_Trans
K-01-037 52500 12013 02/14/2014
K-01-037 12013 52500 03/31/2015
K-01-037 52500 12013 04/07/2015
K-01-129 52500 12013 03/03/2015

I want to make query to give me the following

KSC_NO IN_Date Out_date Duration (months)
K-01-037 02/14/2014 03/31/2015 13.6667
K-01-037 04/07/2015 Today 0.0333
K-01-037 03/03/2015 Today 1.2

Is that possible?

View 5 Replies View Related

Training Tracking

Sep 1, 2006

Does anyone have a sample training tracking system / database they'd be willing to share?

Or, barring that, can someone point me in the direction of where I might find one?

Thanks in advance! Looking forward to it!

View 3 Replies View Related

Tracking Training

Sep 12, 2006

Does anyone have a sample training tracking system / database they'd be willing to share?

Or, barring that, can someone point me in the direction of where I might find one?

Bee replied once, suggesting I look in the Samples Databases section of this forum, but I could not find anything even remotely related there.

All replies are gretly appreciated!!

View 5 Replies View Related

Tracking Training

Jan 4, 2007

I have a DB I'm using to track training for assigned people. Right now the training gets put in the DB at the end of the day by going through each persons record and adding the training that they did for the day. As you can see when training 30+ people a day, putting this in the system can take awhile. I'm trying to find a way to do a mass input to cut down time and could use some help with this.

My tbls are as such,

1st Table:EMPLOYEEtbl
EmployeeID
EmployeeName
(Other information)

2nd Table:CLASStbl
className
classID

3rd Table:CompleteClasstbl
EmployeeID
classID
DateTaken

What I like to do at the end of the is select the ClassID/DateTaken items once and then type in a just the 30+ list of employeeID's click a button and append it to the my 3rd table. Of course writing it out like this makes me think it should be easy but for some reason I'm lost. Does anybody have any suggestions?

View 5 Replies View Related

Tracking Synchronization

Jan 25, 2008

Is there any way in access 2003 or 07 to track when a database was last synchronized with any one of it's replicas?

It would be useful to know and be able to store this in a table.

View 4 Replies View Related

Bug Tracking Solution

Feb 12, 2008

Hi,I'm looking for a bug/issue tracking solution done entirely in MS Access. Does such a thing exist?My requirements are that it must need only Access, and be accessible in a shared environment solely by opening a .mdb file from a shared folder. It must support various issue lifecycle related things, and the stuff those tracking systems do in general.It may or may not be commercial software.If anyone knows of such an available solution, please let me know.(And yes, I've searched on Google, and haven't found anything worthwile, so that's why I'm asking here now.)thx

View 5 Replies View Related

Need Better Tracking With My Tables

Oct 19, 2005

I have a DB thats working fine, but (there always is a but) I now need to do something a little bit different. I need to be able to track my originators and who they have brought into the company. So I will have an originator and many down-line originators, and these people that come in down-line will have people coming in down-line from them and so forth and so on. I have a table that has all originator info and originatorID, but will I need another table or can I just add to the exisisting one. Here is the table structure:

‎Originators:
-------------
OriginatorID -autoNumber
FirstName - Text
LastName- Text
OrigSSN- Text
Address- Text
City- Text
State- Text
PostalCode- Text
HomePhone- Text
WorkPhone- Text
CellPhone- Text
FaxPhone- Text
EmailName- Text
BirthDate- Date/time
Level- Text


If more info is needed please let me Know.. Thanks in advance.

Scott

View 4 Replies View Related

Tracking Changes To Database

Mar 26, 2008

Is there a way to track changes made by different users to access tables? For instance if several users update or change data in various records is there a way to track when and what was changed (before and after data)?

View 1 Replies View Related

Tracking Updates

Sep 22, 2006

I have read all of the audit trail stuff and searched on my subject but I think my solution could be simpler,

All I want to do is copy the values of the current record on my form into a history table with all the same fields.

Example Form:
[ID], [Machine], [Task], [Task Due], [Task Complete]
I want to put a button on the form that reads complete task and when the user pushes the button it copies all of the details for that specific record they are looking at into my History Table that contains all of the same fields.

This will give me basic history on when each task was completed for a machine and I can access for reporting

View 1 Replies View Related

Tracking Database Help

Oct 10, 2007

I consider myself an intermediate ACCESS user and can get around it with little trouble with the help of the internet and the help file.

I am trying to design a database that is fairly simple in design, it is for tracking the status of documents at our work center. Basically we have personnel reports that are passed around the different people and different dates.

I have a main form that has the info on the person along with dates that it is due.

Then a sub form that has the date sent and where it went to.

My problem lies in that I want to keep track of the whole history of the document but when i print out a report or export the data to excel to put up in powerpoint I need to have just the most recent date sent only item.

I have 2 tables one with user info and another with the routing info with its own primary key along with a identifier key to link the primary and sub form.

Of course it is easy to create a report with the data to show all the different routing steps but not just the one with the most recent date.

Thanks in advance for the help.

View 10 Replies View Related

Bug Tracking Solution

Feb 12, 2008

Hi,

I'm looking for a bug/issue tracking solution done entirely in MS Access. Does such a thing exist?

My requirements are that it must need only Access, and be accessible in a shared environment solely by opening a .mdb file from a shared folder. It must support various issue lifecycle related things, and the stuff those tracking systems do in general.

It may or may not be commercial software.

If anyone knows of such an available solution, please let me know.

(And yes, I've searched on Google, and haven't found anything worthwile, so that's why I'm asking here now.)

thx

View 4 Replies View Related

Question-Database Tracking

Nov 12, 2005

I would like a field on my main switchboard that displays the last time the database was modified.

Simple question, and I can not find an answer anywhere.

Thanks!

View 6 Replies View Related

Anyone Try Tracking Org Charts In Access???

Jul 6, 2006

I'm trying to set up a database to track a huge group of corporations. There is the parent company, then a bunch of subsidiaries below it. Some subsidiaries have another layer of multiple subsidiaries below it, some have none. Any thoughts as to how to do it???

View 1 Replies View Related

Tracking Employee Training

Aug 18, 2006

I am tracking training for employees. I have a database that keeps track of the dates a particular training was taken. Employee training is ongoing from year to year. I have an Employee Training with a subform showing only the specific employee's training. I need a help with a few things. I need to keep track of training by the year. If I enter 2006 dates it will show in one line, if 2007 dates, another, all the way across the list of training classes for an employee. I also only want to limit a person enter more than one date for a particular class for a calendar year...Are these things possible. I have attached the database. Please help, make changes and suggestions. Thank you so much in advance.:eek:

View 3 Replies View Related

Paper File Tracking DB

May 30, 2007

Hi there,

I知 new here so don稚 shoot me if I知 asking something that is inappropriate. I知 looking to make a DB for paper file tracking simular as you would expect in a law firm.

I don稚 want to reinvent the wheel so I知 asking if someone has built something like this before. I知 also looking at barcode ID which I have no experience with at all.

Is there someone out there that can put me on the right path?

Cheers,

Renoir

View 3 Replies View Related

Issue Tracking Database

Jun 28, 2007

Hi team.

I've had a bit of a search around the forums and haven't found this anywhere.

Does anyone have a sample issue tracking database for an IT department?

I don't have too much Access experience so am looking for a little bit of a headstart on this. It seems relatively basic though.

The fields I think I will be needing are the following:

Log No
Status
Priority
Type
Project
Raised by Person
Raised by Department
Description of Issue

Status
1 Active
2 On-Going
3 Hold
4 Finished
5 Cancelled

Priority
1 High
2 Medium
3 Low

Type
1 Bug
2 Enhancement
3 Other

Project
1 Lotus Notes
2 File Maker
3 Tumbleweed
4 Windows
5 Microsoft Word
6 Microsoft Excel
7 Microsoft Outlook
8 Adobe Acrobat


Raised by Department
1 Research & Development
2 Customer Service
3 Finance
4 Data Solutions
5 Communication Services
6 Production
7 Stores
8 Operations
9 Other

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved