Search results

Hi, I am need to import an Excel spreadsheet into my data base. I do this with the Transfer Spreadsheet macro. My problem is that I receive this file monthly, and it must be saved with a different file name. Is there an easy way to ask the user to imput the file name, rather than modifying the...

In my database, I import a table from excel, then put it into a report. The report sorts the data according to sub headings. Then, if one item in a sub heading is the same as the next one, both of the items are highlighted. eg Serial # 123 Unit # 14 Unit # 14 Both of the 14's should...

I am trying to run a report that will highlight the duplicates in my table. I have already tried a find duplicates query and that is not what I want. I need somebody to tell me how to use code todo this procedure: look at 1st item look at next item if they are the same highlight them both...

I need code that will highlight duplicates when I run a report. So far I have: If (Me![Description] = Me![Description]) Then If Not Me![Description].FontBold Then Me![Description].FontBold = True End If Else If Me![Description].FontBold Then Me![Description].FontBold = False End If End If Now...