Search results

Thank you for getting back to me. Was getting worried. I do have some issues to go over with you. I will send you my codes and my problems. But I did figure out some things on my own LOL. thanks

I finally did it myself I think LOL. The only thing that I need help with is. Getting rid of the Excel Footer Having the option to do more that one at a time. Right now it is set up to be the current record on the form. Thanks,

Hope you are doing well, haven't heard from you. How do I export to excel but want rows instead of columns. I tried googling it and haven't yet found what I need. Not sure if this is possible. I have attached the excel sheet. THANK YOU

I know you are very busy but usually you reply either way. Just want to make sure everything is ok.

Sorry I am asking you alot of questions. Right now when I export it only does one BOM at a time which is the record I have open on the form. So in order to do each BOM I click to the next form and export that one and so on. And of course the ID is the like between data on the form and...

I got it to work and not export the ID number but I am not sure how to get it not to export the footer. I take it out on the first part of the code but there is a bunch written about the footer so I am not sure how to fix that. thanks,

Hey, I figured out what was going on. I did get it to work but I can't figure out how to change a few things on where it puts the data on the excel sheet. I have attached the filled in excel sheet. I have highlighted in yellow 1. I dont need the ID number to export on the form. 2. I dont...

error message invalid SQL statement: expected 'DELETE', 'INSERT' , 'PROCEDURE', 'SELECT' , OR 'UPDATE'. Then it stops here again Set qryDefFooter = dbs.CreateQueryDef("qryWestportExportFooter", strSQLFooter)

Sorry I am not sure what you mean.

Hi its me.. I have done pretty good so far but need a little help. I think I missed some stuff but the query has the right info thanks attached is my template 1... this is the easy one. And here is the code. it stops at this. Set qryDefFooter =...

I just found out that all my field names need to be changed we have a new system this is why i have to get this rolling. We need to upload all our BOMs to the new system so I need to export like we did before so i can upload from excel to the new system but there is different steps to do it...

So sorry its been a bad few weeks I am not all with it right now. I didnt try the code because the name of the fields are different. That is what i was having trouble with. I wanted to try to do it myself and change the field names and run it. I can work on that and see if it blows up LOL

I want to do exactly what we did before but there are more fields from the main report and the subreports are basically the same but I only need a couple fields for that.

No problem at all... thanks,

Sure no problem... I went back so I could remember how I sent you everything. Here is the current codes. thx Private Sub Command579_Click() Dim dbs As DAO.Database Dim qryDef As DAO.QueryDef Dim qryDefFooter As DAO.QueryDef Dim strSQL As String Dim...

Here is the template and here is the paths Template S:\Allfiles\GLBT\BOM EXPORT Saved S:\Allfiles\GLBT\BOM EXPORT\BOMS Let me know if I am forgetting something, I went back to all our post to make sure I give you what you need. thank you

Here is the screen shot of the form. i will work on the template today and the path for that. Here is the SQL statements. Let me know what you think. thanks, MAIN REPORT SELECT MODELS.[MODEL PART NUMBER], [CUSTOMER BOM'S].[CANVAS PART NUMBERS], [CUSTOMER BOM'S].[CDI DESCRIPTION], [CANVAS...

Sorry about that I just had to get it together. I have the info, I will send it shortly. thanks,

Hi its me again. I was wondering if you can help me with the same export reports to excel. What you did it working great. I want to do this in another database but it has different names and such so I was trying to do it myself but I think I am in over my head. I need to do the same thing...

i sent the file