Search results

jdraw, your solution was perfect and just what I needed. Thanks plog for your input too.

The issue is that the query is a groupby query and that field is not returned. What are my options?

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...

The default record source is NOT filtered, and there is a record source on this specific combo box that IS filtered. Because of this filter it's affecting display of the values displayed in the datasheet when the stored results do not match the filters - the field is blank. When I remove the...

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 no idea what changed. I was asked to fix a problem and have no idea how it used to be. :(

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...

Thank you! That was very helpful and enabled me to complete the project. :)

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 got it to work with a combo box, thanks!

Yes, exactly what I want to do. How can I do that with a combo box? I want to load the name data from another table, but there is no relationship defined between the tables in this form's source. When I define a relationship it makes the form not able to add new records.

Yes, a user can have more than one complaint. I want to do the reverse: From the form that loads all complaints and manages them, I want to simply display the name of the user that the complaint is about. The name data is located in another table than the one that the form is being sourced from.

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...