Results 1 to 5 of 5
  1. #1
    scooby7774 is offline Novice
    Windows XP Access 2000
    Join Date
    Jan 2010
    Posts
    1

    Help with Access Project


    I am trying to create a customer fleet managment Database. The purpose of the database is to catalog customers vehicles and the replacement parts for each vehicle. I have created a customer table , vehicle table and a table for each catagory of replacement parts. I am having problems creating a easy to use form for accessing the data for each vehicle and entering data. I would like to be able to first select the customer then the vehicle and then the data is displayed an available to edit. Help would be appreciated. I can supply the database if needed.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    You are almost certainly going to want to use a MainForm/SubForm arrangement.

  3. #3
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    >> and a table for each catagory of replacement parts.<<

    This may be incorrect.

    If you could post a copy of your database someone will have a look and get back to you.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Have you ever reviewed Tony's system?
    http://www.granitefleet.com/

    Disclaimer: I have nothing to do with Tony Toews and have not used his system.

  5. #5
    carlmdobbs is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Location
    Maryland
    Posts
    26
    I'm Carl Dobbs, an Expert. I think you need a lot of advice. I can spend an hour with you on the phone. I can call you. Just email me the request. I'm a professional and I am happy to give out advice. It is just that what you are asking is very complex. You want to do a database without being a professional. I think I am able to steer you in the right direction. There is just so much to know. My number is 301-534-6052. I am not always available but you can leave a voice mail.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access project and im clueless
    By accessnewguy in forum Access
    Replies: 2
    Last Post: 11-30-2009, 11:53 PM
  2. Replies: 0
    Last Post: 10-29-2009, 08:55 PM
  3. Access project
    By petesavva in forum Access
    Replies: 0
    Last Post: 10-21-2009, 02:37 PM
  4. Slow Access 2007 Project
    By pbyrum in forum Access
    Replies: 0
    Last Post: 10-23-2008, 05:43 PM
  5. Access Novice Taking On Large Project - Need Guidance
    By gtangjr in forum Database Design
    Replies: 1
    Last Post: 04-04-2008, 08:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums