Search results

Hi, I have a form that has a subform with a filter. VBA is this: Me.Filter = "([house_number] > " & [Forms]![bulk_add_complaints2]![start_number] & ")" Me.FilterOn = True Me.Requery The input name is start_number and the database field is house_number. When I press the button for the filter...

Hi, New with Access forms. I created a split form with a search box where I can filter the results. Now I want to create a button that I can insert new records based on the results of the filter (for example, for all those clients in the subform, I want to insert records in a new table of...

I have one table that contains many duplicate rows. The duplicates will be identified based on matches on first name, last name, email and/or phone. The rows also contain a column of data in a column called "data". This is a text field. I need to merge the duplicate rows into one row but...

A bit new to VBA. I have a union select query that users a hardcoded date in both sections of the union query (the date filter is on the same table for both parts of the union). I would like to implement that when the query is opened a popup first displays asking for the start and end dates...

I have a datasheet that pulls from a query, and one of the fields is a combo drop list. That combo has a filter on the row source so it does not display all the possible values that can be contained in the field. The issue is that the datasheet will now display a blank field for those entries...

I have a form that I am using in datasheet view. This form has as the control source a query that join two tables in a one-to-many relationship. Recently, when I try to add a new record via the datasheet it does not let me update the second part of the join, with an error "No corresponding...

I have a database I took over, that generally uses linked tables to a MYSQL servers on another machine. The Access database uses a machine DSN to connect. There are many queries that contain references to linked tables using another name. For example, the table is "service unit" but the queries...

I am new at Access programming, and am having some trouble with some VBA code that I think there probably is a simple solution. I am trying to set a property on a function that uses a variable from a query. Here is what I have so far: Private Sub Command2_Click() Dim strFilter As String Dim...

I have two tables: one with user records, and one with user complaints. I have a form that you can enter complaints. In the form, I want to: 1. Be able to add new records via the form to the complaints table via the record navigation option. 2. Be able to load the user's name from the Users...