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:

Similar posts...

 

Database Project for Class

Database Project for Class Icon
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?
 

Change database where data is stored with a dropdown box

Change database where data is stored with a dropdown box Icon
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.

Database not opened because the VBA project contained in it cannot be read. Icon
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

Error Opening Access Icon
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

Front End Setup for Different users Icon
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

Form Filter problem Icon
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

Project Milestone Planning Icon
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.
 

SQL Database connection error

SQL Database connection error Icon
I'm not sure if this is the correct spot for this thread so here goes.
I created an access project using link tables to a SQL development database. I finished the project on the development side and need to connect to production database. I created the SQL user objects on production database, validated that the user can connect directly to database via SQL Enterprise manager. Created ODBC connection on my laptop and tested connection. Modified Global module for the SQL connection for the VB code to point to production database. Open the access project that now points to production database, typed in login credentials to receive user cannot login to database.
What else do I need to modify to point the access project to production database?
 

Access 2010 SP1 - You receive an error using the built-in wizards after installing SP1

Access 2010 SP1 - You receive an error using the built-in wizards after installing SP1 Icon
After installing Office 2010 SP1 onto a machine running the 64 bit version of Access, you may receive the following error when trying to use a built-in wizard:

"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."

you may receive any of the errors below:

Cannot update. Database or object is read-only.

OR

The Visual Basic for Applications project in the database is corrupt.

OR

Microsoft Access can't find the wizard. This wizard has not been installed, or there is an incorrect setting in the Windows Registry, or this wizard has been disabled.

Workaround:
 

Delete record only when fields are filled out

Delete record only when fields are filled out Icon
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.