Search results

Sorry, I didnt add the code tags, but the computer i was using wasn't letting me select the code tags when I added the code. I don't want to use a dropdown box for the search because there are too many keywords they could use. I am a newbie with the VBA and access. I got the original code from...

I have 2 textboxes txtkeywords and txtkeywords2 that I am want to use to do keyword searchs.I cant get the code to work. Private Sub cmdsearch_Click() Dim SQL As String SQL = "SELECT q_Qual_Cond.[Chron#], q_Qual_Cond.[Research_ID], q_Qual_Cond.[Qualifying_Condition] " _ & "FROM...

Thanks, you all.

All of my forms could be the same form just with different criteria from different fields. I just want different lists of patients to show up depending on criteria in different fields. For all patients there would be no exclusion criteria. For withdrawn patients. Status field = "withdraw" For...

I want to be able to have a main form with a dropdown list Combo box. Then a subform container on the same form. I want the dropdown box to have selection where it shows all patients. Then selection for all patients with specific conditions, pneumothorax, pleural effusion. Then a selection...

Thanks, I will look at this. I probably wont be able to look at it till Monday.

I might not have explained myself correctly. I have the Navigation_form that has tabs with nested subforms. One of the tabs on the navigation_form is the patient data entry, when you click on that tab it shows my New_Pt_Main_Form tab. My Still admitted tab shows a list of patients with their...

I had one other question. How would I modify the code for use on another form/ tab within that same navigation_form. I added another tab/ form with a different patient list. I want to do the same thing from the other tab, click on the research-id browse to the New_PT_Main_form with that...

Thank you. I tested out the code you put in the file and it works. There is one thing I still wanted it to do. After I click on the link and it takes me to the record on the New_PT_Main_form tab. It only let's me look at the one record. I have navigation buttons that lets me scroll through to...

I'm currently just using the onclick event openform macro to hyperlink to the other form when you click on the Chron# for the still admitted form. I keep getting VBA error messages though. They aren't consist, they just happen sometimes. I have someone that also enters data at the same time as...

Here is my FE forms and the BE db. Just need to be linked.

I will try to upload a copy tomorrow with dummy data. For Now I have some screenshots of the forms. Maybe that will help. Main Form is called Navigation_Form and it has several tabs on it with subforms on each tab. 1st tab is Still_admitted form (based of Still_admitted query). It has a list of...

I can post the front end with the forms. I can't share the backend though. Unless I create some fake backend db, but it would take me awhile to make some fake data.

I tried using the browseto macro but I cant figure out to write the correct path in the macro. I have the main form navigation_form, then I have 2 tabs all the tabs are called NavigationSubform. The tab that has New_PT_Main_Form is the tab I want to browse to. I keep getting error message about...

Adam, Thanks, I will try what you suggested. I was referring to the other solution, I dont want to have to password protect the file every time I create it by hand. I may be exporting this file a lot.

I have a main form called Navigation_Form it has a tab control with 2 tabs on it. 1 tab Still_admitted_Form, then 2nd tab with New_PT_Main_Form The Still_Admitted page is a query that brings up a list of patients still at the hospital with their research_ID. The New_PT_Main_Form is a data...

I created a form with a button that automatically exports several querys into an excel file with each query being 1 sheet in the excel file. I want to automatically have the excel file with a password. How to I add code that would do that? I would I integrate code that would do that into my...

How would I integrate/ modify this code within my existing code. I have a button, that is clicked and exports several queries into 1 excel workbook with several sheets. I want the whole excel workbook to have 1 password. Below is my existing code:Private Sub CommandTransfer_Click()On Error GoTo...

Hello, I Have 4 fields with dates and times. Time field is in Military time. Fields: US_date, US_time, CXR_date, CXR_time. I want to create 3 calculated fields using those other fields to determine how many hours apart each of the date, times are. Calculated fields: 24hr_before, 24hr_after...