Search results for query: *

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.

I need to append a footer (1 field as a string) to the last line in an existing text file that i have exported via DTS. I have been looking at the Writefile transformation but can't seem to get it to work. Thoughts

I am creating a simple DTS Export from a table to a .txt file. I am having a strange issue. When I choose the destination, the define columns box comes up and I choose to populate from source and execute. When I do nothing happens...meaning it does not show the fields in the destination box...

I am trying to create a query that will return records by a given date and time range. The query thus far is as follows: SELECT DISTINCT Orders.ApprovalDate FROM Orders WHERE Orders.ApprovalDate Between #11/21/2004 15:0:0# And #11/22/2004 14:59:59#) This works just fine. The problem is I...

I have been running a batch process through the windows scheduler every morning. I just implemented security on the db so I am switching to HAL I was wondering if you still have to call the HAL schedule (.hal file) from the windows scheduler or do you just set up the schedule and leave Hal...

Yes, my DB already exists. Basically what I need to do is remove any special characters (i.e. #, &, *, etc.) in the image name in my db. Got that taken care of. When I remove the characters, the image name will not match the file name in the windows directory. I need to be able to rename...