Search results

I don't want it to default to today's date since there are medications already in the system that are not being updated or added. By putting a date in the date field it populates a report that is called up by date range to show all the new medications added or modified. Ken

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...

Thanks that works great. I will go and program that into the original database. Thansk so much.

Now I think I did it correct.

I have condensed down the file and eliminated a lot of irrelevent data.

Now this is imbarrasing. How to you add an attachment to this string?

That lockes it up and the Return to Medications Search button no longer works.

The design of the form is just a combo box that is linked to a medication query. Once the user selects the medication they hit a search button which is a command button that opens the Main Query form to display the specifics of the medication. The button was programmed using the wizard to open...

Correct that is where it is at: Private Sub Form_Close() Forms!Search2.Combo1 = Null Forms!Search2.Combo1.D ropdown End Sub This is on the "Main Query" form which shows the medications information. Ken

Here is the code I added: Forms!Search2.Combo1 = Null Forms!Search2.Combo1.D ropdown Search2 is the form with the combo box used to search for the medication. When I hit the search button it goes to a form called Main Query. I put the coding on the Search2 form but nothing happens. Ken

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...

Yes. I keep getting a debug error on the second line starting with Me.Filer. I have it referencing a combo box (me.Filder = "Combo1" & Chr (34) & Chr (64 - Int (-X/ Me.LbLAlpha.Width). What I am trying to do is have the user select the first letter of a medication and have it show up in the...

I am trying to do the same thing in my database. Lyle states to create a label with the alphabet but when I do there is no mouse down property on the event tab. Did i miss something or should it be a combo box? Thanks Ken

I may have figured something out. I went in and read on one of the posts that you can create a combo box that will look up items from your main table. The instructions show how to create a command button to open up to report preview. Having this knowledge, I then explored more and realized I...

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...

Thank you so much. I have been trying to do the same thing through VBA programing. I didn't realize it was easier to do it this way. Thanks again.

I am asking for help with the VBA coding. Ken

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...