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