Search results

:) Working with access and the great folks on this forum to get assistance as well as great ideas for adding features to database design, I just want to share what I was able to accomplish in hopes it will help others wanting to do the same. I created a list box to show all the available...

I have created a database that uses macros to send reports out to specific locations. The issues I have is I have the database extension as .accdr with all short cut keys disabled to a point it prevents users from tampering with the programming and the data. What I need to do is create a...

I have tried to research this but can’t find exactly what I want to accomplish. I have created a database for my wife whom is working as an independent consultant. She visits various practices and provides support on the EHR systems. She wants to have a report to take with her identifying the...

This is an unusual problem. My wife downloaded a file from the Virginia State Immunization Registry and wants to upload the file into their electronic medical records. It downloads the file into Excel except it added an “A” or “N” in front of the first name. We tried to use the “find and...

I have a database containing two fields; one is “1st Tx Date” the second is “Contacted Date”. When an individual received a product the 1st TX Date field has a date input. Once oral confirmation is made they have received the product, a date is added to the Contacted Date. On a report I have...

I have created a database containing medications. The user can add new medications or update current medications in the system. I created a dropdown combo box to allow the user to select a status (field is called “Status”) of either “Addition” or “Change” and a field for “Status Date” to put...

I have a database that will be used to look up medications. The user will select the drug from a combo box and then select the search button which opens a form showing the drug information. Once they have read the information they would then click on “Return to Medication Search” button which...

I want to figure out how to count the number of records that exceed greater than 30 days. I have a report that takes a date when the project starts and using=Date()-[1st Date] as the data source to give me the number of days from the time the project started to today. This lets me know how...

I have created a database that is going to be used to look up medications to determine if donors are suitable for donating. I have a form called “Medication Search”. On this form I have a combo box that allows the user to select the medication either by a drop down or by typing the first...

I have a database where organizations can enter issues they are having problems with. On that form I have a OnClick button that runs a Macro to send me a report via email. The problem is, if multiple sites enter issues, I will get the first issue in an email message, then a new issue with the...

I have been searching and have not found the right mix of VBA coding. I have created a database for blood donor centers and hospital transfusion services. Each site must register in the system by providing a point of contact and an email address. If a donor center has extra products...