Edit an existing form

[yrstruly]

How can i edit form as seen attached, to display Sales?
https://drive.google.com/file/d/1H6Y...ew?usp=sharing

[Welshgasman]

Go into Design View

[yrstruly]

Go into Design View

Please elaborate.

[Bob Fitz]

Please elaborate.

On how to open in Design View??

[Welshgasman]

Please elaborate.

Do you not have Google on your computer?

Right click the form's title bar and choose Design View.

YouTube has lots of videos on how to use Access, so perhaps search there for visual help.

https://www.youtube.com/results?sear...it+access+form

[yrstruly]

I am making modifications to an existing Access database that I did not design. Below are some considerations regarding the changes:

1. I have created a copy of the database, which is currently linked to the original data source. Since I will only be editing forms, should I first disconnect the copied database from the original data source before making modifications?
2. I will be adding new tables and columns to the existing database. I plan to implement these changes in the copied version first. What are the best practices for this process?
3. When adding a button to an existing form (as shown in the screenshot), is there a shortcut or best practice to align the button and maintain a neat form design?

Spec:

Overview
This is just an Example

The current database for plant import/export management requires significant improvements to enhance functionality, traceability, and efficiency.

---

1. Import Process Enhancements

Current Issues:

• Lack of options for fumigation tracking at quarantine.
• Permit storage system is complex and lacks structured document categorization.
• No link between import documentation and other database records.

Proposed Solutions:

• Add a checkbox/drop-down field to track fumigation upon arrival.
• Include fields for:
  
  • Permit Authorization Approved Date
  • Expected Release Date
  
  
• Implement structured document storage:
  
  • Dedicated database fields for permit documents (PDF/Word)
  • Dropdown selection for document type (e.g., DHL docs, Phytosanitary, Import Authorization)
  • Bulk document upload feature for multiple related permits.

[jojowhite]

do you have programming experience and i doubt that you have.
you will have a hard time building-studying, trial and error as you go.
it is easy to hire expert help and you tell him the plan for the new system.

[yrstruly]

Yes, i do have programming eperience. SQL, Python and HTML. I do not require the spec to be done by a person, im doing it myself. It is just an idea of what im working with.

[jojowhite]

goodluck then, VBA may seem easy but like other programming language, takes years to master it.

[Welshgasman]

Yes, i do have programming eperience. SQL, Python and HTML. I do not require the spec to be done by a person, im doing it myself. It is just an idea of what im working with.

Well, at least you should have some logic?
The rest is to learn the commands.

Again Google is your friend, as well as intellisense. Plus lots of videos on YouTube, as I have already mentioned.

[Welshgasman]

Yes, i do have programming eperience. SQL, Python and HTML. I do not require the spec to be done by a person, im doing it myself. It is just an idea of what im working with.

Well, at least you should have some logic?
The rest is to learn the commands.

Again Google is your friend, as well as intellisense. Plus lots of videos on YouTube, as I have already mentioned.

Make a copy of your current backend and use that as your development db.
Adding new tables/fields will need to be replicated in the production db, or clear out your development db and bring all the data from the production db into that, and then make what was the development db the production db.
All that needs to be done when noone else is in the DB, but you.

[yrstruly]

Thank God for AI