Recent content by DocWomet

Ladies/Gents, Trying to build an exercise patient tracking database for my small hospital. Attached JPEG of what my boss is wanting from last exercise (built with painstaking manual effort, even with Excel formulas) and my task now is to automate the process (i.e. why I turned to Access)...

UPDATE: I re-looked at all my formatting and tables and think I fixed it by tightening down my Short Time formats...!!! Though I'm still baffled as to how some of them were working in the first place... I think I've dodged this bullet. Thanks for reaching out Mihail! Time for another cold...

P.S. Don't know why I didn't think of this earlier, but I changed what times I was using to test the UPDATEs. When I use 08:30, 08:31, etc. instead of 08:01, 08:02, etc. I get different results... but still only about 50% of the fields get updated.

Mihail, thanks very much. I corrected the Time use and, coincidentally, accidentally deleted the entire form I was using. Thank God I pasted most of the code here... anyhow, I'm still having the same problem, in case that's of any consolation value. I put default values in so if you could...

Trying to update a table with 16 potential textbox controls containing Short Times to show a patient's location. I'm getting no error messages and the UPDATE code seems to work, but only for certain controls, even though they are all formatted the exact same and the code's exactly the same for...

Sweet, blessed success....! Thank you so much. WILCO on your advice.

If I could solicit further... having a similar likely rookie mistake that I've tried writing so many different ways I can't remember when I began. All I'm trying to do is update a table with a Short Time value from a textbox (TRW.Value) so that where my table MASTERShell has the same Short...

Hello, Thanks to all who host/contribute/maintain this great forum. I'm an Access neophyte trying to automate menial tasks for a hospital at Misawa Air Base, Japan, learning mostly thru trial, error, and destroying mice/keyboards. :P Longtime viewer, first time joiner. Thanks again DocWomet