Search results

That sounds about right, how do you go about doing that!?

Thanks for the response. I know the holding table isn’t the best way to do it but it’s what I’m used to. I basically use that holding table to house the data and then I auto generate a receipt with the info registered which is expected and saved in odd and then attached and emailed to an email...

Hi, I have a registration form and a field on it for the user to add a number, could be any amount, probably usually between 1-50 but could be as high as a few hundred. The table has an auto number field which is used as the sample number for the record. What I want to do is to add a number in...

Hi Static, ok prob easier to do the delete option. Thank you very much for your help much appreciated!!!

excellent static....no idea what the code does but works great in transposing the data!! A couple of questions if a may: 1. Is there a way to have the field(column) names as Info, Record1, Record2, Record3, Record4, Record5 and Record6 as in the example table with the field(column) names in...

Attached shows a slimmed version including the query generating the records and then the table with the end result in....

Hi Static, The code worked in creating a new table and adding the header column values. It then errors when trying to add the values in the rest of the columns. The header row also uses the Sample No as the header instead of "Record1","Record2" etc. the sample numbers should be in the first...

Hi Static, Yes thats correct....there will actually only ever be Header, Record1, Record2.....up to Record6. that needs to be fixed so it always has those. I will look at that code today and see how i get one. Thanks for your efforts!

Hi Static, The report is an Access report created to display the transposed data with other data which is then saved as PDF reports. These are fully designed / formatted reports. I need the transposed data to be used in a section of the report.

Hi static, i can get the transpose from ms access to excel but my issues is with the automation of it so people dont need to do a copy and paste.

Yes as i need the information in it to be transposed in excel to then be copied back into access. When i want to run this process again it errors as the excel sheet is open.

Hi Ranman. The code does open a sheet with that name. I want to make sure its closed before it runs the code?

Hi Ridders, As always thanks for your help! I was hoping to be able to automate the process so others could generate the data with just clicking on a button or two. I have created a work around where the data is exposed to excel. The user then still has to do a copy and transpose paste in...

Hi All, I have a command button which runs some code to export a query into excel and then open a few bits (not important for this). If this is run again the code errors as the excel file is already open so the new one cant be opened with the new data. Is there a simple way to close the open...

I tried the query you referenced but that groups them by the value / item in column 1. I need my new column 1 to be the field names in the query and then column 2 is the record 1 results followed by column 2 as the record 2 results etc (max of 6 records), so like below: Query results (max of 6...

anyone any ideas on this?

Lol i have no idea how to implement that on my data....newbie to all this!

Hi Galax, I dont think that will do it....i dont want to concatenate anything just turn the query on its side to display the results in a column view instead of a row view for my report.

Hi Minty / Static, Sorry missed your posts! thanks for the response. Can the code in my post above work?

Please can anyone help!? I want to be able to click a command button on a form to remove any existing data in my table so new can be added and then to transpose what ever is in my query holding the info into the table. My data is in a query called "TOA_Report_History" and i want it to go into...