Recent content by carrie09

Thanks Guus... It does work for the numeric fields however I have some text fields as well so this expression won't work for that. Any other ideas? Maybe some way using the If statement...Not sure..:(

Thanks Guus, I tried it but still no go. Just to make sure, i'm pasting my query below for reference. Maybe i'm doing something wrong: SELECT [Table1].Col1, [Table1].Col2, [Table1].Col3, [Table1].CustNum FROM [Table1] GROUP BY [Table1].Col1, [Table1].Col2, [Table1].Col3, [Table1].CustNum...

Thanks for ur response. However crosstab query won't work in this case. Can you suggest something else?

Hi, I have a query that selects values from a table and I'm further creating a letter based on this query. The problem i'm having is that if the query pulls 3 rows as result then it creates 3 separate letters. Basically this is how the output of query looks: (refer attachment) Is there any...

Thanks Gblack..this does seem like a good piece of code. Guus, this code refers to a macro in excel that basically generates the complete file but i haven't included it here as nothing needs to be changed in that. The only requirement is to include a code within the code i pasted towards the...

Here u go Guus... This is the code thats working correctly. Only thing I need to modify is the file open condition I mentioned previously. Public Function getrmpricing() Dim queryoption As String Dim Msg As String Dim fs As Object Dim sTemplateFile As String Dim e_TemplateFile As String Dim xl...

Hi Guus, Thanks for ur suggestion. U r right. I wanted 2 strings...so I corrected that and also grouped all my variables in beginning. However I'm still stuck with the initial problem. The code works fine without errors. The only problem is that if its run again without closing the sheet...

I tried to make changes to my code using the reference links you gave but its not working correctly. Below is the code. What is does is: 1. Open a reference template template ".XLT" from a particular location. 2. Run the query and output its result to this template and call it...

Thanks a lot for your reply Roy. I made changes as per your suggestion and the article you mentioned. However I'm still having trouble running this report again. Will you be able to make changes to my code file so that I can be sure that I'm making correct changes? If thats not possible, then...

Can someone please help me and tweak my code accordingly?

I'm sorry Guus but I'm a beginner and am unable to make changes to this code correctly. I'm thinking the code as well as macro will have to be changed. So I guess it will be easier to just include the first option about giving users a message if file is open and run the code once they close...

Hi, I have a form that is used to run a report in excel using a template based on user selections. So there is a VB code and a macro that is used to update the file with query output. My problem is that when the user makes a selection and runs this report, it runs fine and creates an excel...