We help IT Professionals succeed at work.

Modify form on accde database

Andy Brown
Andy Brown asked
on
430 Views
Last Modified: 2016-02-11
Using VBA, is there any way at all to add a control to a form of an accde database?
Comment
Watch Question

Dale FyeOwner, Dev-Soln LLC
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2010

Commented:
No.  You cannot make changes to forms, reports, or code modules in an accde file.
CERTIFIED EXPERT
Top Expert 2016

Commented:
you have to do the changes in the .accdb version, (if you have the .accdb version ) then create an .accde version
President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Andy BrownDeveloper

Author

Commented:
Hi Jim - thank you (and thank you also Dale and Rey),

Whilst I know you're pretty much always spot on, I am curious as to why the data model would be off.  

There could be 100 projects each with a different set of questions.  95% of the database would be the same on each project (i.e. forms, tables and functionality - all the same).  I just need a place to display the fields specific to each project (the back-end will be changed also so there would still be 100 back-end databases).  So, I'm not sure if I'm missing something that would make my life easier.

Thanks again guys.
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
Andy,

 The reason I said that is that you've modeled a database for "a project", and yet you need to change the form design when entering different instances of "a project".   With the right design, that shouldn't need to happen.

There are of course always exceptions.   An asset tracking model is one that is tough to wrap your arms around because each asset may have wildly different attributes, all of which you might want to track (say disk space in a PC, vs whether a desk is a stand up or sit down model).   That's where a hybrid design with an EAV setup tacked on can be helpful.

<<I just need a place to display the fields specific to each project (the back-end will be changed also so there would still be 100 back-end databases). >>

  and there's the rub; you should have one back end, with one set of tables and just more records in each when you add another project.  The structure and design of the DB and app should not need to change in order to simply add new projects.

<<So, I'm not sure if I'm missing something that would make my life easier.>>

  Without knowing more, it's hard to say, but an EAV design would probably help.

Jim.
Andy BrownDeveloper

Author

Commented:
Thanks Jim I'll take a look at EAV design and post another question if needed.

Take care,

Andy
Andy BrownDeveloper

Author

Commented:
Sadly Jim that design model won't work for me.

I need to keep each project in it's own separate database (as there will be different clients and sites using them).  For example I may have a client that uses the application for handling RSVP to an event, whilst another one might be a completely different company using it to book appointments for a sales team.  Also, each company may have several projects for different things (on the same site).  So to keep things simple, we simply provide them with one database for each project (all of the data is unique to each one anyway).  

In a perfect world, I would have one master Access database, and when the user selects the project that they are working on, it displays the project-specific fields (as well as all of the standard ones), links to the relevant back-end and off they go.  Ideally, I'd like the sub-form displaying the unique data to add the fields from a table containing the layout/controls etc.

Not sure if that makes sense....but hopefully it does.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.