Search results

Since I'm just starting to develop my first projects in Access, your post is very useful to me. I have read both, but this information is very interesting. Thanks a lot.

I solved the problem using Switch function in the query. Thanks everyone.

In the form I have txtSearch TextBox with according lable. I would like to modify txtSearch TextBox with default text like "Enter search value" with Italic font. In case if someone will start enter just one character the default value will disappear and entered text will have normal font not...

The problem is solved. Thanks

Now that code version returns correct value for first and second condition: Location: Switch([qLocations].[Wing] is not null, [qLocations].[Facility] & " " & [qLocations].[Building] & " " & [qLocations].[Wing] & [qLocations].[Floor] & "-" & [qLocations].[Room], [qLocations].[Wing] is null...

I saw the previous answer it suggest me how to convert query code to VBA. And in the previous post code check only two conditions True and False. Here I'm asking how to solve the problem if field has three conditions. And for each condition should be different return value. Thanks

Hi theDBguy. Thanks for reply. It just similar. In this post I would like to solve the problem inside in the query. Because I found information that Access has nested IIF statement. And in the another post I did know about nested IIF and asked help to solve the problem in VBA code. But if it...

Hi All. I created query where Location field should be display value based on some conditions. For that I specified for that field nested IIF statement: Location: IIf([qLocations].[Wing] > " ", [qLocations].[Facility] & " " & [qLocations].[Building] & " " & [qLocations].[Wing] &...

Hi All. The Record Source of continuous form is query where the Location field has concatenation like: Location: IIf([qLocations].[Facility]="ABC",[qLocations].[Facility] & " " & [qLocations].[Building] & " " & [qLocations].[Wing] & [qLocations].[Floor] & "-" &...

I used your suggestion but BeforeUpdate() event gave me error message. Then I tried to use AfterUpdate() event and got search result much better then was before. You can see in the post #13 how I used your suggestions. Thanks

I modified code and substitute event to AfterUpdate(). Now it works much better without flickering Private Sub txtSearch_AfterUpdate() On Error GoTo errHandler Dim filterText As String 'Apply or update filter based on user input. If Len(txtSearch) > 0 Then filterText...

Hi CJ_London. I remove IF statement leave only Me.Form.Filter = "[qSearchContinuousForm].[RequestDate] LIKE '*" & filterText & "*' OR [qSearchContinuousForm].[Employee Name] LIKE '*" & filterText & "*' " _ & "OR [qSearchContinuousForm].[TicketNo] LIKE '*" &...

Hi Pat Hartman. Thanks for reply. Now the search works for each entered character. What event will be correct? Thanks

Hi isladogs. Thanks for reply. That is my first Access project. What need to do to index the search? If do you mean indexed table, so yes all my tables is indexed. Thanks

Hi All. I created search filter for continuous form. That is search/filter code: Private Sub txtSearch_Change() On Error GoTo errHandler Dim filterText As String 'Apply or update filter based on user input. If Len(txtSearch.Text) > 0 Then filterText = txtSearch.Text...

Hi theDBguy. Thanks for reply. Good idea. Strange why I didn't guess by myself. I created txtBox with height and width equal 0 and created Click event them in case click on buttons with triangles where I set focus on that txtBox. Thanks

Hi All. I created continuous form with option for label header to sort it. And replace inside of label two buttons with arrow up and arrow down. In case when I click label to sort form in ASC order upper triangle will hidden. When I click label to sort form in DESC order down triangle hidden...

Hi arnelgp. Thanks for reply. This is a very useful and interesting example. I will try to understand this code. But is it possible to create two toggle buttons in the field header label like in your sample? A one of the button with a triangle up and another with a triangle down. If you click on...

I created continuous form where one of the field is date value field. I would like to create sort option by click header label of the field. I will appreciate if someone will show how to create code to sort fields of continuous form. Thanks

Hi arnelgp. Thanks for fast and helpful reply.