Search results

I've got a "visit tracking" db developed for our medical office. Each area has its front end interface that connects to the back end on the server and the Front Desk, MOAs, RNs, MDs, and Pharmacists all use it to alert each other to where the patient is and needs to go. We add somewhere between...

Hello folks, Cooking up a "Visit Tracking" application in Access (2007-2016 format). Each area has its own Popup form: -Front Desk -Nurse -Doc -etc... 1. The front desk creates a visit, and it appears on the Nurse's form 2. The nurse rooms the patient, marks which doc and room, and the visit...

Howdy you Access experts, I'm having a devil of a time googling for this solution, I think because the terms are so mushy (or maybe I don't know the right term to use). If code (ran on a timer) finds new records on the backend db, I want to give focus to the frontend Access Form -the form will...

I would greatly appreciate some help on this error I'm getting: Run-time error '3075': Syntax error (missing operator) in query expression 'visitID = '. In the linked database, this code runs on the click event of the UPDATE cmd button: DoCmd.OpenForm "frmUpdate", , , "visitID = " & visitID...