Search results

The following is code that will remove the carriage return and replace with a space: Sub RemoveHardReturns() Selection.find.Execute Replace:=wdReplaceAll With Selection.find .Text = "^p" .Replacement.Text = "" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False...

When you import data from Excel, you will have the opportunity to specify information about each field you are importing from the spreadsheet. You first have to tell ACCESS that you have field names in the first row of the spreadsheet. These would be the fields you have described in your...

When I copy worksheets from excel file 1 to excel file 2, I create a link between the two files. If I open Excel File 2 after I save and close it, I will get a message telling me the automatic update of links has been disabled. I decide the click on ENABLE; therefore, my link to excel file 1...

Even though I am very familar with writing SQL from scratch, when I am working in Access, I don't usually build the query myself using SQL, I let Query build it for me. I just wanted to show Steven that the left outer join was possible and how to do it. Glad everything worked out well.

The following Query is a left outer join. It is telling us to return all the records from the table on the left and only those in the right tables where the joined fields are equal. I am able to return ALL the records from the left because I have included an expression that says if you don't...