Recent content by mr moe

Thanks. But i'm trying to open the query in excel without saving it. thanks for the help!

well Transferspreadsheet you would have to save the file into a directory before it opens and this is what i'm trying to avoid. the line above works perfectly but only for one query to one workbook as sheet1. I"m trying to have two queries into the same workbook as sheet1 and sheet2 using same...

this codes works for one query to be exported to one sheet in excel, Im trying to export anther query as sheet2 in the same excel file. Any help?

Dim MyDatabase As DAO.Database Dim MyQueryDef As DAO.QueryDef Dim MyRecordset As DAO.Recordset Dim i As Integer 'Step 2: Identify the database and query Set MyDatabase = CurrentDb Set MyQueryDef = MyDatabase.QueryDefs("output_qry") 'Step 3: Open the query Set MyRecordset =...

hello, i'm currently using this code to export an access query to excel, the query name is output_qry, it exports it to sheet1 and opens excel automatically. i have another access query that I want to export to the same workbook as sheet2. how can i do it. here is the code below that works for...

thanks i fixed it, i needed to put a space before the from and having.

hi thanks for your help, im still getting the same issue, it appears to be a punctuation error but i can't fiqure it out still :(

hi guys i'm getting an error msg number 3141 and been trying with no luck. Could anybody please help. below is the code. Dim RS As DAO.Recordset Set RS = CurrentDb.OpenRecordset("SELECT Count(request_tbl.request_tm_num) AS Ticket" & _ "FROM (SELECT DISTINCT request_tm_num, analyst_id FROM...

sorry for the late reply its access 2016, i'm trying to color code if the value is less then one"100 perecent", thanks.

Hello, is it possible to create a vba code to make the data label color change based on the value. This is for a column graph in ms access form. I can format the data label or the column color based on series value. Thanks alot.

Hi Jack, thanks for help, it's still not working, it opens excel in as blank, i even made my query to one column with a normal field name but still, my problem is from copyfromrecordset its the excel part of my code that is not working i believe, im checking the tem query i'm creating and it had...

wow so interesting i was looking to do the same today and had to google and i saw this post that was created by me :) anyone has resolved it? btw thank you so much Frothingslosh i know it's very late to say it now, wow sometimes people realize their mistakes after so long :)

Hi I have a table in access with this format ID Grade 1 A 5 D 6 B 1 B 5 C need to write a query that produce the output like the format below ID Grade1 Grade2 1 A B 5 D C 6 b can someone please help, basically looks like the opposite of transform right?

JHB your suggestion did help, after commenting the on error, the debugger is going to "Set MyRecordset = MyQueryDef.OpenRecordset" with error msg Object Invalid. Thanks again. I know where to start.

And i could careless if you even try to help me again. You're even asking me for my query query fields loool so funny what does that do to you. This is my post and i dont expect yo to even reply back please leave my post. Thank you JHB for meaningfull reply.