Search results for query: *

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?

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...

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...

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...

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...

Anyone no how to compare a list of image files in a windows directory to a list of image names in my db? Also, if those image names do not exist in the windows directory I need to delete them from the directory. Thanks

I have my database split, tables in one (Data DB), forms query’s and modules in the other (Application DB) . In the application DB, including my linked tables to the Access Data DB, I also have linked tables to SQL Server and dB tables. This leads me to two questions. Where should I define my...