Search results

Just over 3 mb ILL TRY AGAIN EDIT: OK IT LOOKED LIKE IT WORKED THIS TIME...I SAW IT SAY UPLOADING.

ok i sent it, its a zip file

i tried to upload it and it would let me said that a security token was missing???? edit: i dont mind extra work at all as long as we get this to work i will be sooooooo happy.

ok I have linked tables but I will change that so I can send it.. thank you so much

What file would u need.

Well im not sure if i got it working. it doesnt say the parh is wrong it hilights on the word format. Tjen i played around with it n took some quotes out. It ran thru the code but no qry was produced so no data was sent to the template n saved to the bew one. So im thinking changing the Me...

This is where it stopped after i made the change. xlWSh.Range("I1").Value = Me.ID It highlighted on Me. EDIT: IT SAYS INVALID USE OF Me KEYWORD EDIT: I think I figured it out I just changed the Me to the Form name and it work now it stops at this. xlWBk.SaveAs "N:\EXACT...

ok did that n it stops at this line ‘Set xlWSh = xlWBk.Worksheets(strSheetName)

ok I did that and it worked now I have this error. Here is the error message RUN TIME ERROR 3012 OBJECT qryWestportExport already exist then i debug and this is where it goes. Set qryDef = dbs.CreateQueryDef("qryWestportExport", strSQL) thank u

Ok I pasted the code in the form module (not sure if I did that right).... I made the command button and pasted in the code then click on to test and It stopped when it got to this line in the code DoCmd.DeleteObject acQuery, “qryWestportExport"

Thank u so much I will do it 1st thing in the morning. I appreciate this so much.

HA mine does too lol. thank you very much

Hey thanks you have been working hard. the control source names are the same name. I didnt use a filter. edit: but it should be the ID because that is how the Main form is linked to the sub forms right??

No just me Thank you so much

Hey, final got into my server now that I am at work. Here is the path for the Template and saved one Template: G:\SUE'S STUFF\WORKING DESKTOP\2016 WESTLAND\WESTLAND EXPORT SAVED: N:\EXACT FIT\WESTLAND EXPORT PLUS I also made a new database 2010. Let me know if you need anything else. thank...

So sorry my server was down so I couldnt log into my work computer. I let my IT guy know but I haven't heard back from him we don't work on Fridays we work four tens Monday through Thursday so when I want to do some work I have to login from home so as soon as I can get on I will get back to...

Awesome ty u r great.

Ok I will make a new database. I will get back with u on the path I have to log into my work computer from home n get the path. Not sure what time zone ur in but its 9.25 Eastern time US...I will try to get that before I go to bed if not 1st thing in the morning...thank u

Can I creat another database in 2010 n link the tables n import the queries.

It is a .mdb