Search results for query: *

Thank you very much, it works like a charm.

Thanks for the quick response, I've used your code and altered it a bit to fit in with the rest of my code. I was actually using an arraylist and not an array (I'm not sure what the difference is, but I can't seem to get data from my datareader into an array, but I can get it in an arraylist (at...

I've had the same problem as you did, for me the solution was to add another user to the target folder. This should be user ASPNET, give it write permissions (might wanna try with full access first) and try again. You can add this user in windows by browsing to the folder, selecting properties...

Hi, I've got a bit of a problem and I can't see how I should fix this. I've got two tables in my database, pages and pictures. In the pages table I store the content of my webpages, and in pictures I store the filename of my pictures and the page_id. Now through some simple CMS page users...

...then use something like maswiens update code to update my contract table and after that I empty the temp table. Works like a charm, a slow charm, but a charm it is :) *Slow is not a problem, it only happens once a day and that person knows he has to wait about 10-15 seconds, so no problem at...

Thanks for your reply. I've tried this, but since the select statement finds more than one record I get an error that it's not possible to have a subquery returning more than one error.

I have a table: contract. Each contract has a total number of hours. When work is done within a contract, a user registers the number of hours he/she worked. This happens in the tabel: register. I want to send a daily e-mail to management containing all contracts which are low on available...

...= dv hgKennis.DataBind() My stored procedure: CREATE PROCEDURE [florens].[klantGetKennis ] @KlantIdIn int AS /* get kennisgegevens */ Select kennis.kennisverzekering_id , kennis.kennisverzekering_naam ...

I'm loading a page: address.ascx in a placeholder on customer.aspx (i'm not actually working with these files, but this makes it easier to understand without knowing the background of my organisation). Anyway, this works fine. On address.ascx there's a datagrid. When I want to edit data inside...

I'm building an application which has two main tasks. 1. Controlling data about our clients (name, adress etc.), 2. Send letters (by template) to clients. (this template will either be in Filemaker or MS Word (not definitive yet). Our clients all have their own logo's which are stored on .pdf...

It works like a charm, thanks again.

Thanks for your reply's. I'm unable to test it right now, but I will test it asap and keep you posted.

Hi there, I'm quite new to PHP, but I am trying to build a site which shows news items(which I insert myself). I store the newsitems in a database. I can extract the news items from the database but I only want the newest 10 to be shown on the site. The others should be archived in the database...

Thanks for the reply's. The communication here isn't always at it's best so during the time that I tried to fix it in Excel, someone else just printed both sheets and manually fixed it. Since this is a one-time activity I don't need it anymore. Sorry, and thanks for your time.

Hi all, I've searched this forum for a while to find my answer and I didn't quite get it. I have an Exceldocument with two sheets (sheet1 and sheet2). On sheet1 I have some data with a key in columnA and a name in columnB. On sheet2 I have some other dat with a key in columnC and the same name...

Thank you very much. It works perfectly! Florens

You're right, Source data should stay source data. I hadn't thought of that. It all works fine now, the only thing that remains is that for foreign countries the zip should be pasted infront of the city. I've tried to do it like this, but I get an error: wsNew.Cells(c.Row, "I").Value...

Skip, thanks for the quick reply. Why do you suggest a new sheet? And I have runned your code (ofcourse, after I entered the right values at the question marks and compiled it without errors). But Excel crashes at the eight line: wsNew.Cells(c.row, "I").Value = wsOld.Cells My...

Skip, thanks for the reply. I know that the problem is much deeper, and I have told my boss that, but it is very expensive to replace the application with a working one ( :) ), so that will take some time. And untill that time, I need to stick to copy-paste :( I've tried your code, and I need...

This is possible. Make a query that deletes all data in the table and have the macro run the query. Florens