Search results

This worked! I've never used a union before, but it's exactly what I was trying to do.

The only problem is that the Old_ID numbers and New_ID numbers are probably not going to match up with the names. That's why I'm trying to join them by name instead of ID number. Query2 and Query3 in the example DB are kind of how I need the list to be. Showing where the names match up and blank...

My company is changing phone systems this week. Some people already have direct dial phone numbers with our old system that we are trying to port over to the new system. With this new system however all of the people who don't currently have a DID number will be getting one. We are trying to...

I think I accidentally figured out what was going on. I changed If StrComp(Me.Password, DLookup("Password", "Tbl_Private", "ID_Navigator =" & Me.Navigator), 0) Then to If StrComp(Me.Password, DLookup("Password", "Tbl_Private", "ID_Navigator =" & Me.Navigator), 0) = 0 Then and now it seems to...

I have an input mask on the passwords in the table to be hipaa compliant so I have been using this code to check cases on the Login Screen. StrComp(Me.Password, DLookup("Password", "Tbl_Private", "ID_Navigator =" & Me.Navigator), 0) This is my first time trying something like this or using...

Just the the ones in the password table. I just recently activated the case sensitive part of the log in but I wouldn't think that would affect the way the password is stored.

I have a database where I created a log in form for the users where they select their name and enter a case sensitive password. We have just figured out that when we record a new password on the password table it is automatically capitalizing the first letter of the password. I don't want it to...

Update: I changed the permissions on the folder, as suggested, and that fixed the Read Only issue. I also ran a compact and repair on it again and that seemed to clear up the forms not loading.

How would I go about doing that?

I don't know if this is the correct sub forum for this question. So I have a database, that multiple people have access to over a VPN. For some people everything works fine, but for others some of the forms will not load. It will just show a blank page for some of the forms. I can put those...

Thank you! That worked perfect! I did have to modify it just a little bit. The VBA code needed "AND" at the end at the arguments instead of "OR". Then it sorted everything fine.

I didn't even think about this until now. The "Navigator" box will respond to the "Navigator Active" box and will either show active or inactive navigators. The "Navigator" box and or the "Client Active" box will then be used to narrow down the client list. Sorry I didn't explain that before. I...

Here It is

Here is what it looks like. I want to be able to refine the search any or all of those 3 criteria. I don't know if that is considered cascading or not. I tried searching the forum for that but wasn't quite finding what I was lookin for. I was able to figure out how to search for the names of the...

It's going to be a list of about 6 names. I just want it to display all of the search options on the blank entry and only refine the results when on one of the other options. Now that I know it's called cascading I will search the forums for something. I'll keep this open until I find a solution.

I would like to query a list box refining the search using a drop down menu. When on the first option (Which is blank) I would like to see all items in the list box, but when I select a name from the combo box I want it to refine the search using whatever is selected. I have tried a lot of...

That worked perfect! I had to do a little modifying to match up with my db but it is good to go. Thank you.

I misnamed the label to what I wanted the text box to be named. To be honest I feel embarrassed that I wasted your time.

I have a list box that I would like to make searchable. What I would like to have is when nothing is in the "Search Box" the list box shows all entries but when the "Search Box" has something in it and the person presses the Search Button it brings up the results in the list box. I only know...

I got it figured out. I was missing something on the form. It's working now.