X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Need Help With A Very Simple Project, Access 2016    
post Apr 26 2019, 08:45 AM

Posts: 1
Joined: 26-April 19

I am trying to do a very simple thing but have hit a snag. Our office needs a simple In/Out Board for staff to quickly see who is in and out of the office. Rather than buy something that already does this, I thought Access would be a simple alternative. Creating the form is no problem. Creating the staff name with a drop down that shows In, Out, Field Visit, Vacation etc with an image that changes based on what drop down choice they make, no problem. That works, but I want for this to be a shared form that is accessed from a network folder and displays everyone else's choices properly as they open it up. My first issue, I have shared it yet anyone else who tries to access it is met with a "User has this form locked for editing" message. So, I think there is an issue with the share itself. I want it to be like a shared Excel spreadsheet where anyone can access it, make and see changes roughly as they occur. Also, this isn't set up with tables. Each user name is just a text label. Each drop down is a simple combo box with built in values. The after update event on the combo box then changes the picture, different colored LED lights, based on their choice. Will this work so everyone can see it, or does it have to be set up in tables to record the values and display the most recent choice, In, Out etc? Any help would be appreciated.
Go to the top of the page
post Apr 26 2019, 08:59 AM

UtterAccess VIP
Posts: 7,134
Joined: 30-June 11

I'd urge you to review


To share an Access database, you must first split it, relink the tables and then deploy a copy of the front-end to each user (this is covered in the above listed posts).

Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc

All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
post Apr 26 2019, 10:37 AM

UA Admin
Posts: 36,760
Joined: 20-June 02
From: Newcastle, WA

Welcome to UtterAccess.

"Also, this isn't set up with tables. Each user name is just a text label. "

This is the OPPOSITE of an Access database solution. Access, like all databases, is built on tables.

Please invest some time in learning what Access is, and how it works.

We have some excellent materials here at UtterAccess to help you get started.

Think of it this way.

If you need to build a house, you do not start with the walls. You start with the foundation. In database terms, TABLES are the foundation; FORMS are the walls and roof.

My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    19th February 2020 - 06:03 PM