Productivity Tracker using Access

Hi all, I’m new to access. Decided to learn it because my company has been tracking their employees’ productivity using shared excel sheets that has to be updated daily. The problem with that is excel would crash when there’s a lot of people updating it at the same time and the job is basically a simple data entry where we have to record what we did. The record could reach thousands of lines per day and at the end of each day the recorded data would need to be compiled and analyzed to have the employees’ productivity results.

I heard that access is a better option in recording large sets of data so here I am, trying to figure out on how to create an efficient database and an accompanying form. What I have so far:

a) A table with incomplete record; the employees need to complete the records, this is their productivity.

b) A form to fill the records by the employees; this would prevent the employees from working directly with the table.

c) A confused mind trying to figure out how many access file should I be creating.

Now, the reason why I’m confused is that, the company employs almost 300 people to fill in the records. Is it wise to have all 300 employees filling up the same table using the same executable form in one access database (I read somewhere access has a limit to how many people can work on it at the same time but not sure how many)? Or should I divide it into several access database and compile them at the end of every day?

submitted by /u/justanamir
[link] [comments]

Posted on

Stop Enter Paramete Value Prompt

I have a Main form (frmDeliveryScheduler) that contains a navigation panel holding multiple subforms. One of the subforms (frmSearchbyDate) is a search form that has a text box wherein the user can input a certain date and access will use it as a criteria in my query. This query is used as the base of said form. (frmSearchbyDate).

When I click on the tab of frmSearchbyDate, a pop-up of Enter Parameter Value: Forms!frmSearchbyDate!Text0 comes up. I know that this won’t show when the form is actually already open. But my user will only open the form when the tab is clicked. So it’s like a cycle of error.

Is there a way for me to force close this pop-up so it doesn’t confuse my users who don’t know any better? Or a way to hide it at least? Just clicking “Ok” on the pop-up lets me get through to my subform which then works perfectly fine.

UPDATE:

https://stackoverflow.com/questions/22766353/query-subform-not-working-when-used-through-navigation-form

Found the solution!

submitted by /u/mimi814
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

MS Access Forms – Proper menu creation

Hello!

​

I’m confortable writing code in VBA. It could function better and more efficiently, but that’s a problem I’ll most likely have to solve if it gets too slow.

What I am absolutely bad at, is creating forms that are both good looking and are working well.

For example:

What should the main menu look like? (Menu A, Menu B, Admin Menu)

What should the forms look like? When choosing different functions with different options, should I go and make popups with the options or should I put them on the same form using a subform element? Or even just smash everything in one single big form and hide/show what’s currently needed?

Do you maybe have some tips and/or experiences on that matter? 🙂

submitted by /u/TyriusTailwind
[link] [comments]

Posted on

Query help please – finding the most recent date

I am hoping for some help, i am ok in terms of most queries but I am having issues getting the results I need at the moment. I have never used VB but am happy to learn if someone can point me in the right direction. I am using Access 2013.

I have a number of tables, the 2 i need for this are: Table 1 – main list of all vehicles (vehicle ID, rego, name, make etc) Table 2 – list of services / repairs (service ID, rego – related to table 1, service date, type of service – dropdown from table 3 – inspection/service/repair, details of service, km of next service, date of next service due,

Table 1 has approx 40 vehicles & plant equipment Table 2 has every invoice entered as we receive the invoices, so there are multiple lines for each vehicle, each vehicle also has lines for repairs as well as the services.

I have done a lookup in table 2, so it shows the rego & associated vehicle name, but stores the vehicle ID.

There is a 1:many relationships table 1: table2

Note: difference vehicles have different maintenance schedules so i manually enter the next due date and next due km fields, when i am entering the service detail

I am trying to get a query to show the following details Rego (table 1) Vehicle name(table 1) Date of last service (table 2) Km of next service (table 2) Date of next service due (table 2)

I can get it to only look at the services (not repairs etc) I have tried turning on totals and can get it to work to show the most recent service date, but once I add the next service kn & next service date fields it shows all the lines for each vehicle not just the most recent.

If someone can help me figure this one out I would be very appreciative as it is driving me nuts. As once it is working i will create reports from it to show overdue services and services due in the next 30 days (I can do this part. )

Thanks

submitted by /u/MJBaddy
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

Split Database keeps doing this.

I have our database split. Each user now has their own version of the front end. As they enter data they get a “Disk I/O” error or https://imgur.com/a/Vrr6s0Z. The frontend and backend are on the same DFS shared drive which holds most of our other files.

https://imgur.com/a/5n6xdJu

When I enter the back end file this is what comes up. I click OK and it creates a backup and we can continue on with our data entry. It doesn’t seem like we are losing data in this process.

Anyone know what is going on?

submitted by /u/urawizardhairy
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

ODBC on virtual machine and linking to other databases – master/slave relationship?

If I create an database on a virtual machine at my office that has all the my ODBC links (let’s call it Master Database), and then a subsequent database that I can distribute to users in my organization (Slave Database) with the master setup as an external data source, do the individual users’ machines also need to have the ODBC links established?

submitted by /u/nerdyythirty
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

Split Database keeps doing this.

I have our database split. Each user now has their own version of the front end. As they enter data they get a “Disk I/O” error or https://imgur.com/a/Vrr6s0Z. The frontend and backend are on the same DFS shared drive which holds most of our other files.

https://imgur.com/a/5n6xdJu

When I enter the back end file this is what comes up. I click OK and it creates a backup and we can continue on with our data entry. It doesn’t seem like we are losing data in this process.

Anyone know what is going on?

submitted by /u/urawizardhairy
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

Change (Yes/No)based on date

I’m writing up a database based on a library system.

I have a Date Due Back (Date/Time)

and a Student Library Privileges(Yes/No)

If the book hasn’t been returned after 3 days of the [Date Due Back] then their [Student Library Privileges] will be disabled to, “No”

Now I have a query for overdue books and I want to put this into this query so it’ll display people’s privileges that are gone and all that and I can’t figure out how to do this. Does anyone have any ideas how?

submitted by /u/GuyThatsADuck
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on

4 Quick Fixes To Recover Overwritten Access Database File

In this current digital era, issues like data Loss is quiet common occurrence. When such things happen, you only need to approach for the Recovery solution. Though there are several data recovery software available today but still it’s a quiet…

Posted on