Search results

I have been using Access for clinic visit records in a medical clinic. This has been performed on a single computer. I am planning on expanding this capability to record information from the exam rooms and will be setting up a sever and multiple work stations. I will also have more than one user...

I would like to lock from edits any recordset that is greater than 24 hours old. Is there a way through code that this could be accomplished? (for example, as I enter new data into a form, I wouldlike to be able to go back and change that data at any time during the first day that I have added...

I would like the background of a text box (date) to change based on the "age" of the date. For example, If the text box date is greater than 60 days ago the background would be yellow and if the text box date is greater than 120 days ago, the background of this text box would be red. I...

I woud like to place a toggle on my form that would cycle through "yes", "no" and null and record that response in a table. I would like the caption on the toggle to chenge to "yes", "no" or blank depending on the state of the button. I can't seem to get past the yes or no only in the table...

I have a form from which I print reports based on a single record. This works well when I use this form as a stand alone but when it is included as a subform, I get the message "Enter parameter value" The parameter that works when stand alone is Forms!Clinic Visit Record!PatiendID. What does...

I have read on this forum that you should not print from a form, rather you should design a report similar to the form and print from this. I have done this with both the form and report based on a single table. However, I see no way to search for a specific record within the report as one can...

I have one form entitled "Patient Demographics". From that form, I have a command button that opens the form "Patient Visit". I would like for the name, address, telephone number from the origninal form ("Patient Demographics" to automatically populate those fields in the "Patient Visit" form...

I would like to have completed forms locked to edits however I need to have a method of preventing someone from accidentally closing a form before it is completed which would result in an incomplete, uneditable form. I would like to have a meesage box appear on closing one record and before...

I am keeping a database of medical patient visits. The information is entered into the table through a form. Once an encounter is conplete, I would like to lock that particular record, however, I may be working to complete documentation of several patient visits at once and may not be able to...