Recent content by ryan_kos

I just got a form that will ask the user for the path of the file, and the name of the table to save it into. If this is what you want I can email you the form.

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...

Sorry to keep bugging you RedSkies, but I have a question. I've got both the queries to work now, but when I go to do the report, there are no fields for me to select. Am I doing something wrong? Thanks again, you've been a great help.

Thanks for replying RedSkies, its working great so far! I didn't know you could base anything off of an action query.

I'm Sorry, Richard, I didn't mean to hurt anyones feelings.

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...

For this project, I inport an excel file into access. THen I sort run a report on the inported data. This report sorts the data according to sub headings and is supposed to highlight the duplicate fields in each sub record.eg. Serial # 123 unit 14 unit 14 the 2 14's should be...

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...