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 Replies


ADVERTISEMENT

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

DVD Rental Database

Apr 3, 2007

Hello all,

I am a student and in need of some serious help. For our Coursework we were told that we needed to create a database for a company of our choosing. I did some research and decided to pick a DVD rental shop as i thought this would be a good idea at the time. Now its come the time to actualy start making the thing and i am in serious trouble..i have no idea how to use access..i have tried going through all the tutorials but they confuse me more!

all i have so far is 4 tables..customers..DVD's..rentals.and Suppliers..i need to know how to create a input form so i can add new customers but when i try to create a form and then go to pick out the feilds..there is no fields to choose from!

i really really really need some help here.

thanks foe reading

Jon

View 14 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

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

DB For Rental Company

Dec 26, 2007

My company rents equipment to our customers. I am looking for a db to track our stuff. There are three possible locations of everything. Warehouse, employee trucks, and Customers. I assume that warehouse can be added to the employee table. I can set up these 2 tables and one for our equipment list, but the hardest thing I am having with is with the table for transactions(I believe it should be a table), this needs to allow batch transations, because typically more than one piece of equipment is moved at a time.

I will need a report that will show each equipment id number in a customers home from date to date (date it was placed and date it was removed), one that will show a list of all equipment locations on a given date, and one more that will show equipment that has been in a customers house for 5 days or more so I can verify that it is still there, becuase equipment typically should never be with a customer for more than 5 days.


Right now I am using excel, but its not working well. I would greatly appreciate some help! The attachment only has the info I need for the 3 tables I mentioned above that I know how to do, and my best guess at what the transaction table should look like.



See atached.

View 8 Replies View Related

Cottage Rental Problem

Dec 27, 2006

I've created a database consisting of 10 tables in total (see image).

I've had no problems constructing the database, however when I come to create a booking form I came across a problem. If I add in payment details into the booking form, it won't show records or let me add one, if I take payment details out it works fine.

This makes me think there is possibly a problem with how I have linked the customer and payment tables together but having problems seeing where I am going wrong, could anyone offer a little help?

http://img222.imageshack.us/img222/2915/screene1fn8.png

View 2 Replies View Related

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

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

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

Database Size Limited To 2GB / Query Multiple Database Without Linking Tables?

Sep 7, 2011

I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:

1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.

2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.

I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.

View 3 Replies View Related

Forms Count Of Other Database Without Opening That Database Physically

Oct 7, 2005

Hello All...

Well, I am facing one problem..in my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..

Set AcApl = New Access.Application
Call AcApl.OpenCurrentDatabase(strfolder, True)
Set AcProj = AcApl.CurrentProject

Set frm1 = AcProj.AllForms

intCount = frm1.Count

But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..

Thanks in advance..!!

View 4 Replies View Related

Modules & VBA :: Open Database / Run A Query / Close Database

Aug 22, 2014

i have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.

View 4 Replies View Related

General :: Updating From Local Database To Central Database

Sep 12, 2012

Database: Access 2007

I have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems.

Now what I would like to do is have all these local databases write to a central database say every minute but only write new records to the central database. The Central Database can either be Access or SQL.

What is the best way to do this?

View 1 Replies View Related

General :: Database For Metal Market Prices To Be Used In Another Database

Jun 24, 2015

I have been working on a database for over a month now, and my boss just threw a monkey wrench in my work. I believed that the Metal Market Prices would be entered once a week in the current DB. My boss informs me today that he wants an employee to go in every morning and enter that days Price for Each Metal with respect to many different markets.

There is a total of 12 metals, and 5 markets. I need the data to be stored first by date, then by either market or metal, and lastly by which ever isn't used second (Either: date-market-metal, or date-metal-market). I think the Latter of the two methods makes the most sense. Is it possible for my current DB to lookup values from the Metals Database based on date-metal-market?

View 14 Replies View Related

Jet Database Engine Error On Non-shared Database

Jul 7, 2005

I have a problem that seems to be happening on several users' databases and is causing a big problem. None of the databases is a shared database...they are all single-user databases on stand-alone computers. I have tried looking for help within previous posts, but all seem to be related to shared databases.

I am getting an error message: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." The database cannot be opened, imported, repaired...nothing seems to work.

Again...these are NOT shared databases. I appreciate any help I can get. I created the database for all of the secretaries in our school district to keep up with absence data. It involves many tables, queries, forms and reports, and has generally worked well. However I am now seeing several that are getting similar errors as mentioned.

Thanks!

View 3 Replies View Related

Best Way To Import SQL Database To Local Access Database?

Dec 25, 2005

I'm new to Access and VBA, for the record. What I need to do is copy a SQL database (table structures and records) and save it as a local Access database, so that the user can query and make any changes on the local file without editting the SQL database.

Looking around, it seems like the best option would be to use the TransferDatabase method with the acImport option. Does this sound reasonable, or can someone with more experience suggest a better way to go about it? Thanks.

View 3 Replies View Related

Tables :: Create A New Database Y And Link To Database X

Aug 28, 2013

I am testing the security of my DB X on Acccess 2007. I could create a new database Y and linked to the database X. Unfortunately i could change the records on the tables. I don't want other DB that make connections to my DB to change my tables!

View 1 Replies View Related

Accessing A Table In Database A From Database B

Aug 29, 2005

Is it possible to access a table in one Database (Database A) from a separate Database (Database B) and if so how. I should clarify that this is an Access Database.

View 2 Replies View Related

Create EXE From Database And Have Several Project Using Same Database

Oct 24, 2013

I created a database with forms, querys, etc. Now I was thinking of creating a exe so everyone can use this database without having access to all the design functions.

the only problem I see about doing this is if we need to use the same database for different project, we need to always create a new exe for each project.

Is there a way to make a empty database exe with just the layout, querys etc but with no data on the tables and have a save, open and save as option. So we can have several projects using the same database?

I was thinking to create a VB code for the database to delete all data on the tables when the database is open.
and before closing the database exporting all the data to a txt file or something.

Then the next time someone opens the database goes to the main form which has a open bottom which imports the txt file into the tables.

This way we can have several txt file for several project and use always the same exe database.

View 4 Replies View Related

Linking To Another Database From On Database

Nov 20, 2006

I am working on a database that will be an addition to an existing one on the company server. However, to make the overall layout not so complex and allow room for other additions in the future, I'd like to keep the databases separate. This will also ensure more efficiency, integrity and troubleshooting overall.

Does anyone know how this is done?

Thank you in advance for your help,

~Kilch :eek:

View 4 Replies View Related

How Can I Save My Database As A MDE Database.

Oct 2, 2007

The menu for make a MDE file is blanked out or grey’d out. The database is partly made using access 2000 then xp

Jabez

View 6 Replies View Related







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