Recent content by uneek78

I plan on having a form that my users could use to save information into. I've gotten the shortcut to work, but not exactly like I want. I would like to know what ways others use. I am attempting: - A shortcut for the form - Pre-sized form window that can't be resized by users - When it opens...

I have a form where I would like the user to be able to choose multiple checkboxes, buttons, or whatever that would go in the same field in a table. Basically I have several locations. I would like the user to be able to choose several locations at once and once they save the document the...

Okay, once I put 99/99/00\ 09:00\ >LL;0; into the input mask for the form it works perfectly. It even prompts for am/pm. If you try to deviate from entering the time or date you get a message stating something wasn't entered correctly. Is there a way to edit that message the user gets? The...

I did this in those specific columns and also changed the "required" option to "yes", but it still takes just allows me to just enter time. I did this on the table.

I want them to be required to enter both the date & time. Because they often forget to enter the date and the database will simply accept just time if that's what you put there.

Not sure whether to put this under tables or forms... I have a form that users are required to enter the date & time in the same column. If the users only enter time the database accepts that. I want the database to restrict them from not entering both date & time. These entries subtract...

Thank you very much! That worked.

I have a drop-down menu that has several pre-filled entries as options. How can I make that option where you have no choice but to choose an option within the drop-down menu? Currently you can either use the drop-down or start typing the last name of the person and they rest of their name pops...

Nevermind. I figured it out. If I had all the hospitals listed in different Criteria sections on one field, I made sure I listed the medical problem or problems in the adjacent fields. If I wanted several medical issues under a specific hospital to show up I put the hospital adjacent to each...

I have several queries created. I have one column that takes hospitals and a second column that takes different medical issues. I want to create queries that can sort by a specific hospital and medical issues. For example: Hospital - PCMH Medical Issues - Code Stroke, Hemorrhage, Pnuemothorax...

Nevermind! I should be beaten and tarred for asking this question. I figured it out. Lol!

I am attempting to setup a query that comes from another query and only lists patients on the query if they've had a Code Stroke. So pretty much, if they've had anything else it would emit those patients from the query. If possible, it would be great to do this w/o any coding.

Unfortunately I am not experienced in coding. I wouldn't be able to begin to know where to insert the code given.

I used: Countdown: IIf(DateDiff("d",[Time of Findings],[Exam Ordered])>0,Format([Time of Findings]-[Exam Ordered],"d:hh:nn"),Format([Time of Findings]-[Exam Ordered],"hh:nn")) It excludes DAYS all together. And if I add D(days) back into the equation I get 30 once again.

In my query I have 2 columns. In each column there is a date & time. I have the columns subtract from each other and in another column give: D:HH:NN (which equals to DAYS:HOURS:MINUTES) Everything is correct except the day column, it's kinda correct. No matter what everything equals out to the...