Topics Search

Database Project

Database Project
Views: 0
I am currently working on a project where I need to import spreadsheets with a list of various companies and their respective information (i.e. company name, location, revenue, growth, etc.) from excel.
My boss then wants me to create a field with a check-box for companies that are already our clients and a field with a check-box for companies that are "trash" and we aren't interested in. I would then run a query filtering out the "trash" companies. All of this I know how to do.
This is where I have a problem.
He wants to be able to periodically update these lists every six months or so with the updated company information, but doesn't want to have to re-check if a company is client or trash...
Sponsored Links:

More topics

 

Database Project for Class

Preview
So I am relatively new to Access and also I happen to be in a Access 2010 class at my college. The class requires a project for which I have chosen to create a database for another project in another one of my classes. The database is for a used book store for used textbooks. I have begun to work on the database for this project. However I was hoping to get any advise on how I might go about creating this database and also what design should I use to make a successful and effective database?
 

Database Project for Class

Preview
So I am relatively new to Access and also I happen to be in a Access 2010 class at my college. The class requires a project for which I have chosen to create a database for another project in another one of my classes.

The database is for a used book store for used textbooks. I have begun to work on the database for this project. However I was hoping to get any advise on how Imight go about creating this database and also what design should I use to make a successful and effective database?
 

Change database where data is stored with a dropdown box

Preview
The company wants to open a database that has the forms reports queries in it and using code behind a dropdown box pick which project the tables come from. This is project management software and each project is stored seperately. Since one engineer could work on several projects they want to switch to a new project and relink the tables without having to open up a new database. i.e. Database one has the forms, queries and reports. Database 2 and 3 are for project 1 and project 2 and contain only the tables. Can I point Database 1 at the first one and then switch and point it at the second one
 

Database not opened because the VBA project contained in it cannot be read.

Preview
Our database, created on an Access 2010 32-bit Windows Vista machine, that worked yesterday produces the following error when opened with a an Access 2010 64-bit Windows 7 machine:

'The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes code from modules, forms, and reports.

You should back up your database before attempting to open the database and delete the VBA project.'
 

Error Opening Access

Preview
When deleting a form, Access crashed. When I reopened it, I received the following error message:
The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA Project.
To create a backup copy, click Cancel and then make a backup copy of your database. To open the database and delete the VBA project without creating a backup copy, click OK.
 

Front End Setup for Different users

Preview
I have a database set up for our Construction projects. I modeled it so each project would start with its own database for time constraint reasons. I would like to have a back end and front end so that my boss can look at all projects from one back end db and the project managers will only see the forms/reports relevant to their project. I know I can use the project # as the primary key, but how would I go about making the front end databases only show information relevant to a certain project? I don't want them to have to enter their project number each time, I want it to automatically filter once they have entered their project information one time at job start-up. Do I have to go into each form at set up filters
 

Form Filter problem

Preview
I am having problems with my switchboard and the filter on load command. I currently am wanting to be able to select a PROJECT from the lists of projects and have it open the project on the Projects form. The current filter code is:

[PROJECT]=[Forms]![OWNERSHIP SWITHCBOARD]![List55]

Project is the project I want to select and list55 is the area that the project is selected from. It is opening the project from the data that had been entered before upgrading the database to access 2010, and any new projects that have been added do not load with this filter it just opens a blank form. Am I missing something?
 

Project Milestone Planning

Preview
I have created a Project Tracking Database in MS Access that is essentially a more tailored version of the Project template you can download from MS.

What I am stuck with is I am trying to add a Project Milestone Planning table as an extra tab in the project details form. My project details form looks like the attached form. What I am trying to add is a number of editable cells by month (AP) going forward for the next say 10 years that the user can enter text into, like the attached.
 

Delete record only when fields are filled out

Preview
I have a project tracking database. Project Managers update their projects on the table via a form. Once the project is closed I have a button on the form to delete the project from the "active project table".

I already have an append query that brings the record to the history table, so I'm not worried about deleting the record from the active project table.

I want to write VBA for the button into the "on click" event to only delete if certain fields equal a value, and if not spit out an error telling the Project Manager they need tofill out those fields before they can close the project.
 

Auto numbering based on selection

Preview
My database contains project details. A unique number is assigned to each project. When adding a new project through a form, I would need an automatically entered project number based on which partner is selected.

The project number needs to be *last (highest) project number for the selected partner* 1. If it's a new partner and no previous number is found, it should return the value "0". Partner names and project numbers are only stored in the table what I am writing with the form.

partner
project number

partnerA 2010000001
partnerA 2010000002
partnerA 2010000003

partnerB 2020000001
partnerB 2020000002

In this example
if selecting partnerA from the drop-down, 2010000004 should be the automatic project number
if selecting partnerB from the drop-down, 2020000003 should be the automatic project number