Database Project

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:

Related Topics

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


Project Involving Table Relationships
So I've been given this project where I have to develop an access 2007 database where a query can be used to match employees to available projects based on employee skill set and required project skills.

How should I go about this?

I've tried making a bunch of tables and relating them, but its not matching employee skills to project skills


SQL Database connection error
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?


Look up a value from one table to another
I have database with 2 tables in it, its my sample tables the 1 st table is Projects where i have 3 feilds the first one is serial no and the second one is Project where the data is unique and this is primary field and the third feild is having the project engineers name.

The second table multiple feilds available but the project number feild has been set as primary key, what i need now is when some one enter the project number the project engineer name should appear automatically with out any manual input.


Access 2010 SP1 - You receive an error using the built-in wizards after installing SP1
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:


Depolying ACCESS 2010 runtime
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.

My developing environment is Office 2007 ACCESS 2010. My runtime environment is Office 2007 RUNTIME ACCESS 2010.

Both ACCESS Development and Runtime are under SP1 32 bit


Access 2010 64bit import error
I tried to import a text file and an Excel spreadsheet into an existing database in order to create a new table and received this 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 code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project." When I click OK to delete it I get a message that says essentially that wizards aren'tworking, there is a registry error, I can re-run setup or re-install the wizard using the add-in manager.

The only way I could get the data was to get an associate create the table on their computer and send it to me.


Access 2007 error 3800 'ID' is not an index in this table
I'm working with Access 2007 and have never had this issue, but it's causing me MAJOR headaches. . .whenever I open my DB, this message pops up with a button for OK or Help. Help does nothing and if I hit OK, I have to use Esc to get through the number of records I have with this issue until it's gone through the whole DB.

Then sometimes (but not everytime) I get a message that says "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. Your should back up your database before attempting to open the database anddelete the VBA project."


Cannot open VBA code
A few days ago my database suddenly started pumping out this 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 form modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project."

This message appears every time a form with VBA code is opened, and every time I try to open the VBA editor. Of course I have a backup, however I rather not be forced to redo about 6 hours of work.
Looking across the internet it seams like quite a few people have had this problem, but no solutions. As far is I can tell, something in the VBA code has caused the database to become corrupted.
So my question is this, is there any way I could possibly recover at least some of the code? Could I somehow force Access to show me the code, even if a part of it is corrupt?


I want to group duplicates (text) across several columns
I have an excel spreadsheet that I have imported in access. The spreadsheet has a column that lists project title and then 6 staff titles (project manager, admin asst, etc). I'm trying to create a query (or maybe it should be a report) that shows the projects and titles that each employee has held.

For example:

Stan Smith
---project manger for project A
---senior analyst for project D

Tracy Sue
---admin asst for project C
---asst analyst for project B


Adding a list of tasks (at once) in a form
I'm intermediate with ms access and currently have a database to organize all the tasks we do per every project we have. Now there is many projects in the database and I have noticed that most of the tasks for every project are the same. so now when I open the form that lets me first pick the project number. When I do so, it shows me the task list for that particular project, lets me add/edit/delete the tasks. Now I want to create a button in that form that lets me automatically add a particular list of tasks all at once (about 30 or so) FOR THAT PARTICULAR PROJECT. I'm sure there is a way to do this.

I'm basically looking for someone to show me the code of how to add at least TWO tasks thru visual basic using a BUTTON and also let me know if it's the same for adding 3+ tasks. thank you so much in advance and remember I'm trying to add the task list JUST FOR THAT PICKED PROJECT =)