Search results

I am having problems editing pass through queries. I have several stored procedures set up on an SQL server and pass through queries set up in access. Each stored procedure uses 3 input parameters (2 of which are datetime data types). The queries run when I manually enter the parameters in the...

hi guys, I was wondering if anyone knew of any VBA code that would close all open forms. I've put a messagebox in my coding that will pop up whenever there is an error, close the active form and return to the main menu, but I'd like to close all the open forms and then return to the menu...

Hi, I'm having trouble with an append query. I've got one table (table2) in which i have done an unmatched query to extract rows that are different from the original table (table1). I want to put the unmatched rows into the original table. i.e. original table = table1, new table = table2...

I'm trying to do an unmatched query between two tables and joining several fields, but it shows every row that has a blank field in either table to be unmatched even when both corresponding fields in the join have no data in them. I want to show all rows that are unmatched in the join even if...