Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. florens

    Problem with loop

    Thank you very much, it works like a charm.
  2. florens

    Problem with loop

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

    security problem with a FileUpload

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

    Problem with loop

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

    How can I get a sum in the where clause of an update?

    Thank you jbenson001 and maswien. A combination of your suggestions let to the answer. I now insert my id's into a temp table, 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 :)...
  6. florens

    How can I get a sum in the where clause of an update?

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

    How can I get a sum in the where clause of an update?

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

    datarelation with stored procedure

    I've got a problem with making a datarelation in asp.net. I've done it on other pages, but on this page, it just won't work which kept me staring myself blind on some code for the last hours. This is my code in vb.net: 'Set SQL Stored Procedure name... mSqlString = "exec klantGetKennis...
  9. florens

    Editing a datagrid within a placeholder

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

    Insert and view pdf in Filemaker 6 Developer

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

    only show 10 newest records

    It works like a charm, thanks again.
  12. florens

    only show 10 newest records

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

    only show 10 newest records

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

    If combined with VLookup

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

    If combined with VLookup

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

    Excel: If statement

    Thank you very much. It works perfectly! Florens
  17. florens

    Excel: If statement

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

    Excel: If statement

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

    Excel: If statement

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

    Can this macro be created in Access 97

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

Part and Inventory Search

Back
Top