Search results

Hello, I want to run a query on an MS Access database table on columns where number are used as coded for building descriptions e.g. for roof type: 1 = concrete 2 = zinc 3 = tatched What I want to do is to return the result as the string. Is this possible using a single query in MS Access...

Hi Ms Access experts, I have two tables that have identical schema and one table has a subset of the data that exist in the other. I want to select the data from the first table (table1 say) that does not exist in the other (table 2) using a query of the form: select * from table1 where...

I am creating an application with a parent form and a subform that contains a datasheet. When a button on the main form is clicked I want to initialize certain fields on a new record in the datasheet then set the focus to the next field. I use the following code: Private Sub...