Search results

Hi Experts, I don't have a problem, but am just seeking advice. Usually in my VBA procedures, when I need to run a query, I build an SQL string and then do a db.Execute (strSQL)This allows me to put in variables into my query string. You all know that. This usually involves declaring the...

[SOLVED] INSERT INTO SELECT statement Hello Experts, Here's my challenge. I have an append query that contains an IIF statement. I want to code that into a VBA function. The SQL view of the query looks like this:INSERT INTO tmpAvailInv ( NUID, Inv_Name, F_Name, M_Name, L_Name, Role ) SELECT...

[SOLVED] Select a Record on a Search Form Hello again, Experts, Attached is a snippet from my search form. I have a search on Last Name, and in this example, I use Last Name beginning with "m". That pulls up two matching, filtered results, Mickey and Mimi. All the controls in the detail...

Hi Experts, I created a search form. It has 6 unbound text boxes and 2 combo boxes in the header. Users can select values from the combo boxes and/or enter names in the other text boxes. These values all go into a filter on my Main table and the filtered results show up in the detail section...

My users are clever enough to find problems that I'm not smart enough to solve. I'm using Access 2007. My macro runs a query and opens a report. If the user closes the report and goes back to the form, they can choose a different report, and everything works fine. However, my users will open...

Access 2007, split database, 9 users. I have been able to link the BE tables with the Linked Table Manager. I use the DNS name path because everyone has different drive mappings. I can open my linked tables as a RecordSet and AddNew and Update records. However, I cannot Seek and Edit the...