Search results

Could you try downloading the file you uploaded and test again? I tested on my personal computer at home and the search isn't working on this computer either.

Ok. Well that means there is a client side issue with my computer then. I am having some other people try to open it and we will see if it is our work computers/MS version, or if it is just me.

So, when I open the file you added, the search isn't working for me. Does it still work for you if you reopen it?

Because it isn't working even without the code for me. The other CB on that page have no code behind them and they were not functioning correctly either.

I am trying to make it searchable for all of them so they don't have to click the box for every option. This way they can tab, enter a few letters, move on. The one I have been working on first is the CBSex which gets it's values from SexTbl. But ANY of them. What is weird is everything was...

Because I was trying to use the unique ID that has to be given to each patient that is alphanumeric up to 100 characters. Letter prefix followed by their internal patient ID. What do you mean by search code?

Here it is. Let me know if you see anything I am doing that is messed up. I have never had any issue like this before and it is driving me crazy.

So, even after all that, without doing code, the CB search function breaks....

So, each of these tables have the final name the answer has to be under. 1PatientDemo is the main table with patient demographics where the patient ID is assigned by the user. Each of the tables has a patient_display_ID field to be the child key. Date, Decimal, Text tables, each field is it's...

So, I am going to try to do the following and see if it works: 1) I am renaming my tables to add Tbl after them 2) inside each table, the like named column will have Opt added after it to designate it is the list of options 3) I am rebuilding any table that uses a lookup to remove that and just...

It has nothing confidential at this time. I am open to design ideas. I know enough to be dangerous. This is just the first time I have tried to build a database with the requirements that are needed for this upload. So, BLUF, each table is a question. I am using tables for the lookup for...

Yeah, I considered this. What is weird is I did change my table to TSex so it is Tsex.id tsex.sex and the field on the main table is SexID. But this also happens on unique naming such as my list of asian ethnicities (again, this is a report for a government entity) so there is no Asian.Asian...

Yep, that did it. Just a new form. Ughhhhh. Any ideas what would cause that? The code on the form they aren't working on is below. Everything else works fine too. : Option Compare Database Option Explicit Private Sub chkHomeless_AfterUpdate() Dim db As DAO.Database Dim rs As...

Hey everyone, so, I am having issues with a combo box search. I got it to work, was happy, saved, closed, when I opened it again, it is broken and won't work no matter what I do. Background: I am building a database that will create a file for upload for medical statistics. There are about...

So that part of the code, while clunky, isn't the issue. It is filtering from the listbox for the selected criteria. It is just filtering in order of top to bottom based on the number selected, not the actual selection itself.

I have very limited know how when it comes to public functions, and when combined with the other code I am having difficulty getting the list box selection to work.

The code for just the listbox portion is: ' Filtering logic for [PrimaryPillar] based on multi-select listbox Dim selectedSites As String Dim i As Long 'listbox filter For i = 0 To Me.lstPrimarySite.ItemsSelected.Count - 1 selectedSites = selectedSites & "'" &...

Hello, So, I thought I had everything going right, but I was wrong. I have this form for users to make a custom "report" which is really a datasheet 'ReportF': The listbox on the right correlates to a column on the table "Patients" which is "PrimaryPillar". The idea is for them to be able to...

That was the issue. Thanks! Simple things go overlooked sometimes and it didn't register to me. This is why you all are the best!

Good catch, I didn't realize. I'll have to give that a shot when I can and let you all know. Thanks!