Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







DVD Rental Database


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 Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Equipment Rental Database
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 !   View Related
DB For Rental Company
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 Replies !   View Related
Cottage Rental Problem
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 Replies !   View Related
How Do I Automatically Update Client Database From Master Database?
Does anyone know if there is a form or sample database out there that can check the version of a specific database a person is running on their pc against a master version; and if the 2 versions don't match automatically update the local version from the master version?

Is this possible? I would need the autoupdate to do Tables, Queries, Reports, and Forms.

View Replies !   View Related
Forms Count Of Other Database Without Opening That Database Physically
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 Replies !   View Related
Jet Database Engine Error On Non-shared Database
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 Replies !   View Related
Best Way To Import SQL Database To Local Access Database?
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 Replies !   View Related
Synchronise MySQL Database With Website Database
Hi,

I am trying to update the stock levels on our company website on a daily basis with those found in our stock system.

Our stock system uses MySQL for the backend and Access 2003 for the front end.

Our website (www.epactrading.co.uk) uses php and a MySQL database. The website was not built by me but is a piece of software that allows me to log into the backend and add products, categories, update stock levels etc. Unfortunately the company we paid the software for will not give me/tell me how to gain direct access to the MySQL database, apart from using the back end provided by them. I am assuming/hoping the the user name and password to log into the back end is the same to access the tables in the database.

Does anyone know how I can find out the table structure or gain access to the tables in the website database?

Also I cannot run my own php scripts on the server, which is how I was originally hoping to update the site.

Thanks for your time
Kevin

View Replies !   View Related
Opening Form In Different Database Using Criteria From First Database
I have two separate databases. I need to be able to open database 2 using a criteria of a field on a form from Database 1. I have successfully used the shell command to actually open database 2 but I can't get the correct form with filtered information to open. I have used the following code behind a button:

Dim Varset, varpath
Set Varset = DBEngine.Workspaces(0).OpenDatabase("S:RESETIB Station ModuleDSA USE ONLYIB Intelligence_be.mdb").OpenRecordset("Select LogIn.* from LogIn Where Login.[Hash ID] = '" & Environ$("username") & "';")
If Varset.EOF Then
MsgBox "User does not have an account. For access email rudy@madeup.com", vbCritical, "Invalid User Account"
DoCmd.Quit
Else
varpath = """c:program filesmicrosoft officeofficeoffice11msaccess.exe"" ""s:RESETIB Station ModuleDSA USE ONLYIB Intelligence.mdb"" /wrkgrp ""s:RESETIB Station ModuleDSA USE ONLYsecurity.mdw"" /user "
If Varset!Permission = 1 Then varpath = varpath & "agent /pwd randjont"
If Varset!Permission = 2 Then varpath = varpath & "Supervisor /pwd randjont"
If Varset!Permission = 3 Then varpath = varpath & "Superuser /pwd randjont"
Call Shell(varpath, 3)

End If

End Sub

Database 1 is sourced from and ODBC connection and database 2 is from a local table. They both have the same field (although named slightly different). Where do I put the query/sql that will do the last part of opening the Subject Form for the person with the common field value? Your help is greatly appreciated.
Tyler:)

View Replies !   View Related
Accessing A Table In Database A From Database B
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 Replies !   View Related
Linking To Another Database From On Database
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 Replies !   View Related
How Can I Save My Database As A MDE Database.
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 Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved