Recent content by partizan82

the bat file will be on your computer.... so the schedual tasks will work... in copy command just use the path to the file you want to copy... it can be on the network too... works for me... must work for you...

Write a bat file... something like copy c:\....\yourfile c:\.....\backup\ and set up your schedual task to run your bat file, that's it....

Helen, You can save it in any format you want... all this [SaveFile = ExcelApp.GetSaveAsFilename("LT_Report", "Excel Workbooks (*.xls), *.xls")] does is getts the destination of the file and it's name and gives it default extantion... you can put your extantions to "Rich Text Format (*.rtf)...

This is what i've used... Dim ExcelApp As Excel.Application Dim SaveFile As String Set ExcelApp = CreateObject("Excel.Application") SaveFile = ExcelApp.GetSaveAsFilename("LT_Report", "Excel Workbooks (*.xls), *.xls") If SaveFile <> "False" Then DoCmd.OutputTo...

Mcgrco Try this: Repdate = CDate(your_string) Make sure you declare Repdate as Date... Good luck. Anton

Thanks everyone the problem was solved by using this code... DoCmd.OutputTo acOutputQuery, "LeadTime", acFormatXLS, "LeadTime", False Set ExcelApp = CreateObject("Excel.Application") ExcelApp.Visible = True ExcelApp.Workbooks.Open ("LeadTime.xls") ExcelApp.Cells.Select...

SteveM, Thank you for your reply... what you told me i knew before... my question is: can i do it automatically when excell opens up so my users don't have to do it all the time... maybe there is some script i can use in access for excell to do it automaitically...? P.S. I created a macro in...

Hello everyone! I have a code that outputs the rusults from a query to excell... no problem here :cool: ... the problem is that excell does not show the whole record in a cell untill i change the width of the column... So is there any way to automatically adjust the width or maybe the hight of...

I did that and it works in a query, but it does not work in my sub... anyway, i solved the problem... it was a search query and i did not put a record set to output to... that was the problem... i'm always slow in the mornings... sorry to bother you with that... Thanks for help though...

Hello everyone. I created a script that will generate an SQL script based on search criterias that user enters in a form... A funny thing that it looks ok in a message box just before i ran it.. but then it gives me this kind of error: A runSQL action requires an argument consisting of an SQL...

Thanks, i already found an answer... zero value for date type is #12:00:00 AM#... that's all i needed to know basically... and my query works now....!!! thanks anyway

How do i check if variable's value is zero for date type? i tried this but it does not work: if me!DateFromControl.value <> 0 then blah... blah... end if gives me an error... Please help.. any suggestions will be appreciated. Thanks.

i want to do it in vb... it should be pretty simple... basicly open the table -> find the right user -> change the password for it... but i don't know the code.....

I want to find a record in first column <Employee ID> of a table <Employees> and then change the corresponding record in a second column <Password>, is there a function similar to DLookup but the one that changes values? Please help... thanks [This message has been edited by partizan82 (edited...

It works... Thank you very much scottfarcus! P.S. Best forum ever...