Search results

Yes, but I believe this only works if you want to print it - which I don't, I want to see it in report view and when I export it to PDF

I am using this method to export the report, but the one I want to set to 2 columns is a subreport of this one... How can I use it?

Hello, I have a report with few columns but plenty of rows and I would like to display it in two columns. When I choose the format in "Page setup" it applies it only to the printable view, but I would like to know if it is possible to have it always displayed in two columns (in report view or...

Just what I needed! I changed xlApp.DisplayAlerts to match the code I had and works perfectly

I don't think I can choose that because my records are distinct - it is only that field that is repeated. Let me put an example with the following table, which would be my query: ID user ID computer Computer model 0123 gh34 Mac OS X xxx 9876 51fg Mac OS X xxx 5698 wgg5 Windows... I...

Sorry I didn't specify this. I am exporting query from Access to Excel so I want to merge the duplicates with VBA so that the user gets the proper output without having to edit the Excel

Hello, I am trying to compare the value of a set of cells (rows 85 to 200 of column 5), so that if they have the same value the cells get merged. I have tried this code but it doesn't work. This is part of a code that exports some queries using CopyFromRecordest, so this loop is inside the...

From what I have read I strongly believe it is normalized: there are independent tables for each group of repetition, foreign keys to my main table and all the attributes of each table depend on their primary key. The group type is an independent table which gets "called" through a foreign key...

This was very useful, thank you! However, I am not getting the third argument right, how should it be to serve my purpose here? I tried this in a query but it doesn't work: FieldComposition: ConcatRelated("[Material]","[Materials]","[ClothName]=" & [ClothName],"",Chr(13) & Chr(10))

Yes, I think that would be it. I have never used this function, how would be the syntax to join all the materials of a cloth? I want to create a field (in the clothes' table or in a query) that lets me display in a single field/string the list of materials for each cloth

Hello, I was wondering if someone could give me a hint on this one. I have created a sample db to exemplify my doubt better. So I have a table "Clothes" and a table "Materials" and a third table where it is specified what materials compose each garment. I wanted to know if there is a way to...

An example would be, taking the picture I posted on the first post, that there was a pair Index-Event with no type specified. In my process, first I define which indexes go with which events and in a second step, decide whether to assign a type and which ones. When building the query, it will...

But I want to display the blank indexes (row with no type marked) in the query, it's just that I don't want the column "<>" to show

Hi again, I have a little issue with this code: when it creates the query, it creates an extra column for the indexes where no type has been registered. How can I delete or hide this column? I do not want it to appear in the crosstab query. Thanks

Solved, with a bit of patience and doing everything in the correct order as Pat said... Thanks for the help!

Thank you very much for this. I studied it thoroughly but still can't find a way to put the crosstab query rows in the same order as the attributes of each index when exporting it...

I have tried this, even copy-pasting the query and hiding the original fields to only show the "related ones" but still does not put it in the same order...

Hi, the crosstab query I want to export was defined in a previous thread: Here I defined a field called "Index". Now what I want to do is to export this query (among others that are not relevant nor related to this one). I have tried giving the same order of clauses and it doesn't work. I have...

This is the code I have used with the corresponding references set: Private Sub ExportToExcel_Click() 'Variables to create Excel App Dim xlApp As Excel.Application Dim xlWorkbook As Excel.Workbook Dim xlSheet As Excel.Worksheet 'Variables for data retrieval Dim db As DAO.Database Dim...

Hi, I wanted to ask if there is a way that I could export this crosstab query (Thread on crosstab query) to Excel using VBA along with some attributes of each index and depending on the Event (using a parameter). Thanks