Search results

Hi Guys, Im trying to loop through a query results to extract email addresses from a query result. I have the following code NameCriteria = Forms![MainMenu]![tbl_Course_Details]![Course_Name].Value DateCriteria = Forms![MainMenu]![tbl_Course_Details]![Course Date].Value Dim db As...

Hi, I have several queries that I want to export to Excel. However when I i use the DoCmd.TransferSpreadsheet acExport command it exports but removes all formatting. A few of the columns are Currency is there any way to export and maintain the format that they are in access? Thanks Mike

Hi have a table like below Name Jan Feb Mar ect A 1 2 4 5 B 3 4 8 8 C 5 5 9 7 D 2 7 8 8 I want to swap this so it looks like this -----A B C Jan Feb Mar etc Can anyone let me know how to do this? Thanks Mike

Hi can anyone help me? I have this table tbl Overdue Report Count HistoryOverdue WithJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberNorthern Region211211211211211211211211211211211211TI120120120120120120120120120120120120 I would like to dispay this in a graph...

Hi guys, This has been driving me crazy. I have a query that runs and the results come up in a datasheet. Now there are times where certain criteria are met when I need certain columns to be hidden. I cannot for the life of me figure out how to do it. I seem to have tried everything...

Hi Guys, I have an access database and I have a used a form so that the user can input variables into a query. What I would like is to have a form that has all of the fields on the query so that the user can tick or untick fields that they would like to see in the query output. I am guessin...

Hi Guys, I have an access database and I have a used a form so that the user can input variables into a query. What I would like is to have a form that has all of the fields on the query so that the user can tick or untick fields that they would like to see in the query output. I am...