Recent content by mlabac

I do not have acces to the UNC, just a url. Any way to do this in access?

I need to display a linked image on a form. I know how to do this if I point to an image on a server. I need to point to a url as the images are not stored on my local server. strImage = "http://www.imagelocation.com/img/320477.jpg" img_Image.Picture = strImage Can this be done in access?

That worked!!! thanks for your help!

I need to write an update statement that updates POExtendedTotal grouped by the PONumber with the sum of ItemExtendedCost I believe I am on the write track as my select statement is returning the right results, but the update statement does not recognize the alias SumOfItemExtendedCost UPDATE...

I have written the following procedure to retrieve a .csv file from a website. The procedure works fine, as I use it at other sites to download .csv files on a scheduled basis. The problem with this particular site, is that for security reasons they change the name of the daily. Today the...

Thanks for the help...got them backed up!

How do you back up DTS packages? Are these stored the master DB? I currently back up all the user and system DB's. Is restoring the DTS packages as simple as restoring the master DB? Thanks

I am trying to set up my first replication ever. I am going to be setting up a replication between our server onsite and publish a few tables to an offsite server. I am going to use the onsite server it’s own distributor. In the Configure Publishing and Distribution Wizard i select my...

Got it figured out... Dim myExcelApplication As Excel.Application Dim myExcelWorkbook As Excel.Workbook Dim myExcelWorksheet As Excel.Worksheet Dim myExcelChart As Excel.Chart Set myExcelApplication = CreateObject("Excel.Application") Set myExcelWorkbook =...

Ok, basically i am trying to create a DTS package in SQL server to import this csv file. When I try to import it it can not delimit the fields unless i open the file and save as csv leaving out any incompatible features. Since i have to open and save as i would prefer that it be in a tab...

how do i open the csv file?

Sorry...should have giving more detail. I can open the file in excel and save as a txt file...but I need to do this automatically through VB. Thanks for the quick reply!

I need to convert a csv file to a tab delimited txt file. Renaming the file does not work. Thoughts? Thanks

I have a csv file that I need to import into SQL Server. I download the csv automatically. I am trying to create a DTS package to import in to SQL Server. DTS can not delimit the fields unless I open the csv file in excel and save as a csv, then the dts package can delimit the fields and all...

Figured it out...pretty easy Wrote an ActiveX script from DTS Set fso = CreateObject("Scripting.FileSystemObject") Set f = fso.OpenTextFile(Path, ForAppending, False) f.Write strFooter f.Close Appends the string 'strFooter' to the last line in the text file.