Search results

For me I just make on click on button like this to clear selection at once: DoCmd.OpenQuery "UpdateSelectiontoFalse". For us confilct between the users is not a big problem, because we have only 4 users and sit very close one each other, so they can just shout to say not to use it temporarily...

The query itself in sql view is this: UPDATE Inventory SET Inventory.Selection = False; if I double click it in the navigation pane, it will work, but instead of doing that, I want it to be pressing a button/like command button. But what is the on click property of the button. is it...

Can I want it to just press the button>

Hello, I add additional field for selection wth datatype: yes or no, default is no. When I see certain item, I tick mark if I want this to print. I chose this one by one. My question is if I want to clear the tick mark at once. How can I make it. Thank you

Thank you Gemma for a very comprehensive explanation. Frank

OK Gemma, even tough in issuing form there are inventory table, sales detail, customer table linked. There will be a writing action in sales detail, but in customer and inventory just reading, because just choosing their data in combo box. There will be no problem even though there is a...

Thank you gemma

Thank you Isaac

Hello, when I browse our C using File Explorer, I see the server directory is like this "Shared (\\brilliant.sampl.abc.pqrs.org.org) (O:) Can I just right the path in my backup VBA like this? Source = "\(\\brilliant.sampl.abc.pqrs.org.org) (O:)\xxxdatabase_be.accdb" Thanks for any ideas

The Doc Man, I tried to see on the data and format property, there is no optimistic locking, where can we see it in form and query

Usually what is the message popping up for the one who is locked

Pat, what is queuing concept please

Isn't it automatically lock if 2 people are working on the same record?, The one is locked is the later person?, but if the other people, is just to view the record, he/she will be able right?. Let's say other people just want to see the price of an item in the inventory while the other is...

Thank you Pat, I will test later, coz right now, I do not even put yet the backend in server, waiting for the IT people to give us access to server.

Thank you MajP, that's exactly what I need.

Thank you MajP

Thank you DBGuy

Hello, I want to know how the data being shared in the database. if UserA is using table customer just to view customers, While user B is using input form for supplies usage which form has inventory table linked with customer table. Can both user do their jobs at the same time without any problem?

Did you post an example MajP?, where is it

see in my attached form, I or user can put any comment to the record, then we can filter for the same comment, say "frequently used", I can filter using filter menu on the ms access ribbon, for all records with frequently used. But since I will not show full menu to users on the front end that I...