Search results

Well I got it to put in the labor time but i think i can re-work the template to list the Cut Sew etc... let me play with it and I will get back to you.... I think I am getting good at this.... but I am sure you have a way to do codes but this may be better and less work... You ROCK BTW

OK I WAS PLAYING AROUND WITH IT AND I AM A LITTLE CONFUSED LOL.... I WATCHED A YOU TUBE VIDEO TO TRY AND FIGURE IT OUT BUT WAS UNSURE... CAN YOU GUIDE ME :) MY HEAD HURTS.... lol

its the footer query that has this information...which comes from my query that holds the labor information. in the code strSQLFooter = "SELECT[PART NUMBER], Expr6 " & _ "FROM [BOM PRICING EXTENDED DETAILS LABOR SEA RAY]" Does this have to be a crosstab query???? this is where...

damn...the template has to be like this for the upload to work in our new system.....i was hoping not to do this manually when the excel sheet opens. that would be some work...can you think of any other way.....your my miracle worker :)

I had to run it without it deleting to see but its a select query...

Hey, Sorry to bother you but did you have a chance to look at this thank you very much.

Awww thats ok.... thank you for reviewing it...

hi there Have you had a chance to look at this...I know you are probably busy. I think I have it just about set I HOPE except for this issue.

Hi there hope you are doing well. I have been working hard on this myself and I really think I have got most of it figured out except this footer. Well it turns out I need it but in a different way. What I need is the data to across columns not down and i dont need the ID. Can you help...

i went over this again and again...put the old code in runs fine then take out the foot information and excel doesnt open.... i am at a loss, i have to get this figured out. :(

I don't get it either. I put the old code back in and it worked except of course it places the footer there. Have you come up with an idea on being able to do all records?? thanks,

Sorry no I didnt have it open cant really explain how it happened but anyway. I tried to figure out why its not working since all you did was take out the footer n it was working before that but I didnt figure it out.

ok so I thought maybe it would work today LOL so I exported but I pick one that didn't have data in the bom and didn't pay attention but when I opened another excel sheet I needed to see I closed it and there was the template open...weird right??? and of course all it had was the part number...

The path is correct

The data does not go to the template

Ok i did that the query opens and the data is in there....

OK put the new code in and still nothing and no errors weird. OK I knew that might me a problem doing all data but there are so many I hate to have to do them one at a time yikes. Thank you for trying to figure that out.

I pasted the new code but it did not export to excel or open the it. And there was no error message. To answer you question, I dont need them to be in separate workbooks when all records export. thanks,

here is the spreadsheet

Ok I have 4 different Codes and templates for each. Lets do one at a time. This one works fine except 1. I dont need the footer information at all. Not sure how to get rid of that. I have hi-lighted it on the spreadsheet. 2. Right now it is set up to do the record that the form is on when I...