
Microsoft Access technical help
- or -
Post a project like this2086
£30(approx. $40)
- Posted:
- Proposals: 13
- Remote
- #2785899
- Awarded
WEBSITE DEVELOPMENT & DESIGN ! WORDPRESS ! JAVA ! PHP ! JAVASCRIPT ! GRAPHIC DESIGN | VIDEO | EXCEL VBA & MACRO EXPERT

Application programmer in vb6, vb.net, php, with mysql, sqlserver, access, excel, data entry bases
Healthcare, Accounts Payable, Data Entry VBA, Advance Excel, Ms Access Database, Web Scrapping, Python
3659044256106687822481513886740262608039145313792781369165327441382479060963451
Description
Experience Level: Entry
I have been looking at setting up an Access database for some time as a management system. The database should help me manage my membership base consisting of companies and people. The idea is to develop the project slowly over a few months so I am able to learn and adapt during the process.
I have multiple tables set up and wanted to set up a user navigation screen. For the screen - I have set up a form with tab control and set the main navigation form with a company tab amongst others. The idea is to have a list of companies, when I select one it displays the company information. On another tab, I want to use people, so when I click on a person (via a list box) it returns the information for that person, and the company they work in. I set it up this way since having all the information on one page will be too much, and sometimes I want only information on companies, and sometimes people. There are further tabs I am looking at setting up during the process which will include members, notes, projects etc.
1. Is this possible to do, or does the company tab with the source set as 'company' for the records stop me from being able to set up a separate source on the peoples tab?
2. Is there a way to log notes against each person or company - which is time stamped and dated to when the record is created or if I wanted to add some historical notes?
3. Is there a possibility to set up the records so they are locked for display, and the only way to enter a new company or edit is when I click either an Edit button or create new record? Ideally with people and the company.
In basic, I would like to have a similiar screen and function to companies with the people tab, but not sure if the comapnies tab is locking the whole database navigation sheets to the companies table as the resource, when I change it on the people tab to a new source i.e. people, it breaks the system.
Maybe the navigation pane was not the best way to set this up, but I am looking for some expertise help over the coming months that I can dip in and out of, but happy to try most things myself and learn in the process.
Data has been cleared for GDPR reasons. I attach screenshot of companies, people and current tables and forms.
Would you be available to help?
Many thanks
Suteesh
I have multiple tables set up and wanted to set up a user navigation screen. For the screen - I have set up a form with tab control and set the main navigation form with a company tab amongst others. The idea is to have a list of companies, when I select one it displays the company information. On another tab, I want to use people, so when I click on a person (via a list box) it returns the information for that person, and the company they work in. I set it up this way since having all the information on one page will be too much, and sometimes I want only information on companies, and sometimes people. There are further tabs I am looking at setting up during the process which will include members, notes, projects etc.
1. Is this possible to do, or does the company tab with the source set as 'company' for the records stop me from being able to set up a separate source on the peoples tab?
2. Is there a way to log notes against each person or company - which is time stamped and dated to when the record is created or if I wanted to add some historical notes?
3. Is there a possibility to set up the records so they are locked for display, and the only way to enter a new company or edit is when I click either an Edit button or create new record? Ideally with people and the company.
In basic, I would like to have a similiar screen and function to companies with the people tab, but not sure if the comapnies tab is locking the whole database navigation sheets to the companies table as the resource, when I change it on the people tab to a new source i.e. people, it breaks the system.
Maybe the navigation pane was not the best way to set this up, but I am looking for some expertise help over the coming months that I can dip in and out of, but happy to try most things myself and learn in the process.
Data has been cleared for GDPR reasons. I attach screenshot of companies, people and current tables and forms.
Would you be available to help?
Many thanks
Suteesh
Suteesh C.
100% (2)Projects Completed
3
Freelancers worked with
3
Projects awarded
43%
Last project
24 Mar 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-

is your budget a total project figure or an hourly rate???
Suteesh C.07 Apr 2020Hi, I am not sure how long a job this is, but I put something in to start with. I was hoping someone could look and say yes, easy fix, just use tab forms, or sub record instead of combi form, and whether what I am trying to do is possble or not.
If it's more than an hours work of course I would be willing to stretch further.
Thanks
Suteesh
908895
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies