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...
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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?
'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.'
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.
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?
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.
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.
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.
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